RE: problems with dbms_sql w/ 9.2.0.4???

[Paula_Stankus]

Title: Message

You nailed it - you might want to see the info. about it - least it happens to you.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Niall Litchfield
Sent: Tuesday, January 13, 2004 7:14 AM
To: Multiple recipients of list ORACLE-L
Subject: FW: problems with dbms_sql w/ 9.2.0.4???

 

-----Original Message-----
From: Niall Litchfield [mailto:[EMAIL PROTECTED]
Sent: 13 January 2004 11:16
To: '[EMAIL PROTECTED]'
Subject: RE: problems with dbms_sql w/ 9.2.0.4???

There is a bug 3140063 which at first glance looks as if it might be relevant to you.

 

Niall

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 12 January 2004 21:14
To: Multiple recipients of list ORACLE-L
Subject: RE:problems with dbms_sql w/ 9.2.0.4???

Developer is saying functions are good - all functions referencing dbms_sql bomb???

 

Help???

 

problem with dbms_sql????

 

Compiling function FUN_CHANGE_PASSWORD...

Compilation error on function FUN_CHANGE_PASSWORD:

PL/SQL ERROR 801 at line 1, column 1

internal error [1907]

PL/SQL ERROR 0 at line 23, column 7

Statement ignored

PL/SQL ERROR 801 at line 1, column 1

internal error [1907]

PL/SQL ERROR 0 at line 24, column 7

Statement ignored

PL/SQL ERROR 801 at line 1, column 1

internal error [1907]

PL/SQL ERROR 0 at line 25, column 7

Statement ignored

PL/SQL ERROR 801 at line 1, column 1

internal error [1907]

PL/SQL ERROR 0 at line 26, column 7

Statement ignored

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, Dick
Sent: Monday, January 12, 2004 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Yep.....it's a Monday......

Yeah, it is a Monday.  Vendor shows up to "fix" a minor problem & my day gets trashed.  Oh well, job justification!!

 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Bobak, Mark [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Yep.....it's a Monday......

While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time…..Yeah, it's a Monday…..

So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes…..sigh….I have a feeling lunch will be a little late today…….

At least I wasn't the one who caused the crash…..;-)

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is."  --Unknown