-
"Unsupported feature" Exception in registerIndexTableOutParameter() of Oracle 8.1.7
Hi,
I have a stored procedure
CREATE OR REPLACE PACKAGE TMP1 IS
TYPE PROJECT_ID_TYP2 IS TABLE OF PROJECT.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
PROCEDURE SP_TEMP(V_EMP_NBR IN EMPLOYEE.EMPLOYEE_NBR%TYPE,
V_TIME_PERIOD_ID IN TIME_PERIOD.TIME_PERIOD_ID%TYPE, TS_PROJECT_ID OUT PROJECT_ID_TYP2);
End;
....
PROJECT.PROJECT_ID type is NUMBER.
In Java, i have written like this...
int maxTablLen=100;
int eleMaxLen=100;
cstmt3.setInt(1,iEmpNo);
cstmt3.setInt(2,iTimePeriod);
cstmt3.registerIndexTableOutParameter(3, maxTablLen, OracleTypes.NUMERIC, eleMaxLen);
cstmt3.execute();
while running this java file, i got "java.sql.SQLException: Unsupported feature" in cstmt3.registerIndexTableOutParameter() line.
My oracle version is 8.1.7
Anybody can help me to solve this problem?.
Thanks in anticipation,
Joseph Leo
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|