Simple Oracle Stored Procedure instance

Simple Oracle Stored Procedure example:

1. stored procedures without any parameters (output system date)

Create or replace procedure output_date is

Begin

Dbms_output.put_line (sysdate );

End output_date;

2. Stored Procedures with parameters in and out

Create or replace procedure get_username (v_id in number, v_username out varchar2)

As

Begin

Select username into v_username from tab_user where id = v_id; -- variable assignment

Exception

When no_data_found then

Raise_application_error (-20001, 'Id does not exist! ');

End get_username;

This article introduces the knowledge of Oracle database storage through instance analysis and visualizes specific problems, which is more conducive to understanding and learning, I hope the content mentioned above will be helpful to you.