RE:problems with dbms_sql w/ 9.2.0.4???

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 12 Jan 2004 13:14:26 -0800
Message-ID: <F001.005DC724.20040112131426@fatcity.com>

Yep.....it's a Monday......

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: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]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:Mark.Bobak@il.proquest.com]
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Paula_Stankus_at_doh.state.fl.us
  INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 12 2004 - 15:14:26 CST