Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How can I set all datamembers in SQL ?

Author  Topic 

TAK
Starting Member

1 Post

Posted - 2007-02-27 : 11:04:26
For example I have the following TYPE

"CREATE OR REPLACE TYPE ATestType AS OBJECT (
myTest REF ATestDataType
,myTestArray VARRAY(999999999) OF REF ATestDataType
,myData VARRAY(999999999) OF RAW(1)
) FINAL"

"CREATE TABLE TABLE_ATESTTYPE OF ATestType"

How can I INSERT or UPDATE a REF datamember like myTest?
How can I INSERT or UPDATE an array of REF datamembers like myTestArray?
How can I INSERT or UPDATE ab array of RAW datamembers like myData?

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-02-27 : 11:23:10
This is a Microsoft SQL Server website.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-27 : 11:25:29
This is a SQL Server forum, you'll need to post your question on an Oracle forum. Try http://dbforums.com or http://forums.oracle.com
Go to Top of Page
   

- Advertisement -