CREATE OR REPLACE PROCEDURE ProcName(strUserID in Varchar2,intErrorID Out number)IS
tempvar varchar2(20);
Begin
intErrorID := 0;
Select value Into tempvar From mytable Where Name='TRANSDATE';
If tempvar Is Not Null Then
Raise e_TransDate_Not_Found;
End If;
Exception
When e_TransDate_Not_Found Then
--DBMS_OUTPUT.PUT_LINE('TransDate Not Found');
--Rollback;
intErrorID := 1;
When others Then
intErrorID := 1;
End;