Dynamic SQL & Deadlock may be
579483May 1 2009 — edited Jul 4 2009HI
I want to execute dynamic Insert statement created by the cursor - However, the below EXECUTE IMMEDIATE does not allow v_query... why?? Could anyone help me?
Thanks in advance.
---------------------------------------------------------------------------
CURSOR c1
IS
SELECT 'insert into t1 ( TABLE_NAME, A_COUNT,B_COUNT,C_COUNT,CREATE_DATE,LAST_UPDATED_DATE) values ('''
|| object_name
|| ''',0, 0 , 0, sysdate, sysdate);'
FROM user_objects
WHERE object_type = 'TABLE' AND object_name NOT LIKE 'BIN$%';
v_query VARCHAR2 ( 500 );
BEGIN
...
....
..
OPEN c1;
LOOP
FETCH c1
INTO v_query;
EXIT WHEN c1%NOTFOUND;
--DBMS_OUTPUT.put_line ( v_query );
EXECUTE IMMEDIATE v_query;
END LOOP;
CLOSE c1;
end;
---------------------------------------------------------------------------
Edited by: Adi_consultant on May 1, 2009 6:56 PM