AboutSuchitra Joshi Expertise I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.
Experience 10+ years D2K
Awards and Honors OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, Database, PL/SQL
Question what are the types of procedures?
what is the difference between stored procedures& stand-alone procedures?
Answer Hi Smita,
As you pointed out, there are only two types of procedures - stored and stand alone.
Stored procedures are stored in the database. So they can be accessed by different applications (if proper grants are given). Maintenance is minimum since it is stored only in one place.
eg. create or replace procedure p1 as
begin
...
end;
The procedure p1 will be stored in the database.
Stand alone procedures are pl/sql blocks written in any application code. Since they are not stored in database, if another application requires same procedure, you will have to rewrite it in that application. So more maintainence cost. No easy access.
