Use a normal recordset with "SELECT function_xy(x,y) FROM DUAL;"
In article <9oaaeh$c5qv9$1_at_ID-52006.news.dfncis.de>, this-berlin_at_gmx.de
says...
> How can I access an oracle function with ADO (VB)?
> I've tried with
>
> objCmd.CommandText = "function_xy"
> objCmd.CommandType = 4 'AdoEnums.CommandType.STOREDPROC
> objCmd.Parameters.Refresh
> objCmd.ActiveConnection = srv
> Set objRS = CreateObject("adodb.recordset")
> objRS = objCmd.Execute
>
>
> The error that comes up is PLS 00221 (function_xy is not a procedure or is
> undefined).
> Within C++ it is possible to execute this function with the same command
> type.
>
> ideas?
>
> --
> Tobias Handschuck
>
>
>
Received on Wed Sep 19 2001 - 10:41:26 CDT
