Re: PL SQL Error

Toan Dao wrote:

> Could someone tell me what "PLS-00801: Internal error [74402]" error
> message mean. I get this error message when compiling my stored procedure
> and the Oracle server messages manual does not have this error code.
> Thanks,
>

Ok i think i have seen this one, look at your parameters declarations, see if you are missing the %type on one of them.

Example: create or replace proc_name ( parm1 table.column%type)

^

if you forget the  ------------------------------------------------

i think thats the error you get.

take a look there, joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second, third, etc,
instance, without using oracle's installer, database scripts.
ICQ UIN: 4252226(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).