> -----Original Message-----
> From: Irv Salisbury III [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 11, 2003 6:38 PM
> To: [EMAIL PROTECTED]
> Subject: SQLTransformer stored procedure question
> I call an existing stored procedure with:
>
> <sql:execute-query>
> <sql:query isstoredprocedure="true">
> begin qChange.R_IMS_CHANGE( 'ALZHEIMERS', '1999 Q3',
> 'NRX', ?); end;
> </sql:query>
> <sql:out-parameter sql:nr="1" sql:name="resultset"
> sql:type="oracle.jdbc.driver.OracleTypes.CURSOR"/>
> </sql:execute-query>
>
> However, I get an "ORA-08103: object no longer exists error" at
> SQLTransformer:1250. This line looks like it is simply calling
> getObject on the CallableStatement. Any reason why I might be getting
> this ?
Irv,
the syntax is correct... it could be a JDBC driver problem... hmmm...
Could you try the same statement using Java instead of Cocoon ?
Regards,
P.S.
You're absolutely sure that SP, with those parameters' values, returns a valid cursor,
aren't you ?
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
