SQLPLUS session disappears !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQLPLUS session disappears !!

  1. #1
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    SQLPLUS session disappears !!

    Hi All,

    Here's an unusual one for you.
    I start a SQLPLUSW session on my PC and am running scripts on a database.
    All is okay until a do a DESC on a table.
    At this point the session disappears, as though I'd typed EXIT.

    Anybody else get this, or anyone shed some light ??

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Go to the dos mode of sqlplus and try see what happenes..this could be a bug in the GUI version of sqlplus

    regards
    Hrishy

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    What version of database, client and OS are you running?

    Cheers.

    P.S.: You may find this intresting ...
    http://dbasupport.com/forums/showthr...threadid=26723

  4. #4
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    If there is no solution, it is because there is no problem - Shadok -

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    This wud be interesting to you as i too faced such problems.

    Code:
    SQL> set lines 10000
    SQL> desc table
    
    -- Sql Plus generates errors & windows prompts it would exit.
    
    SQL> set lines 100
    SQL> desc table
    
    -- describes correctly without errors.
    well its because of too much buffer size allocated by setting lines 10000 or even 1000 is also too much enough to genertate errors by windows.....(am not sure)
    or could be bug with SQL Plus.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Thanks for the input guys.

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