Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> XMLType and registerOutParameter
I have a stored procedure that returns a XMLType as an OUT parameter. I
can't find any example in the docs for using XMLType and the
registerOutParameter method. What should "XXXX" and "YYYY" be in the
following.
create or replace procedure foo (a OUT XMLType)
as ...
OracleCallableStatement cs = conn.prepareCall ("{ call foo(?) }");
cs.registerOutParameter(1,OracleTypes.XXXX);
cs.execute();
String result = cs.getYYYY(1);
Thanks
BEDick
Received on Wed Jun 11 2003 - 22:44:37 CDT