Home » SQL & PL/SQL » SQL & PL/SQL » Member Functions of Oracle Objects
Member Functions of Oracle Objects [message #36869] Fri, 28 December 2001 09:52 Go to next message
Tim
Messages: 49
Registered: October 2000
Member
I have two Oracle objects, one is an Account object and the other is an Audit object. The Account object contains an instance of my Audit object, which handles auditing all actions done with the Account object. The problem is that if I use a Member Function I cant seem to do anything with the objects. For instance, if I am in my SAVE_DATA function inside my Account object, I can not set variables in my Audit object or call any of its functions and procedures, nor can I even manipulate any of my Account objects internal member variables. I have checked my books and cant find any documentation on this. A solution I have found is to use procedures, but I would like to use functions if I could.
Thanks

----------------------------------------------------------------------
Re: Member Functions of Oracle Objects [message #36911 is a reply to message #36869] Thu, 03 January 2002 08:27 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
Try using an appropriate PRAGMA RESTRICT_REFERENCES() for functions.

----------------------------------------------------------------------
Previous Topic: searching tabe character in a variable always returns zero
Next Topic: Spooling Results into Variable File Name.????
Goto Forum:
  


Current Time: Tue Nov 26 15:05:24 CST 2024