Can you have multiple SPs with the same name on a database?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

6 Answers
10748 Views
CGI, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can you have multiple SPs with the same name on a database? ..

Answer / jithendranath.g

both above answers are correct,but situvationd diff
1) we can't create same db obj with same name,
2) we want that go for packages ,with overloading concept

Is This Answer Correct ?

14 Yes

0 No

Can you have multiple SPs with the same name on a database? ..

Answer / baba

When we create a stored procedure,if db object already
exists we will get a message that
ERROR at line 1:
ORA-00955: name is already used by an existing object

Is This Answer Correct ?

10 Yes

1 No

Can you have multiple SPs with the same name on a database? ..

Answer / ashok

IT WILL ONLY POSSIBLE FOR IN THE PACKAGE.
EX--
CREATE OR REPLACE PACKAGE PK_TEST AS
PROCEDURE PR_SHOW();
PROCEDURE PR_SHOW(V_NAME VAR CHAR);
END PK_TEST;

Is This Answer Correct ?

5 Yes

0 No

Can you have multiple SPs with the same name on a database? ..

Answer / suman

Hi ,

As per standard Procedure & Function we cannot create same name of Procedure but if you are using in Package you can have same name with different parameter.

Is This Answer Correct ?

0 Yes

0 No

Can you have multiple SPs with the same name on a database? ..

Answer / harsha

Yes We can have multiple SP's with same name.This is called
overloading a Procedure with different parameters.
e.g. CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER);
CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER
UNITS IN NUMBER);

Is This Answer Correct ?

4 Yes

6 No

Can you have multiple SPs with the same name on a database? ..

Answer / thra

yes procedure can have same name overloading differ in data
type ....etc;

Is This Answer Correct ?

2 Yes

5 No

Post New Answer