Skip to Main Content

SQL & PL/SQL

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!

Insert an entire object into an object table

Bruce ClarkJun 7 2010 — edited Jun 7 2010
Hi:

I have created an object that has 3 attributes. The first two are simple scalar datatypes and the third is another object.

I have created a table of the object tyep.

Now, I have a function that returns an instance of the object type to a calling procedure. I want the procedure to insert the passed object into the object table.

How can I write this insert statement so that it inserts the entire object into the table? Can I reference the entire object or must I specify each attribute:

Please help.

Thanks.

Bruce
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2010
Added on Jun 7 2010
4 comments
999 views