OraFAQ Forum: Server Administration » Invoking methods on objects using SQL (not PL/SQL)

Home » RDBMS Server » Server Administration » Invoking methods on objects using SQL (not PL/SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Print out
Next Topic:	Leading Zeros

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:25:35 CST 2024