Home » SQL & PL/SQL » SQL & PL/SQL » Stored proc exception handling query
Stored proc exception handling query [message #41040] Wed, 20 November 2002 01:36 Go to next message
Bindu
Messages: 6
Registered: November 2002
Junior Member
Hi,
When I run a stored procedure (Oracle 8.0) I get an error like,
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "DTST_ID.NEW_TEST", line 12
ORA-06512: at line 1

But in the exception handling, SQLERRM gives me only 1 line i.e. ORA-01403: no data found. This does not give an exact picture of what went wrong. If I want all the reported lines to be taken in an "EXCEPTION" then how do I do that ?
Purpose = I want the "entire" error to be saved in a log file.

Oracle version = Oracle 8.0

Report message to a moderator

Re: Stored proc exception handling query [message #41041 is a reply to message #41040] Wed, 20 November 2002 02:15 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

When ur executing the Pl/Sql without exception

handler, it gives the error with ora-06512 and the

error line, this ora-06512 is common for all the errors

with regards,
Balamurugan.R

Report message to a moderator

Previous Topic: sql - very slow
Next Topic: regarding updating table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 04:24:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.