Hi,

I am passsing an array of objects to oracle stored proc,,
stored proc is declared like this,,

CREATE OR REPLACE TYPE v_rec_test AS OBJECT ( name VARCHAR(5));
/

CREATE OR REPLACE TYPE v_arr_test IS TABLE OF v_rec_test;
/


PROCEDURE testForObj(p_arr_test IN v_arr_test)

AS

BEGIN

INSERT INTO TEMP_ACCOUNT VALUES ('SU','MIT');
COMMIT;

FOR i IN 1 .. p_arr_test.count
LOOP

-- DBMS_OUTPUT.PUT_LINE('RECORD NAME: ' || p_arr_test(i).name);
-- DBMS_OUTPUT.PUT_LINE('RECORD NUMBER: ' || p_arr_test(i).num);

INSERT INTO TEMP_ACCOUNT VALUES (p_arr_test(i).name,'obj');
commit;


END LOOP;

END;

From java class,,,

Object objTest[] = {"sumit"};

Object arr[] = new Object[] {objTest};

And then passing this arr to proc "testForObj",,

It gives error as "Inconsistent java and sql object types",,,,,

Please let me know what can be done regarding this!!!