Stored Procedures Having Object

[Nishant Modak]

Hello,

I have a following SP. on Oracle 10g.

   create or replace PROCEDURE NPROC
( param1 IN NTEMP
) AS
BEGIN
 dbms_output.enable;
      dbms_output.put_line ('test started');
  NULL;
END NPROC; 

and the NTEMP is defined as a Type

 create or replace TYPE NTEMP AS OBJECT
( 
fname  VARCHAR2(10),
lname VARCHAR2(10)
);   

------

I want to invoke this via JAVA. for which I have written the following code.

 		NTEMP temp = new NTEMP();
		temp.setFname("abc");
		temp.setLname("xyz");
		CallableStatement callableStatement ;
		Connection con = DataSourceUtil.getDatabaseConnection();
		try {
			callableStatement=	con.prepareCall("{call NPROC (?)}");
			callableStatement.setObject(1, temp);
			callableStatement.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
   

I get the following error on such usage

java.sql.SQLException: [BEA][Oracle JDBC Driver]Unable to determine the type of the specified object.
SQLSTATE : HY000

Any clues?

Thank You!

[Prabhakar Reddy Bokka]

You should choose the object of a type supported by your oracle and java.

In your case it is a type of array of strings in java.

For detailed data types accepted by both you can look into java.sql.Types