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

"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