SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the advantage of using sub procedures in a procedure instead of using package?

msJan 31 2016 — edited Jan 31 2016

Hi,

I have many procedures in my company's database and when you read them you find that there are lots of sub procedures inside them. Can somebody suggest what are the advantages of using sub procedures in a procedure over using a Package where we can use/define procedures and functions?

Regards

user11997351

Any resolution like timeout parameters suggested by any on this problem. we faced the same problem today.

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2016

Added on Jan 31 2016

#procedure

6 comments

330 views

SQL & PL/SQL

What is the advantage of using sub procedures in a procedure instead of using package?

Comments

Post Details