Basic use of Oracle's procedure

Create or Replace procedureFind_info (PIDinch  Number) as                   --Defining incoming VariablesV_namevarchar2(Ten);--Define name VariablesV_salary Number;--Define wage variablesSqlstrvarchar2( $);--defining encapsulated SQL statement variablesbeginsqlstr:='select name, salary from TMP where id=:1';--Encapsulating SQL statements  ExecuteImmediate SQLSTR intoV_name,v_salary using PID;--executing encapsulated SQL statements and using bound variablesDbms_output.put_line (v_name||'the income is:'||To_char (v_salary));--Print name RevenueException whenOthers ThenDbms_output.put_line ('no corresponding data found');--Printing ExceptionsEndFind_info;

Basic use of Oracle's procedure