K2 Oracle Service - Stored Procedures
For integration with stored procedures this service will cater for the following method types:
- Expose methods of type List where stored procedures return data
- Expose methods of type Execute where stored procedures return no data
 |
Important: Output and Read methods are unsupported. |
Fig. 1. Oracle Service Object Store Procedure Methods
Sample of a Stored Procedure
Simple Stored Procedure that INSERTS a record into a table called STUDENT.
 Copy Code |
|---|
|
CREATE OR REPLACE PROCEDURE sp_INSERT_STUDENT ( p_studentID IN STUDENT.STUDENT_ID, p_LastName IN STUDENT.LAST_NAME, p_ModifiedDate IN STUDENT.MODIFIED_DATE, p_ModifiedBy IN STUDENT.MODIFIED_BY, p_RegDate IN STUDENT.REGISTRATION_DATE, p_CreatedDate IN STUDENT.CREATED_DATE, p_CreatedBy IN STUDENT.CREATED_BY ) AS BEGIN
INSERT INTO STUDENT ( STUDENT_ID, LAST_NAME, MODIFIED_DATE, MODIFIED_BY, REGISTRATION_DATE, CREATED_DATE, CREATED_BY ) VALUES ( p_studentID, p_LastName, p_ModifiedDate, p_RegDate, p_CreatedDate, p_CreatedBy ); COMMIT ; END sp_INSERT_STUDENT ;
|
