Welcome Guest, Not a member yet? Register   Sign In
Execute Oracle procedure with one OUT parameter
#1
Question 

I am able to execute stored procedure in CI with IN params.
But Having problems using a procedure with one or more OUT params in oracle.

Example:

CREATE OR REPLACE PROCEDURE Sample (id IN NUMBERtitle IN VARCHAR2status_code OUT VARCHAR2 )
AS
   lv_status_code VARCHAR2 (500);
BEGIN
    lv_status_code :=
      'SUCCESS'
      || '|~|'
      || id
      || '|~|'
      || title;
   status_code := lv_status_code;
END;


Kindly let me know how i can execute this from codeigniter and to read output value.
Reply


Messages In This Thread
Execute Oracle procedure with one OUT parameter - by zashishz - 05-15-2017, 10:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB