K2 BLACKPEARL PRODUCT DOCUMENTATION: USER GUIDE
Oracle Stored Procedures

K2 Oracle Service - Stored Procedures

For integration with stored procedures this service will cater for the following method types:

  1. Expose methods of type List where stored procedures return data
  2. 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 ;

 

 

 


K2 blackpearl Help 4.6.10 (4.12060.1690.0)