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: how to create a INSERT-SQL-String and execute it in PL/SQL?

Re: how to create a INSERT-SQL-String and execute it in PL/SQL?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Aug 2003 13:28:29 +0200
Message-ID: <vkmhi7l7avuo1c@corp.supernews.com>

"Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote in message news:biffli$8o7pa$1_at_uni-berlin.de...
> Hi!
> I like to create a stored procedure, where i can create a
INSERT-SQL-String
> and execute it like this:
>
> SQL := "INSERT INTO T_Test ...";
> EXECUTE(SQL);
>
> Thank you,
> Ralf
>
>

PL/SQL already has
execute immediate (8i and higher)
and dbms_sql (all versions)
so why re-invent the wheel

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Tue Aug 26 2003 - 06:28:29 CDT

Original text of this message

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