Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Posts
    7

    Unanswered: Translating Line number errors

    Hi all,
    I got the next error :

    ERROR at line 1:
    ORA-01403: no data found
    ORA-06512: at line 301

    When I am opening the PL/SQL script I wrote in toad or in Ultra Edit,
    The line '301' contains a remark.
    My question is how do I know what is the real line number that causes the error ?


    Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: Translating Line number errors

    Two thoughts.
    1. Did it say line 301 was in your code? If your procedure calls other PL/SQL, then line 301 might be in that other PL/SQL. Check the error message for any reference to objects other than your own.
    2. Launch SQL*Plus and connect to your DB. Then type EDIT to launch a session of your default editor. Copy/Paste the contents of your script from TOAD into this editor window, then exit the editor. The contents will be fed into the SQL*Plus buffer, and extraneous lines will be removed. Finally, the true line number will be revealed to you.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    This might be a situation where the last character in the file is not a slash character "\".

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Originally posted by anacedent
    This might be a situation where the last character in the file is not a slash character "\".
    OOPS!
    It should have been "/" instead.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    sounds like you have a select into clause somewhere but you are selecting nothing.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •