FUNCTION, PROCEDURE and PACKAGE

Hi Akshay,

Package::-It stores and compiles all the functions and procedures declared in SGA(System Global Area).Whenever stored procedures or functions are called from this package, it will get them from SGA.So it performance is definitely high.

Procedures::-They are subprograms which perform certain action. They cannot be called from select statement.

Functions::-They are subprograms which return a value. They can be used in select statement and also its return value can be assigned to a variable.

Please refer the below link

http://www.brilliantsheep.com/difference-between-plsql%E2%80%99s-function-procedure-and-package/

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Akshay,

Package::-It stores and compiles all the functions and procedures declared in SGA(System Global Area).Whenever stored procedures or functions are called from this package, it will get them from SGA.So it performance is definitely high.

Procedures::-They are subprograms which perform certain action. They cannot be called from select statement.

Functions::-They are subprograms which return a value. They can be used in select statement and also its return value can be assigned to a variable.

Please refer the below link

http://www.brilliantsheep.com/difference-between-plsql%E2%80%99s-function-procedure-and-package/

Thanks