API Builder: Sample PLSQL

Modified on Tue, 3 Apr, 2018 at 11:04 AM

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 );

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article