Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need Help With Pro*C Function

Re: Need Help With Pro*C Function

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 21 Jan 1999 19:27:22 GMT
Message-ID: <36a97f8e.14476656@192.86.155.100>


A copy of this was sent to matthew_at_mattshouse.com (if that email address didn't require changing) On Thu, 21 Jan 1999 17:17:31 GMT, you 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;
>

exec sql execute immediate :string;

>Is something like this possible?
>
>Matthew
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jan 21 1999 - 13:27:22 CST

Original text of this message

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