hello

I am using the following sytex to handle exceptions in
plpgsql (I am using postgres 8 rc1)

....some code ........

EXCEPTION
    WHEN NO_DATA THEN      
        RAISE NOTICE 'NO DATA';
    WHEN OTHERS THEN
        RAISE NOTICE 'An exception occurred';
        RETURN emp_rec;

and i receive the following error 
ERROR:  unrecognized exception condition "no_data"

How can i rectify this error?


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to