Re: PL/sql question

From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/08/03
Message-ID: <0f3431c0.21c48867@usw-ex0104-028.remarq.com>#1/1

sorry, how to use DBMS_SQL.EXECUTE?
if insert into tb2 select x from tb2; is a practical code in one of my big store procedure?

DBMS_SQL.EXECUTE and just supply the cursor ID that has been declared with the SQL string you specified below. For 7 look at the PARSE function.

BTW - your SQL is wrong... just do:

insert into tb2 select x from tb2;

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Aug 03 2000 - 00:00:00 CDT