Home » Other » Client Tools » find error line in plsql code of more than 1 lakh lines. (11g)
icon3.gif  find error line in plsql code of more than 1 lakh lines. [message #643858] Tue, 20 October 2015 06:55 Go to next message
masthan.anthati@gmail.com
Messages: 11
Registered: July 2011
Location: Banglore
Junior Member
How to find/debug the exact error line from a plsql script of more than 1 lakh lines in SQL Develpoer?
Re: find error line in plsql code of more than 1 lakh lines. [message #643859 is a reply to message #643858] Tue, 20 October 2015 07:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know about SQL Developer, but - if you run it in SQL*Plus, it'll show you the exact spot.
SQL> declare
  2    l_datum date;
  3  begin
  4    l_datum := sysdate * 4;         --> error is here
  5  end;
  6  /
  l_datum := sysdate * 4;
             *
ERROR at line 4:                       --> these lines say what's wrong
ORA-06550: line 4, column 14:          -->
PLS-00306: wrong number or types of arguments in call to '*'
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored


SQL>
Re: find error line in plsql code of more than 1 lakh lines. [message #643861 is a reply to message #643859] Tue, 20 October 2015 07:25 Go to previous messageGo to next message
masthan.anthati@gmail.com
Messages: 11
Registered: July 2011
Location: Banglore
Junior Member
Thanks for the prompt help Littlefoot.

Its good that we have that built-in feature in SQL*Plus, it would be great if someone can help me on how to do this on SQL Develpoer.

Thanks.
Re: find error line in plsql code of more than 1 lakh lines. [message #643863 is a reply to message #643858] Tue, 20 October 2015 07:34 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

like this
http://www.thatjeffsmith.com/wp-content/uploads/2015/10/l_datum.png

[Updated on: Tue, 20 October 2015 07:38]

Report message to a moderator

Re: find error line in plsql code of more than 1 lakh lines. [message #643871 is a reply to message #643863] Tue, 20 October 2015 07:53 Go to previous message
masthan.anthati@gmail.com
Messages: 11
Registered: July 2011
Location: Banglore
Junior Member
Awesome..!! Thank you guys for your support and help, will take your help if it needs Smile
Previous Topic: Newbie with Questions? (domain vs logical vs structured) datatypes
Next Topic: Oracle GUI tools like OEM version 10.2.0.0
Goto Forum:
  


Current Time: Thu Mar 28 06:09:39 CDT 2024