When we create a stored procedure,if db object already exists we will get

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

Question Posted / baba

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between delete and truncate commands? : Sql dba

994

Is postgresql a server?

992

Is ms sql is free?

951

What is lexical units in pl sql?

1043

What is varray in pl sql?

1005

What are the two different parts of the pl/sql packages?

1024

What is sql and db2?

939

What does count (*) mean?

871

Does pdo prevent sql injection?

881

What is t sql used for?

969

What is application trigger?

945

How many subqueries can be nested in a statement?

931

Can we use two order by clause in query?

918

Differentiate between sga and pga.

1087

tell us something about heap tables. : Sql dba

1047