Posted: Thu Apr 25, 2013 3:42 am Post subject: JDBC-adapter fails to call an oracle stored procedure
Apprentice
Joined: 10 May 2012 Posts: 29
Hi!
I have problems using a Websphere adapter for JDBC in order to call an Oracle stored procedure. I haven't found any similar postings here with the questions answered.
The procedure looks like this:
Code:
create or replace
PROCEDURE sp_myproc(par_out OUT SYS_REFCURSOR)
as
begin
open par_out for select * from my_table;
end;
,
I get the following error: "ResultSet as output parameter for Stored Procedure not supported for database Oracle and JDBC Driver oracle.jdbc.OracleDriver".
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum