Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare
- text_area varchar2(4000) := 'declare x number; begin xy := x + 1; end;';
- begin
- execute immediate 'create or replace procedure DUMMY#__ IS BEGIN null; begin '|| text_area ||' end; END;';
- exception
- -- see comment below about error handling
- when others then
- -- signal yourself it went wrong
- RAISE;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement