Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> XMLType and registerOutParameter

XMLType and registerOutParameter

From: Brian E Dick <bdick_at_cox.net>
Date: Wed, 11 Jun 2003 23:44:37 -0400
Message-ID: <EGSFa.1605$PY2.1054@lakeread05>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US