RE: Deep Copy a Record

From: Mark W. Farnham <>
Date: Fri, 16 May 2008 07:19:23 -0400
Message-ID: <000001c8b746$b928c630$>

I take it by "deep copy" you mean the object operation.  

Any "deep copy" requires a defined constructor. The reasonable presumption on an Oracle list if you start talking about Department and Employees is that you are making a reference to the example database. In that context Department is a table, not a user defined object with a pre-defined "clone" constructor. In that context Mr. Bobak is exactly correct.  

There is also a pretty long section in the Oracle manuals since 8.0 beta about what Oracle does and does not handle regarding objects defined in Oracle. If you want to define and manipulate objects natively in Oracle as opposed to in an object oriented programming language using an Oracle database for storage, look there for the release you're at. I don't know whether there are any experienced users of the native Oracle objects on this particular list.  

As for enhancements, after you digest what is and is not there for objects defined in Oracle, there are defined enhancement processes available to the members of IOUG, OAUG, and ODTUG, and if you can join the Oracle Mix forum you can make suggestions there.  



From: [] On Behalf Of Dixit, Sandeep
Sent: Friday, May 16, 2008 5:18 AM
To: Bobak, Mark
Subject: RE: Deep Copy a Record  


There must be a good reason why this features is not given.  

Is there a place to discuss new features or unavailable features or to put forward the suggestions?  


From: Bobak, Mark [] Sent: Thursday, May 15, 2008 9:40 PM
To: Dixit, Sandeep; Subject: RE: Deep Copy a Record  

Not without writing code, no.  


Mark J. Bobak


-- Received on Fri May 16 2008 - 06:19:23 CDT

Original text of this message