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 ...

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 color="green">(required, all executables are coded here ...