Give an example for calling procedure with user and system exception

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 29th, 2008

Simple example for predefined exception CREATE OR REPLACE PROCEDURE TEST_PROC AS A NUMBER ; BEGIN A := 'TEST'; DBMS_OUTPUT.PUT_LINE('THE VALUE OF A = '||A); EXCEPTION WHEN VALUE_ERROR ...

ravenkumar

 Profile Answers by ravenkumar Questions by ravenkumar

• Mar 17th, 2008

set serveroutput on;create or replace procedure proc1 (emp_id in emp.employee_id%type, emp_na out emp.last_name%type, emp_sal out emp.salary%type, emp_job out emp.job_id%type) is &...

Answer Question  Select Best Answer