DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: error invoking Sqlplus - asking for prompt

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Unhappy

    Hi,

    I have Oracle 8.1.6 Server installed on Solaris 8 (64 bit) platform.
    When ever I try conecting SQLPLUS it gives me the following
    errors:

    "select promptname from promtag where value='000'
    error at line 1:
    Ora-00942 table or view does not exist.
    Enter value for prompt: "

    This happens when I try invoking sqlplus. if I hit enter at prompt
    it connects.
    how do I resolve this problem ???


    Thanks in advance

    geo

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    Hi,

    Check your Login and Glogin Files....
    You must have Prompt in any of the above files.

    Thanks

  3. #3
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54
    Thanks!
    It worked. I commented out the set SQLPROMT line in the glogin scripts.
    But are there any issues in commenting out the set SQLPROMT in the glogin script ??
    Please let me know

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