OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Procedures

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

Procedures [message #10683]

Mon, 09 February 2004 23:18

Peter
Messages: 62
Registered: August 2000

Member

if you create a standalone procedure and a package with the same procedure name, how does oracle behave?? any errors??

Report message to a moderator

Re: Procedures [message #10685 is a reply to message #10683]

Tue, 10 February 2004 00:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

No erorrs. A procedure will be called like this: package_name.procedure_name(params) while a procedure will be called like: procedure_name(params)

MHE

Report message to a moderator

Re: Procedures [message #10706 is a reply to message #10683]

Wed, 11 February 2004 01:36

Sebastian Varghese
Messages: 12
Registered: October 2003

Junior Member

Hi peter..
I think there is a slight confusion in your question.

Case 1
1. If u create a package and a procedure with the same name , oracle will give u an error stating that the object is already created.

2.If u create an independent procedure and a procedure with the same name within a packege, it would not create any problems since the procedure within the package will be reffered by the dot Package.Procedure notation

Report message to a moderator

Previous Topic:	Query required
Next Topic:	URGENT! How can I use $HOME in SQL*Plus?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:18:25 CDT 2024