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;

What is the use of index in sql?

0 Answers  

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

What is offset in sql query?

0 Answers  

How do you declare a constant?

0 Answers  

How will we see framework of a table?

2 Answers   Accenture,

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

Why are aggregate functions called so?

0 Answers  

How is debugging done?

0 Answers  

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

What are the types of variables use in pl sql?

0 Answers  

Can we use update in sql function?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers