executing dynamic sql statements in a PL/SQL procedure

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. Received on Mon Feb 14 2000 - 12:54:22 CST