how to find oracle error in sqlprompt urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: how to find oracle error in sqlprompt urgent

  1. #1
    Join Date
    May 2002
    Posts
    232
    example ora01740
    thanks
    kavitha

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Should refer to Oracle Error Manuals.

    Thanks.
    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    May 2002
    Posts
    232

    URGENT

    NOTIME
    kavitha

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Hi Kavitha,

    Most of your posts are subjected "URGENT". I suggest you to take some time off and go through the manuals.

    For a quick reference you can check the error details here
    http://tahiti.oracle.com/pls/db901/db901.error_search

    Sanjay

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dont expect fast response just you say urgent!

    the time you spend writing here you can use it to find the error code! it only takes a couple of minutes to search for error code on tahiti.oracle.com

  6. #6
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158

  7. #7
    Join Date
    May 2002
    Posts
    232

    ERROR FROM SQLPROMPT

    TO FIND OUT ERROR FROM SQL PROMPT ONLY I MEAN REASON FOR THAT ERROR
    kavitha

  8. #8
    Join Date
    Sep 2000
    Posts
    41
    Ok...... here is the piece from Oracle Error Manual


    ORA-01740 missing double quote in identifier

    Cause: An initial double quote (") was found without a closing quote. If an identifier contains a blank or special characters other than $, #, or _, it must be enclosed in double quotes.

    Action: Add a closing double quote (") to the end of the identifier

  9. #9
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Reason?
    Perhaps "show errors" helps you ... if you use SQL*Plus.

  10. #10
    Join Date
    Mar 2002
    Posts
    13

    Thumbs up

    If u r in Unix environment, Pl try the below at SQL prompt:
    SQL> !oerr ora errornumber
    ex: !oerr ora 03113

Posting Permissions

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



Click Here to Expand Forum to Full Width