I am trying to use Oracle Toplink in my java app to pass objects to
oracle. I am using version 10.1.3 of Toplink and 10.2.0.1 oracle DB. I
am developing in RAD 6.0. Or if someone knows how to do it in
JDeveloper then I get figure it out too.


I am using the following code and getting an error - 'Internal
Exception: java.sql.SQLException: Invalid column typeError Code: 17004'.

I am not a Java developer, just a DBA. Any help would be great.


-----------------------------------------------------------
NameTest nt = new NameTest();
  nt.setFirstName("Tom");
  nt.setLastName("Thumb");

  StoredProcedureCall call = new StoredProcedureCall();
  call.addNamedInOutputArgument("test_black_box",
       "test_Object",
       "test_Object",
       Object.class);
  ValueReadQuery query = new ValueReadQuery();
  query.setCall(call);
  query.addArgument("test_Object");
  Vector args = new Vector();
  args.addElement(nt);
  STRUCT result =
(STRUCT)((Server)getSession()).acquireClientSession().executeQuery(query,
args);
--------------------------------------------------------------------------
Create or Replace TYPE UWSTIS.TEST_OBJECT AS OBJECT (
 
  fName        varchar2(30),
  lName        varchar2(30),

  CONSTRUCTOR FUNCTION TEST_OBJECT
  RETURN SELF AS RESULT,
 
  MEMBER PROCEDURE toString
  );
---------------------------------------------------------

CREATE OR REPLACE function test_black_box
  (test_object     IN uwstis.TEST_OBJECT)
RETURN uwsths.error_list_t IS
BEGIN

  /* Test input sr_array */
  DELETE from uwsths.black_box_test_input;

    INSERT INTO uwsths.black_box_test_input
       VALUES ( test_object.fName,
               test_object.lName,
               null,
               null,
               null,
               null);
  COMMIT;
RETURN error_array;
END test_black_box;
-----------------------------------------------------

--
http://www.freelists.org/webpage/oracle-l