dbms_sql execute statements larger than 32767
Declare
vTemp pls_integer := 0;
stmt Varchar2(255);
Begin
For i in
(
Select Trigger_Body
From Dm_Tb_Triggers
)
Loop
stmt := Substr(i.Trigger_Body,1,255);
vTemp := Dbms_Sql.Open_Cursor;
Dbms_Sql.Parse(vTemp,i.Trigger_Body,dbms_sql.v7);
Dbms_Sql.Close_Cursor(vTemp);
End Loop;
Exception When Others Then
dbms_output.put_line (stmt);
Raise;
End;
When execute above code, I get pl/sql value or numeric error, trigger_body is declared as clob in dm_tb_triggers table and if i am using clob overloaded version of dbms_sql.parse i should not get this message i think. plz. help.........
Regards,
Qamar Yaqub