ERPstuff - Oracle EBS Community

SQL> CREATE OR REPLACE PACKAGE test AS 2 FUNCTION test1(p_val IN number) 3 RETURN NUMBER; 4 END test; 5 / Package created. SQL> CREATE OR REPLACE PACKAGE BODY test AS 2 FUNCTION test1(p_val IN number) 3 RETURN NUMBER IS 4 VAL NUMBER; 5 BEGIN 6 VAL := p_val + 10; 7 RETURN VAL; 8 END test1; 9 END test...

Basic Syntex for a Procedure: <b><font color="blue">DECLAGE </b></font id="blue"><font color="green">(Optional, used to declare variables, types, cursors etc)</font id="green"> ... ... <b><font color="blue">BEGIN</font id="blue"></b> <font ...