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 -> Re: Passing Parameters to Stored Function through OCI

Re: Passing Parameters to Stored Function through OCI

From: <sybrandb_at_hccnet.nl>
Date: Sat, 04 Aug 2007 10:54:05 +0200
Message-ID: <nhf8b3tmtrkktm1tcvcf44gdq77h5p1j85@4ax.com>


On Sat, 04 Aug 2007 05:13:57 -0000, Haranadh <haranadh.poduri_at_gmail.com> wrote:

>I am trying to pass parameters to a oracle stored function through
>OCI.
>
>char *querytext= "select func(:1) from dual" ;
>I am binding a parameters using the positon number.
>
>I am getting an error "ora 00904 : Invalid Identifier ", while
>executing OCIStmtExecute.
>
>I am not sure, how I can pass parameter to the select statement having
>a stored function.
>
>
>Thanks in Advance,

I am not sure how anyone can answer this without a) having the exact code (if this is the exact code, you aren't binding anything)
b) the exact version of Oracle you are using.

You are recommended not to waste peoples time by putting riddles in this forum.

-- 

Sybrand Bakker
Senior Oracle DBA
Received on Sat Aug 04 2007 - 03:54:05 CDT

Original text of this message

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