PEBKAC.
It has told you what the problem is. Use a handler for an exception that actually exists. To see what these are, read http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html
cheers
andrew
Sibtay Abbas wrote:
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?
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
