We are currently experiencing an issue with JDBC Drivers. When we are trying to execute a stored procedure in oracle via middleware SAP Exchange Infrastructure we get an error saying
07:55:36 (4332): Error parsing message content: Technical description "java.sql.SQLException: 'Unsupported parameter type 'REF' for parameter 'outResult' found"
07:55:36 (4333): Error processing message: "java.lang.Exception: Message '37d1da51-5611-0940-8fd1-f44d874abfd4' preparation for database insert failed" - rollback DB
The above error is an exception raised by JDBC driver.
In XI configuration we directly use ODBC Driver as shown below
db.jdbcDriver=oracle.jdbc.driver.OracleDriver
db.connectionURL=jdbc:oracle:oci8:
Here is the store procedure code
PROCEDURE CCREP
( inSapSoldTo in string, --like '120120', no leading zeroes
inYtdOrMtdMode in string, --'YTD' will select a year summary, otherwise a month summary
inDateOrYear in string, --like 'JAN04' for month or '2004' for year
--outResult out integer)
outResult out types.t_cursor)
as
c_ccrep types.t_cursor;
dateSpec varchar(15);
BEGIN
begin
if (inYtdOrMtdMode = 'YTD' ) then -- Return a Year To Date Report
dateSpec := indateOrYear || ' Y-T-D'; -- e.g. '2004 Y-T-D'
else --Return a Month To Date report
dateSpec := indateOrYear; -- e.g. 'JAN04'
end if;
open c_ccrep for
SELECT SEQ, NAME, PCT, COUNT, AMOUNT, AMOUNT_TOTAL
FROM CCREPORT_DETAIL
WHERE SAP_SOLDTO=inSapSoldTo and ccr_month in dateSpec
ORDER BY SEQ;
end;
--outResult:=1;
outResult:=c_ccrep;
END; -- Procedure
Currently the work around we have is we are executing a SELECT via XML from XI and returns the result set. But we don’t want to build SELECT SQL in XI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.