Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executing dynamic sql statements in a PL/SQL procedure
Hi.
If you are using Oracle 8i then you can do it with native dynamic SQL.
HTH. Michael.
In article <889j0t$u96$1_at_nnrp1.deja.com>,
slices17_at_kreative.net wrote:
> Hello,
>
> I am writing a PL/SQL procedure. In the procedure, I need to compose
a
> SQL statement at runtime and execute it.
>
> I know that one way to do this is to use the dbms_sql package's
> procedures to open a cursor, parse the sql statement and then execute
> the statement and close the cursor. But it seems a lot of work just
to
> execute an update statement.
>
> Does anyone know of a quicker way to execute an SQL statement that is
> stored in a string?
>
> Thanks.
>
> Ray
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 14 2000 - 14:18:30 CST