Create stored procedure pl/sql in oracle

Monday, May 29th, 2017 (0 Comment)

We will practice to create stored procedure pl sql in oracle to manage create/update/delete or select data in database tier.

We can create function create/update/delete or select data in application tier. But if we need many tables information then we have to do this matter in database tier.

We will many way to create stored procedure by pl sql with many parametter

1) Create stored procedure simple by pl/sql in oracle

Test

Output

2) Create store procedure with in and out parameters

Test

Output

3) Create store procedure with cursor parameter

Test

Output

In all stored procedure, we use exception to get error if have. We can get exception and set output parameter for application tier get value to handling.

To get out parameter cursor from oracle in java use CallableStatement stmt

 

Tags: , ,

Related Posts

database
How to create function return table or cursor in oracle
database
Create group user class by using object oriented plsql
database
Functions encrypt decrypt and checksum oracle
database
Check tablespace usage percent in oracle

Related Posts

database
How to create function return table or cursor in oracle
database
Create group user class by using object oriented plsql
database
Functions encrypt decrypt and checksum oracle
database
Check tablespace usage percent in oracle

Leave a Reply

Your email address will not be published. Required fields are marked *