Re: Calling a PL/SQL Function from OCI?

Check your docs for the use of the PRAGMA directives ( WNDS,RNDS, etc)...your functions needs to use them...

Scott Metzger <scottmetzger_at_my-deja.com> wrote:

>That works great for my simple function in the example I posted. However,
>when I try to call my more complex real life function that uses cursors
>via the DBMS_SQL package I get the following Oracle Error:
>ORA-06571: Function GETNODEQUERY does not guarantee not to update database
>
>Other ideas?
>
>Thanks,
>*:> Scott
>
>In article <93fe4k$sqv$1_at_nnrp1.deja.com>,
> DriftWood <drift_wood_at_my-deja.com> wrote:
>> Try:
>>
>> strcpy(SQL, "select GetNodeQuery(1) from dual");
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Tue Jan 09 2001 - 14:44:09 CST