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

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

How can we make an if statement within a select statement?

733


Can we insert data into materialized view?

708


What is Difference Between Unique and Primary Key Constraints?

822


What mean sql?

736


Which command is used to call a stored procedure?

709






What is break?

841


How can I see all tables in sql?

726


what is error ora-03113: end-of-file on communication channel?

815


What do you understand by case manipulation functions?

727


Is nosql faster than sql?

743


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1916


What are the different tcl commands in sql?

813


What are basic techniques of indexing?

1066


Can sql function call stored procedure?

731


What is before trigger?

731