I am just in very good mood in the morning having strong ginger tea. Just I got an excellent idea on Stored procedure with SQL.
The exact point that I need to say is difference in coding of if condition for both COBOL and SQL procedure.
In COBOL, you write IF condition like below.
IF EXPRESSION DO THIS ELSE DO THIS END-IF
In SQL procedure
Connect ap/ap; Set serveroutput on; Declare Variable declaration... BEGIN IF EXPRESSION THEN DO THIS ELSEIF Expression THEN DO THIS ELSE DO THIS END IF; END; /