API Builder: Sample PLSQL

The following stored procedures can be used to create APIs within the EMPDB database connection (available within free trial subscriptions).

Copy and paste the stored procedure definition within the procedure block of a DB Procedural Definition API.

Stored Procedure 1 (Create a New Employee):  

procedure PKG_EMP.INSERT_EMP (

P_ENAME varchar2,

P_JOB VARCHAR2,

P_MGR VARCHAR2,

P_HIREDATE VARCHAR2,

P_SAL VARCHAR2,

P_COMM VARCHAR2,

P_DEPTNO VARCHAR2,

P_STATUS OUT varchar2 ,

P_STATUS_MSG OUT varchar2 ) ;

Stored Procedure 2 (Change an Employee's Name):
procedure PKG_EMP.CHANGE_ENAME (
P_EMPNO varchar2,
P_NEW_ENAME varchar2,
P_STATUS OUT varchar2 ,
P_STATUS_MSG OUT varchar2 ) ;

Stored Procedure 3 (Change an Empoyee's Job):
procedure PKG_EMP.CHANGE_JOB (
P_EMPNO varchar2,
P_NEW_JOB varchar2,
P_STATUS OUT varchar2 ,
P_STATUS_MSG OUT varchar2 );