Home » SQL & PL/SQL » SQL & PL/SQL » procedure / package
procedure / package [message #224712] Thu, 15 March 2007 04:05 Go to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Is it possible to have same name for package and the procedure in that package. if yes then how oracle understands?
Re: procedure / package [message #224718 is a reply to message #224712] Thu, 15 March 2007 04:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try to create them and see.

By
Vamsi
Re: procedure / package [message #224746 is a reply to message #224718] Thu, 15 March 2007 05:49 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Thanx a ton... I have created and checked.Now i understood.
Re: procedure / package [message #224750 is a reply to message #224746] Thu, 15 March 2007 05:53 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Please share it.
It may useful to someone else.

By
Vamsi
Re: procedure / package [message #224762 is a reply to message #224750] Thu, 15 March 2007 07:02 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Package , procedure , functions are all different objects .so we can use the same name.Only thing is we will get confused if we use the same name.
Re: procedure / package [message #225596 is a reply to message #224762] Tue, 20 March 2007 07:58 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
subramanian.sp wrote on Thu, 15 March 2007 08:02
Package , procedure , functions are all different objects .so we can use the same name.Only thing is we will get confused if we use the same name.


Quite simply wrong.
Re: procedure / package [message #225598 is a reply to message #224762] Tue, 20 March 2007 08:01 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
subramanian.sp wrote on Thu, 15 March 2007 13:02
Package , procedure , functions are all different objects .so we can use the same name.Only thing is we will get confused if we use the same name.


SQL> desc concat_all
FUNCTION concat_all RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 CTX                            CONCAT_EXPR             IN

SQL> create or replace procedure concat_all
  2  as
  3  begin
  4    dbms_output.put_line('Will this work?');
  5  end concat_all;
  6  /
create or replace procedure concat_all
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


I rest my case.

MHE
Previous Topic: show selected columns only
Next Topic: Unable to extend in TEMP tablespace because of GROUP BY clause
Goto Forum:
  


Current Time: Sat Dec 10 03:04:30 CST 2016

Total time taken to generate the page: 0.05712 seconds