Re: ADO and Stored functions

On Mon, 20 Dec 1999 11:03:52 GMT, Bart <bartvd_at_my-deja.com> wrote:

>VC++6, Ora 8.0.5
>
>Hello,
>
>I'm using ADO as middleware to access an Oracle DB from my VC app.
>Executing a stored procedure is quite easy and works fine.
>However when I want to execute a stored function my call always fails.
>I get following exception:
>
>Exception thrown for classes generated by #import
> Code = 80040e14
> Code meaning = IDispatch error #3092
> Source = Microsoft OLE DB Provider for Oracle
> Description = ORA-06550: line 1, column 7:
> PLS-00221: 'FTEST' is not a procedure or is undefined
>
>I execute the function with:
>
>pCommand.CreateInstance(__uuidof( Command ));
>pCommand->ActiveConnection = pDoc->m_pConnection;
>pCommand->CommandText = _bstr_t("FTEST");

Try selecting FTEST from DUAL; Received on Mon Dec 20 1999 - 17:46:31 CST