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!

Navigation through REF variables is not supported in PL/SQL

611320Jan 6 2008 — edited Jan 6 2008
create type bank (
money number,
member procedure transfer(recipient ref bank, amount number)
);
create type body bank as
member procedure transfer(recipient ref bank, amount number) as
begin
self.money := self.money - amount;
recipient.money := recipient.money + amount; /* ERROR PLS-00536: Navigation through REF variables is not supported in PL/SQL. */
end;
end;

How do I do this correctly?

I'm using Oracle 10.2 .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2008
Added on Jan 6 2008
5 comments
1,771 views