You have compiled some PL/SQL packages in your schema, and found aome errors in one procedure.how do you find which procedure produced the error?how do you find which section of the code produced the error and look at?

No answer
  • Interview Candidate
  • 23
  • 4110

Showing Answers 1 - 23 of 23 Answers

KiranKumar Jinka

  • Oct 26th, 2005
 

Try using the view USER_ERRORS

  Was this answer useful?  Yes

indrajit

  • Nov 10th, 2005
 

Use EXCEPTION section in every Procedure. And then use  output messages like dbms_output.put_line ('NO_DATA_FOUND exception occur  in PROCEDURE NAME');

It will give u the procedure name where error occured..

tiru

  • Nov 24th, 2005
 

After compiling procedures if we encounter error, we get error line with  a line no with the help of that line no we can find which code produces error

  Was this answer useful?  Yes

Guest

  • Nov 26th, 2005
 

use sho err or show_errors.

It gives the line number with error message

  Was this answer useful?  Yes

soni

  • Jun 14th, 2007
 

You can show your error using show error command

  Was this answer useful?  Yes

fancyoracle

  • Aug 15th, 2007
 

There are a number of ways to understand the exact line which has the error.
1) Using the SQL+ , type in show err command, which returns the error number.
2) Programatically, along with the exception handling section

The second method usually brings more good as it is experienced that at time the line number mentioned by oracle isnt the real trouble maker.
Thus, use a variable to store a prominate place holder at the major junctions of the code and publish the same by catching the error in the exception handling section.

This method proves to be specially useful when the code is rather bulky.

  Was this answer useful?  Yes

Tulashidas

  • Sep 27th, 2007
 

You can Use first SHOW Error Command then Use list command then you can get exacte line number.
 

  Was this answer useful?  Yes

ravivenkat1234

  • Apr 28th, 2009
 

We can use the below table to find out which procedure was errored out in the pacakage. USER_ERRORS the sample query is given below

SELECT * FROM USER_ERRORS
WHERE name = 'PACKAGE_NAME'

  Was this answer useful?  Yes

gem023

  • Feb 11th, 2010
 

On SQL Plus you can give the command - show errors.   This would show the line number and reason for the compilation error.

  Was this answer useful?  Yes

samareshp

  • Feb 13th, 2010
 

While creating a package, we can use Show error Command to get the line number thats has error. And can be corrected. Even we can check in the data-dictonary view i.e. user_errors to figure out the error.

If you have written an exception section in package having proper exception messages. By using this also you can track the error/exception.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions