Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using oracle.sql.STRUCT to pass in a COMPLEX OBJECT

120853Jun 21 2003 — edited Sep 12 2003
I need to pass in a complex object (object with nested array of objects) into a oracle stored procedure.

We are using JDBC 9.2.0.1 drivers...

Note i am able to retrieve a complex object successfully using an oracle struct however i am not able to pass in the struct.

I do not want to use JPublisher as we are not using SQLJ.
I have looked through the documentation on using default structs and am getting an error when i try and create the struct...

I have created an array of objects with a sub array
and i create a struct descriptor however when i create the actual oracle struct

like

oracle.sql.Struct = new oracle.sql.Struct( structDesc,conn,complexobject)

I get a "java.sql.SQLException: Internal Error: Unable to resolve name"

Do i have to create STRUCTS for the nested object first ?

And then nest that STRUCT within the PARENT STRUCT to pass in complex objects ???

Any help would be much appreciated...

Gurinder
email gran@travelunderwriters.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2003
Added on Jun 21 2003
6 comments
3,351 views