Re: obtain info from nested table in function?

Oeln wrote:

>>You should be using REF and DEREF if you are trying to create
>>referential integrity with a nested table. Go to
>>http://tahiti.oracle.com and look up REF and DEREF.
>>
>>You can find an example at:
>>http://www.psoug.org/reference/nest_tab_cons.html
>>Scroll down to REFERENTIAL CONSTRAINT.

> 
> 
> Okay, thanks for the input. I guess that ought to improve the
> integrity of the nested table object(s) I've got, too..

It will. But don't expect REF to work like a foreign key constraint: It isn't. So do a lot of testing. One huge difference is that your can truncate the parent and the reference remains ... it is invalid ... but it remains.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)