Re: Error!!!!!

Wallace schrieb:
> Hai All,
>
> I am having a function as follows...
>
> CREATE OR REPLACE FUNCTION UDTRAEKJOB.FUNC_COSA_FORMAL(vUDTREK_ID
> NUMBER(14,0), vSTARTDATO DATE, vSLUTDATO DATE)
> RETURN INTEGER AS
> TYPE COSA_FORMAL_LISTTYPE IS TABLE OF XPRS$COSA_FORMAL_V%ROWTYPE;
> BEGIN
> ...............
> END;
>
>
> While compiling, I am getting an error as "Error(1,55): PLS-00103:
> Encountered the symbol "(" when expecting one of the following: :=
> .. ) , _at_ % default character The symbol ":=" was substituted for "(" to
> continue."
>
> Kindly help!!!!
> Looking forward for the response....
>

In the argument list you don't specify data length/precision, only the type ( i.e. vUDTREK_ID NUMBER,vSTARTDATO DATE,...)

Best regards

Maxim Received on Mon May 15 2006 - 11:44:43 CEST