Advertisement
cgrunwald

Untitled

Feb 6th, 2011
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.26 KB | None | 0 0
  1. DECLARE
  2.    l_ret   clob;
  3. BEGIN
  4.    SELECT   XMLTRANSFORM(xmltype(:P5_XML), xmltype(:P5_XSL)).GetClobVal()
  5.    INTO     l_ret
  6.    FROM     dual;
  7.    htp.p(l_ret);
  8. EXCEPTION
  9.    WHEN OTHERS
  10.    THEN
  11.       l_ret := SQLCODE ||' - '||SQLERRM;
  12.       htp.p(l_ret);
  13. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement