Unable to call stored procedure to retrieve records which has CURSOR in it

, ,
1

I had created a JDBC adapter service to call the stored proc PKG1.GET_ROW using storedprocedurewithsignature template and tried to run it with input as 1234 and got the following error

Could not run ‘callLocalTestSPSing’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Prashanth.Services:callLocalTestSPSing.
[ADA.1.316] Cannot execute the SQL statement “{?= call PARTSERP.PKG1.GET_ROW( ?, ?, ?, ?)}”. "
(17004) Invalid column type"
Invalid column type
WM Version: 7.1
JDBC adapter version: 6.5
Database version: Oracle 10g/Oracle XE
Can anyone help me in running the stored procedure using storedprocedurewithsignature template or storedprocedure template.

Here are the table and package details:
create table test
(partno varchar2(100), partdesc varchar2(100), qtyavail varchar2(100))

insert into test values(‘1234’,‘tape’,‘1’);
insert into test values(‘1234’,‘tape’,‘2’);
insert into test values(‘1235’,‘tape’,‘3’);
insert into test values(‘1235’,‘tape’,‘4’);
insert into test values(‘1236’,‘tape’,‘5’);
insert into test values(‘1236’,‘tape’,‘6’);

CREATE OR REPLACE PACKAGE pkg1
AS
FUNCTION get_row
(client_id IN VARCHAR2)
RETURN test%ROWTYPE;
END pkg1;

CREATE OR REPLACE PACKAGE BODY pkg1
AS
FUNCTION get_row
(client_id IN VARCHAR2)
RETURN test%ROWTYPE
IS
CURSOR c_test (c_id IN VARCHAR2) IS
SELECT * FROM TEST
WHERE partno = c_id;
rec_test test%ROWTYPE;
BEGIN
OPEN c_test (client_id);
FETCH c_test INTO rec_test;
CLOSE c_test;
RETURN rec_test;
EXCEPTION
WHEN NO_DATA_FOUND THEN RETURN NULL;
END get_row;
END pkg1;