Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. declare
  2. text_area varchar2(4000) := 'declare x number; begin xy := x + 1; end;';
  3. begin
  4. execute immediate 'create or replace procedure DUMMY#__ IS BEGIN null; begin '|| text_area ||' end; END;';
  5. exception
  6. -- see comment below about error handling
  7. when others then
  8. -- signal yourself it went wrong
  9. RAISE;
  10. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement