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 -> Calling an Oracle function using ADO

Calling an Oracle function using ADO

From: Lanky <lanky_tx_at_yahoo.com>
Date: Fri, 21 Sep 2001 16:06:04 -0500
Message-ID: <9oga3t$csm80$1@ID-19809.news.dfncis.de> 





Hi ALL,



I am having trouble calling an Oracle function from ADO.  Can someone please
post a bit of code or direct me to the right place?
I am passing in 1 parameter and expecting 1 return value from the Oracle
function.



This is what I have.



Set objRS = Conn.Execute("FNCName ('" & strParam & "');")



     PCS_Equip_Type_Cd = objEquipRS(0).Value




Thanks,



Lanky
Received on Fri Sep 21 2001 - 16:06:04 CDT












Original text of this message













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