OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » DEBUG ROUTINE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DEBUG ROUTINE [message #37591]

Thu, 14 February 2002 22:38

marco
Messages: 46
Registered: March 2001

Member

hello,

I am using the following code to handle my exception:

EXCEPTION
WHEN OTHERS THEN
debug := SQLERRM(SQLCODE);
ROLLBACK;
INSERT INTO ERROR_LOG (ERRORE) VALUES('Subprogram_name: ' || debug);
COMMIT;

I'd like to add more information to the error_log, so is there a function returning the row_number where the exception was raised?

Thanks,

Marco

Report message to a moderator

Re: DEBUG ROUTINE [message #37612 is a reply to message #37591]

Fri, 15 February 2002 12:50

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:513909::NO::F4950_P8_DISPLAYID,

Report message to a moderator

Previous Topic:	Add Date Function
Next Topic:	number of records in each table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:59:15 CDT 2024