Re: Need Help With Pro*C Function

You can do this using dynamic SQL. There are a few methods depending on your needs. Check out the EXEC SQL EXECUTE for simple queries like yours or for more dynamic one use the PREPARE..FROM and EXECUTE..USING statements.

R.

Daniil Fishteyn wrote:

> I am not sure about pro*c but I know it is defenitly possible with OCI (Oracle
> Call Inteface).
>
> If you need more info write me.
>
> matthew_at_mattshouse.com wrote:
>
> > I was wondering if it is possible to execute a query that is represented by a
> > string. I'm not explaining it well, so I'll write some code. This will not
> > work, but you'll know where I'm going:
> >
> > strcpy(buf1,"insert into table1 (row1) values ('hello')");
> > EXEC SQL :buf1;
> >
> > Is something like this possible?
> >
> > Matthew
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 22 1999 - 11:07:16 CST