| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
06-24-11, 10:36
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
|
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?
|
|
06-24-11, 10:59
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
>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.
|
|
06-24-11, 11:22
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
|
|
Quote:
Originally Posted by anacedent
>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.
|
|
06-24-11, 13:05
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,629
|
|
Are there any triggers in that schema? If so, does any of them contain call to SYS_CONTEXT that references her computer?
|
|
06-24-11, 13:12
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
Quote:
Originally Posted by Littlefoot
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.
|
|
06-24-11, 13:43
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
|
|
06-24-11, 13:54
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,629
|
|
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.
|
|
06-24-11, 14:09
|
|
Registered User
|
|
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.
|
|
06-27-11, 14:15
|
|
Registered User
|
|
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>
|
|
06-27-11, 14:19
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
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.
|
|
06-27-11, 15:20
|
|
Registered User
|
|
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.
|
|
06-27-11, 15:51
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,415
|
|
>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.
|
|
06-27-11, 16:19
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,629
|
|
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>
|
|
06-29-11, 16:28
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
Quote:
Originally Posted by anacedent
>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.
|
|
06-29-11, 16:30
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 50
|
|
Quote:
Originally Posted by Littlefoot
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.
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
weird sqlplus output "error"
