Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Sep 2004
    Posts
    50

    Unanswered: weird sqlplus output "error"

    I have a user here experiencing some bizarre behavior w/ sqlplus.

    If she logs into database ABDC as user X and executes any script that utilizes dbms_output, she gets the following printed out repeatedly:

    SQL> set serveroutput on
    SQL> spool gradeload
    SQL> exec dummy_package.dummy;
    before v-user
    before v-user
    before v-user
    before v-user
    before v-user
    before v-user

    etc....

    If I log into the same database, as the same user, from my own computer, or toad, or a terminal window, then I do NOT experience the same behavior.

    Seems to me like some sort of variable stored to her sqlplus exe, but I don't really know how that works. Anybody know what's causing this and/or how I can get rid of it?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If I log into the same database, as the same user, from my own computer, or toad, or a terminal window, then I do NOT experience the same behavior.
    >Seems to me like some sort of variable stored to her sqlplus exe, but I don't really know how that works. >Anybody know what's causing this and/or how I can get rid of it?

    I suspect something local to her system; such as glogin.sql file
    If she uses Your PC, what happens?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2004
    Posts
    50
    Quote Originally Posted by anacedent View Post
    >If I log into the same database, as the same user, from my own computer, or toad, or a terminal window, then I do NOT experience the same behavior.
    >Seems to me like some sort of variable stored to her sqlplus exe, but I don't really know how that works. >Anybody know what's causing this and/or how I can get rid of it?

    I suspect something local to her system; such as glogin.sql file
    If she uses Your PC, what happens?
    everything works fine from my PC under sqlplus. in fact, everything works fine from her PC if she goes in through a terminal window or toad.

    it's obviously something with her sqlplus, but i don't know enough about sqlplus to track down what exactly.

    i've heard about these login files before, glogin.sql, login.sql, etc. but she doesn't even seem to have those files.

    i suppose an uninstall/reinstall would be the quick fix, but i'm trying to gain a little more understanding of the software.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Are there any triggers in that schema? If so, does any of them contain call to SYS_CONTEXT that references her computer?

  5. #5
    Join Date
    Sep 2004
    Posts
    50
    Quote Originally Posted by Littlefoot View Post
    Are there any triggers in that schema? If so, does any of them contain call to SYS_CONTEXT that references her computer?
    ohhh... excellent call!

    i'll check that out.

  6. #6
    Join Date
    Sep 2004
    Posts
    50
    nope... nothing.

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Would it be possible for you to post a complete session (operating system command prompt), logging to SQL*Plus using her account, executing a dummy procedure that calls DBMS_OUTPUT? Something like this:
    Code:
    C:\temp>sqlplus scott/tiger
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Pet Lip 24 19:52:42 20
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    
    
    Session altered.
    
    SQL> begin
      2    dbms_output.put_line('Hello');
      3  end;
      4  /
    Hello
    
    PL/SQL procedure successfully completed.
    
    SQL>
    See my "Session altered" message? I kind of hope to see something like that in your case.

  8. #8
    Join Date
    Sep 2004
    Posts
    50
    @littlefoot

    she appears to have left for the day, but i WILL do this as soon as possible on monday morning.

    i do truly appreciate the help.

  9. #9
    Join Date
    Sep 2004
    Posts
    50
    here's what we got:

    Code:
    SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jun 27 14:11:16 2011
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> set serveroutput on
    SQL> begin
      2  dbms_output.put_line('Hello');
      3  end;
      4  /
    Hello
    
    PL/SQL procedure successfully completed.
    
    SQL>

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    so it appears that the problem has gone missing & no longer occurs.
    YEA!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Sep 2004
    Posts
    50
    unfortunately, no.

    any time she runs a compiled package, it still happens.

    this is one of the weirdest things i've seen in a while.

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >any time she runs a compiled package, it still happens.
    It is yours to debug since it is local to package/schema/DB.
    what is significance to "v-user"?
    do a wild card SELECT from DBA_SOURCE for that string.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  13. #13
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    OK, so create a sample package, consisting of a single procedure that would DBMS_OUTPUT the same 'Hello'. Copy-paste the whole session again.

    Code:
    SQL> create or replace package pkg_test is
      2    procedure prc_test;
      3  end;
      4  /
    
    Package created.
    
    SQL> create or replace package body pkg_test is
      2    procedure prc_test is
      3    begin
      4      dbms_output.put_line('Hello');
      5    end;
      6  end;
      7  /
    
    Package body created.
    
    SQL> set serveroutput on
    SQL> exec pkg_test.prc_test
    Hello
    
    PL/SQL procedure successfully completed.
    
    SQL>

  14. #14
    Join Date
    Sep 2004
    Posts
    50
    Quote Originally Posted by anacedent View Post
    >any time she runs a compiled package, it still happens.
    It is yours to debug since it is local to package/schema/DB.
    what is significance to "v-user"?
    do a wild card SELECT from DBA_SOURCE for that string.
    while it IS tied to this particular package/schema/DB, it does NOT occur when run from my machine. nor does it occur when run on the user's machine via terminal window or toad.

    it ONLY occurs on this user's machine, when executed via the sqlplus tool (C:\%ORACLE_HOME%\BIN\sqlplusw.exe).

    there's got to be something weird tied to that tool, but i don't know what or where it's being saved.

  15. #15
    Join Date
    Sep 2004
    Posts
    50
    Quote Originally Posted by Littlefoot View Post
    OK, so create a sample package, consisting of a single procedure that would DBMS_OUTPUT the same 'Hello'. Copy-paste the whole session again.

    Code:
    SQL> create or replace package pkg_test is
      2    procedure prc_test;
      3  end;
      4  /
    
    Package created.
    
    SQL> create or replace package body pkg_test is
      2    procedure prc_test is
      3    begin
      4      dbms_output.put_line('Hello');
      5    end;
      6  end;
      7  /
    
    Package body created.
    
    SQL> set serveroutput on
    SQL> exec pkg_test.prc_test
    Hello
    
    PL/SQL procedure successfully completed.
    
    SQL>
    i tried something similar to this already, but...

    i created an compiled it from my machine (under her user account). when either of us runs it, there's no error.

    however...

    i wonder what would happen if she created it on her OWN machine.

Tags for this Thread

Posting Permissions

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