Lanky,
Check out the following Microsoft KB article (plus the addition KB
articles shown at the end of that article)
INFO: Visual Basic Accessing an Oracle Database Using ADO
http://support.microsoft.com/support/kb/articles/Q176/9/36.ASP
--
Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com
"Lanky" <lanky_tx_at_yahoo.com> wrote in message news:9oga3t$csm80$1_at_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:30:27 CDT
