OraFAQ Forum: SQL & PL/SQL » Can we override a function in PL/SQL environment

Home » SQL & PL/SQL » SQL & PL/SQL » Can we override a function in PL/SQL environment (Oracle 9i,Windows XP/2000,Oracle 9.1.0.2)

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

Can we override a function in PL/SQL environment [message #310442]

Tue, 01 April 2008 05:13

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Dear Team

Could you please tell can we do overriding of a function in PL/SQL Environment.I would be extremely thankful to you if you can provide me any documents

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310447 is a reply to message #310442]

Tue, 01 April 2008 05:28

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Do you mean overload?
manoj12, do you consider yourself to be a PL/SQL expert?

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310452 is a reply to message #310447]

Tue, 01 April 2008 05:42

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Well I am a PL/SQL expert.I am not talking about overloading.I am talking about overriding of a subprogram in PL/SQL.I know what is overloading.Can anybody tell me whether we can do overriding of a subprogram in PL/SQL

[Updated on: Tue, 01 April 2008 05:44]

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310461 is a reply to message #310452]

Tue, 01 April 2008 06:27

Frank
Messages: 7901
Registered: March 2000

Senior Member

Can you explain with an example what you mean?

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310470 is a reply to message #310461]

Tue, 01 April 2008 06:51

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Overriding means - same method names with same arguments and same return types associated in a class and its subclass. Can we do this in Oracle?

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310473 is a reply to message #310470]

Tue, 01 April 2008 06:58

Frank
Messages: 7901
Registered: March 2000

Senior Member

How would you sub-class a package?
How would you perform a call to such a package/procedure?

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310495 is a reply to message #310470]

Tue, 01 April 2008 07:32

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use TYPE.
Search for Barbara Boehmer's posts these last 2 weeks, she posted many useful and complete examples.

Regards
Michel

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310601 is a reply to message #310495]

Tue, 01 April 2008 14:49

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

The following is a link to the section on overriding in the Oracle 9i online documentation:

http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96594/adobjbas.htm#455868

And the following thread contains an example:

http://www.orafaq.com/forum/m/309210/43710/?srch=overriding#msg_309210

I will move this thread back to the pl/sql experts forum where it apparently came from.

Report message to a moderator

Re: Can we override a function in PL/SQL environment [message #310659 is a reply to message #310601]

Tue, 01 April 2008 23:53

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Thank you very much

Report message to a moderator

Previous Topic:	parameterised cursor or nested cursor
Next Topic:	Getting the start and End date of a week

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 07 19:29:45 CST 2025