Paula, did you try re-running catproc? Did your duhveloper follow the
installation instructions to the letter, or creatively, skipping the parts
he didn't like?
On 01/12/2004 04:34:25 PM, Paula_Stankus_at_doh.state.fl.us wrote:
> Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so that they cannot compile their procs referencing dbms_sql. Help?
>
> -----Original Message-----
> Sent: Monday, January 12, 2004 4:27 PM
> To: 'ORACLE-L_at_fatcity.com'
> to developer mailgroup?
>
>
> 1) Please tell me how to subscribe to Developer mailgroup?
>
> 2) Any ideas?
>
> 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
> --
> 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).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
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 - 16:09:42 CST
