Re: Need Help With Pro*C Function

From: Paul-Marc Marot <Paul-Marc.Marot_at_capway.com>
Date: Fri, 22 Jan 1999 10:19:49 +0100
Message-ID: <789fik$4ja$1@minus.oleane.net>

matthew_at_mattshouse.com a écrit dans le message <787neu$rg5$1_at_nnrp1.dejanews.com>...
>
>
>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

See Dynamic SQL. Very well explained in Oracle documentation.

Paul-Marc

---

"In the beginning there was data. The data was without form and null. And darkness was upon the face of the console; and the spirit of IBM was moving over the face of the market. And DEC said "Let there be registers";
and there were registers. And DEC saw what they carried; and DEC separated the data from the instructions;
and DEC called the data Stack and the instructions they called Code. And there was evening and there was morning, one interrupt..." -- Rico Tudor Received on Fri Jan 22 1999 - 03:19:49 CST