SQLCODE, SQLERRM and SQLLINE, SQLOBJ, SQLARGS???
From: Liam Caffrey <Liam.dot.Caffrey.dot.caffreyl_at_nortel.dot.ie>
Date: 15 Jul 1998 23:31:54 GMT
Message-ID: <01bdb048$f9c65320$bb0a552f_at_nt-02188.europe.nortel.com>
Is it possible to reference interesting things like:
Date: 15 Jul 1998 23:31:54 GMT
Message-ID: <01bdb048$f9c65320$bb0a552f_at_nt-02188.europe.nortel.com>
Is it possible to reference interesting things like:
The line number affected by the error? SQLPLUS spits out this error, e.g:
insert into imdb_tbl (id, mytext) values (1, 'def')
*
ERROR at line 1:
ORA-00001: unique constraint (SMS.ID_PK1) violated
Even better - is it possible to reference the object in which the error
took place
e.g. DBMS_OUTPUT.PUT_LINE ('Error occurred in ' || this) ;
Even better again - is it possible to access the argument list to the
current object
e.g. DBMS_OUTPUT.PUT_LINE ('Arguments are' || argname[1] || argval[1]
etc...) ;
TIA
Liam
(please remove the nospam 'dot's)
Received on Thu Jul 16 1998 - 01:31:54 CEST