Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cant find anything wrong with this code but it still errors

Re: Cant find anything wrong with this code but it still errors

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 27 Aug 1998 20:10:41 +0200
Message-ID: <6s47d5$lv2$1@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 Thu Aug 27 1998 - 13:10:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US