Re: PL/SQL problem

The error is in giving variables for your formal arguments instead of data types.
Thus,

        FUNCTION Sici2(AN_in IN AN_Type) RETURN Sici2_Type should be

	FUNCTION Sici2(AN_in IN mfs.article.AN%TYPE)
		RETURN number; 	-- or whatever

(Using mfs.article.sici2%TYPE for the RETURN argument does not give an error during compilation, but I am not sure whether this might result in execution errors, since the RETURN argument is not supposed to be sized.)

Hope this helps.

Chrysalis.    

Valentin Maier wrote:
>
> When I try to run a package specification I get the error:
>
> 0/0 PLS-00801: internal error [74402]
>
> The package is quite simple:
>
> CREATE OR REPLACE PACKAGE sici_pack
> AS
> Sici1_Type mfs.issue.sici1%TYPE ;
> Sici2_Type mfs.article.sici2%TYPE ;
> AN_Type mfs.article.AN%TYPE ;
> MID_Type mfs.issue.MID%TYPE ;
> DTFORMAT_Type mfs.issue.DTFORMAT%TYPE ;
>
> FUNCTION Sici2(AN_in IN AN_Type) RETURN Sici2_Type ;
> FUNCTION Sici1(MID_in IN MID_Type, DTFORMAT_in IN DTFORMAT_Type) RETURN Sici1_Type ;
> END ;
>
> I am using Oracle 7.3 on Windows NT.
>
> Any idea on how I can make this work?
>
> TIA,
>
> Valentin.
  Received on Tue Mar 11 1997 - 00:00:00 CET