overloading of stored procedure is possible in oracle?

Answer Posted / monika

No, Only packaged procedures and procedures exists in
pl/sql blocks can be overloaded.Stored procedures can't.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is function and procedure in pl sql?

515


what are the type of locks ? : Sql dba

523


What is write ahead logging in sql server?

554


What do you understand by pl/sql cursors?

544


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

519






What is the difference between local variables and global variables?

600


What does := mean in pl sql?

548


What are the advantages of stored procedure?

535


Is primary key clustered index?

513


Explain what is an index?

580


How is a PL/SQL code compiled?

664


Is not null in sql?

551


What is a dirty read sql?

472


Is postgresql a nosql database?

529


Why stored procedure is better than query?

502