IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Some other thoughts on TREAT
I see that TREAT was not implemented in Oracle until release 2 of 9i - which is probably why the docs you have say it's not supported.

Playing a bit more, I see that functions which return values can be used with the dot notation:

i := TREAT(scribble(1) AS rectangle).getHeight(); -- this works

TREAT(scribble(1) AS rectangle).setHeight(50); -- this doesn't compile

I can't tell whether the function call does a copy, though I don't see why it would be different than what I had on the previous posts.
New I'll pass that on
And as soon as I get 9.2 up on my box I'll start playing with it as well.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Objects, REFs, and Oracle collections - (admin) - (10)
         Will TREAT not work? - (ChrisR) - (7)
             Interesting... - (admin) - (6)
                 Just playing around - (ChrisR) - (3)
                     The problem with REFs: - (admin) - (2)
                         Quickly exhausting my sum total of PL/SQL knowledge :-) - (ChrisR) - (1)
                             Re: Quickly exhausting my sum total of PL/SQL knowledge :-) - (admin)
                 Some other thoughts on TREAT - (ChrisR) - (1)
                     I'll pass that on - (admin)
         can you not bang out to .dat files in the OS? - (boxley) - (1)
             In-memory, transient. - (admin)

I think someone is doing some projecting here.
85 ms