| Invoking methods on objects using SQL (not PL/SQL) [message #374176] |
Tue, 29 May 2001 10:33 |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
I have a question. I know that objects can be held on the database, and
that objects have methods. But how do I invoke the methods, especially PROCEDURES, not FUNCTIONS which can be invoked using a SELECT?
Assume the following example:
I have two objects on the database in table COUNTRY:
USA population 280M
CAN population 195M
I have a method called birth, which increments the population by 1. How do
I invoke that for USA? Must I create an object in PL/SQL, retrieve into
it, invoke it on the instantiated PL/SQL object, and then replace it in the
database? Seems rather messy to me.
Thanks for your help.
Jon
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
