Hello,
We have a simple stored procedure that we can't get it to work with Java. We are using Oracle 8.1.7 driver and oracle 8i db(8.1.6.1.0) on NT4, with JDK1.3. The stored procedure only has one parameter, PLSQL table indexed by char.
An error occurs when on call_proc.execute() line.

This is an error that we get:
java.sql.SQLException: ORA-06550: line 1, column 16:
PLS-00418: array bind type must match PL/SQL table row type
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

This sounds like a bug with Oracle 8.1.7 driver, but maybe we are doing something wrong. Please help!

Thanks in advance.


(1). Here is the code:

/* package */
create or replace package temppack
is
Type CHAR_TBL IS TABLE OF CHAR(1)
INDEX BY BINARY_INTEGER;

END TEMPPACK;
/* stand alone procedure */
create or replace procedure testchar(ab out temppack.char_tbl)
is
begin
for i in 1 ..10
loop
ab(i):=i;
end loop;
end;


/* Sample code */

import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;


public class testchar {
public static void main(String[] args)
throws SQLException
{
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn=
DriverManager.getConnection("jdbc:oracle:oci8:test/test@testdev");
OracleCallableStatement call_proc =(OracleCallableStatement)
conn.prepareCall("begin testchar(?);end;");

int elemSqlType = Types.CHAR;
int maxLen = 10;
int elemaxLen = 1;

call_proc.registerIndexTableOutParameter(1,maxLen,elemSqlType,elemaxLen);
call_proc.execute();
// access the value using JDBC default mapping
int a=0;
String[] values = (String[])
call_proc.getPlsqlIndexTable (1);
// print the elements

for (int i=0; i<values.length; i++)
System.out.println (values[i]);
call_proc.close();
}

catch (SQLException e)
{
System.out.println(e.toString());
}

}
}