Home » SQL & PL/SQL » SQL & PL/SQL » Viewing the errors on a procedure (UNIX solaris 8, Oracle 10.2.0.2.0)
Viewing the errors on a procedure [message #326443] Wed, 11 June 2008 09:24 Go to next message
evoradba
Messages: 104
Registered: April 2005
Location: Canada
Senior Member
hello

How can i view the erros on a procedure at command line, If I do a select * from user_errors only shows the
PL/SQL: ORA-00942: table or view does not exist

I want to see the entire errors which tables are missing / refering to etc

Is there a way of doing so at comand line?

Thank you
Maria
Re: Viewing the errors on a procedure [message #326446 is a reply to message #326443] Wed, 11 June 2008 09:30 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
SELECT * FROM USER_ERRORS WHERE NAME='PROCEDURE_NAME';


Regards,
Oli
Re: Viewing the errors on a procedure [message #326448 is a reply to message #326443] Wed, 11 June 2008 09:34 Go to previous messageGo to next message
evoradba
Messages: 104
Registered: April 2005
Location: Canada
Senior Member
its the same as select * from user_erros only shows the error numbers and does not display the actual erros - thanks
Re: Viewing the errors on a procedure [message #326450 is a reply to message #326448] Wed, 11 June 2008 09:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
USER_ERRORS gives LINE, POSITION (column) and TEXT of errors.
What do you want more?

Regards
Michel
Re: Viewing the errors on a procedure [message #326477 is a reply to message #326450] Wed, 11 June 2008 10:45 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The error ORA-00942 does not list the name of the table that was being looked for. You have to look in the code to see what was beeing accessed at that point.
Previous Topic: need help with basic sql
Next Topic: Create Partition in Existing Table
Goto Forum:
  


Current Time: Fri Dec 09 19:36:35 CST 2016

Total time taken to generate the page: 0.13555 seconds