i'm trying execute block inside procedure...
schema_nm := 'devl'; plsql_block:='begin ' || schema_nm || '.lic_pkg.remove(:x, :y); end;'; begin execute immediate plsql_block using in_val1,in_val2; end;
when try execute above see error..
ora-06550: line 1, column 7: pls-00201: identifier 'devl.lic_pkg' must declared ora-06550: line 1, column 7: pl/sql: statement ignored
please let me know if have come across kind of error...
thank in advance help.
Comments
Post a Comment