What is the difference between stand alone procedures and stored procedures?

Questions by madhuk17   answers by madhuk17

Showing Answers 1 - 5 of 5 Answers

Ashish Kumar Jain

  • Sep 6th, 2015

In that case there is no difference. Because both of them are stored outside of package

  Was this answer useful?  Yes

Naresh Bandla

  • Dec 1st, 2015

Stand Alone Procedure: A procedure which is not enclosed in a package is called Stand Alone Procedure.

Stored Procedure: A Procedure which is defined in Package is called Stored Procedure and if we want to call that procedure out of package is to use <PKG Name>.<Procedure Name>

Praveen kumar

  • Jan 8th, 2016

Both are same

  Was this answer useful?  Yes

Habib Ali

  • May 8th, 2016

Stand Alone Proc: Block of PLSQL code but not defined in the data dictionary, hence not reusable
Stored Procedure: Block of PLSQL code Defined in data dictionary, implements reusability. Check in user_source table

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions