Home » Developer & Programmer » JDeveloper, Java & XML » Passing nested table containing objects (Oracle DB 10g Release 10.2.0.3.0 - Prod, Linux)
Passing nested table containing objects [message #442836] Wed, 10 February 2010 22:34
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi Friends,

I have a nested table type as an IN parameter in a stored procedure like below in Oracle 10g database.

CREATE OR REPLACE TYPE scott.o_emp_type AS OBJECT (
   empno   NUMBER,
   ename   VARCHAR2 (10),
   job     VARCHAR2 (9)
);

CREATE OR REPLACE TYPE scott.t_emp_type AS TABLE OF o_emp_type;


CREATE OR REPLACE TYPE scott.o_dept_type AS OBJECT (
   deptno        NUMBER,
   dname         VARCHAR2 (14),
   loc           VARCHAR2 (13),
   tt_emp_type   t_emp_type
);

CREATE OR REPLACE TYPE scott.t_dept_type AS TABLE OF o_dept_type;


Please suggest me a way in java how to pass this a value to this particular type.

Kindly give me example specific to this nested table type.

Regards,
Marlon.
Previous Topic: how to code adf in jdeveloper
Next Topic: Oracle 9i, 9.2.0.1.0., RHEL 2.1 AS, jdk 1.3
Goto Forum:
  


Current Time: Thu Sep 29 10:50:33 CDT 2016

Total time taken to generate the page: 0.12575 seconds