Exceptions on Forms 6.0 block insert procedures.

From: <hakan_d_at_yahoo.com>
Date: Mon, 17 Jan 2000 14:11:34 GMT
Message-ID: <85v7uc$8sk$1_at_nnrp1.deja.com>

Hello all.

I experienced a strange situation regarding server-side insert procedures on Forms 6.0 data blocks. Insert procedure on which the data block is based has some critical validation code for improved security. It raises user-handled exception, say, -20101 when validation fails on a specific condition. But on the client code (Form's on-error trigger) I did not see error code -20101 and its text directly. Error parameters I got are:

dbms_error_code: -1403
dbms_error_text: "ORA-01403: no data found" error_code: 40735
error_text: "INSERT-PROCEDURE trigger raised unhandled exception ORA- 20101."
sqlcode: 0
sqlerrm: ORA-0000: normal, successful completion

Pretty confusing, isn't it? I expected that dbms_error_code would return -20101. Could somebody point out what I'm missing?

I will be pleased if your responses are also forwarded to: hakan.dombekci_at_intertech.com.tr

My configuration is (Form builder about box):

Forms [32 Bit] Version 6.0.5.0.2 (Production) Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production

     With the Partitioning and Java options
     PL/SQL Release 8.1.5.0.0 - Production

Oracle Toolkit Version 6.0.5.6.0 (Production) PL/SQL Version 8.0.5.1.0 (Production)
Oracle Procedure Builder V6.0.5.0.0 - Production PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production) Oracle Query Builder 6.0.5.6.0 - Production Oracle Virtual Graphics System Version 6.0.5.5.0 (Beta) Oracle Tools GUI Utilities Version 6.0.5.0.0 (Production) Oracle Multimedia Version 6.0.5.0.0 (Production) Oracle Tools Integration Version 6.0.5.5.0 (Production) Oracle Tools Common Area Version 6.0.5.4.0 Oracle CORE Version 4.0.5.0.0 - Production

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 17 2000 - 15:11:34 CET