Re: Java Permission error using DBMS_XMLQuery.setXSLT( ) feature of XSU for PL/SQL
From: Mr T <wilson.to_at_umusic.com>
Date: 2 Aug 2002 00:22:41 -0700
Message-ID: <90aabc52.0208012322.714b75a7_at_posting.google.com>
Date: 2 Aug 2002 00:22:41 -0700
Message-ID: <90aabc52.0208012322.714b75a7_at_posting.google.com>
Hi Rauf,
Thanks for the response. I have now realised what the problem is. In my code, I mistakenly declared the variable holding my stylesheet as a VARCHAR2 rather than a CLOB. Consequently, DBMS_XMLQuery assumed that it was trying to file a file rather than treat it as the content of the stylesheet.
By changing the datatype to CLOB, my problem was resolved. Put it down to meer stupidity.
However, thanks for the insight in the use of DBMS_JAVA.GRANT_PERMISSION as it's something I wanted to try next.
Thanks again.
Wilson Received on Fri Aug 02 2002 - 09:22:41 CEST