Actually this sounds kinda dumb.... but My function was after the procedure calling it in my code.. I moved the Function up to
above the Procedure and it worked...
Arjan van Bentem wrote in message <6s47d5$lv2$1_at_pascal.a2000.nl>...
>>LERG_CLLI(recMatch.LEC_NPA, recMatch.LEC_NXX, recMatch.MCI_NPA,
>recMatch.MCI_NXX)
>
>Seems to me you are calling a function, but treat is as a procedure. Where
>should Oracle put the return value?
>
> v_Result := LERG_CLLI( .. );
>
>If you actually did this, then one of the recMatch.XYZ is not a varchar2.
>
>
>Arjan.
>
>
Received on Fri Aug 28 1998 - 09:58:35 CDT
