Exception Handling in EXECUTE IMMEDIATE command in PL/SQL

From: Arif Zaman <azaman_at_ibm.net>
Date: Sun, 05 Nov 2000 23:11:32 -0800
Message-ID: <3A0659A4.D1A@ibm.net>

If an exception is raised during the execution of this command, the SQLCODE is set to appropriate oracle error code but the error message returned from SQLERRM () is not the message that corresponds to the error code assigned to SQLCODE. Is it the the expected behaviour ?

For Example

EXECUTE IMMEDIATE ('delete from emp ' );

If the table emp does not exist, an execption will be raised, the SQLCODE will be set to -942 but the message from SQLERRM() will be -120 : non-ORACLE exception.

If you have any idea, please mail me at Arif.Zarman_at_icl.com.

Thanks Received on Mon Nov 06 2000 - 01:11:32 CST