Management and Administration > Workspace Management > Management Console > SmartObject Services > SmartObject Services > The K2 Oracle Service > Oracle Stored Procedures | Send feedback |
For integration with stored procedures this service will cater for the following method types:
Important: Output and Read methods are unsupported. |
Fig. 1. Oracle Service Object Store Procedure Methods
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 ;
|