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

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

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;

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.

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);

Answer / thra

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

Can cursors be part of a trigger body?

0 Answers  

If the base table structure is changed what will happen to join index????

2 Answers  

What is inner join in sql?

0 Answers  

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

What is query execution plan in sql?

0 Answers  

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

What is a cursor for loop ?

4 Answers  

What do you mean by table in sql?

0 Answers  

Can we group by two columns in sql?

0 Answers  

What is structural independence and why is it important?

0 Answers  

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

How can you save or place your msg in a table?

0 Answers