Welcome Guest, Not a member yet? Register   Sign In
Oracle OCI8 support for CI 4
#11

(This post was last modified: 11-29-2021, 07:54 AM by rocksvern.)

(11-23-2021, 09:07 AM)gurthang75 Wrote: HI again!
im having troubles with package/procedures executions when i got OUT variables in my package i dont know how to retrieve the returning OUT variable value.
Can someone gide me a bit? im foing this:
Code:
function addSection($parent_section, $sec_code, $sec_long){
        $params[0] = array('name' => ':P_PARENT_SEC', 'value' => $parent_section);
        $params[1] = array('name' => ':P_CODE', 'value' => $sec_code);
        $params[2] = array('name' => ':P_LONG', 'value' => $sec_long);
        $params[3] = array('name' => ':P_OPER', 'value' => 'add');
        $params[4] = array('name' => ':P_RESULT', 'value' => null, 'length' => 4000);
        $params[5] = array('name' => ':P_ERROR', 'value' => null, 'length' => 4000);
        $params[6] = array('name' => ':P_ERROR_ORA', 'value' => null, 'length' => 4000);

        $query = $this->db->storedProcedure('PAC_WIKI', 'WIKI_SECTION', $params);
        print_r($query);

        die();
        if ($this->db->transStatus() === false) {
            return $query;
        } else {
            return $query;
        }
    }

and that "print_r()" give me this array:
Code:
CodeIgniter\Database\OCI8\Result Object ( [connID] => Resource id #12 [resultID] => Resource id #13 [resultArray] => Array ( ) [resultObject] => Array ( ) [customResultObject] => Array ( ) [currentRow] => 0 [numRows:protected] => [rowData] => )


thks in advance!


Try put a variable by reference like this
Code:
'value' => &$resultVariable
Reply


Messages In This Thread
Oracle OCI8 support for CI 4 - by ajk - 05-07-2020, 04:03 PM
RE: Oracle OCI8 support for CI 4 - by kilishan - 05-07-2020, 09:03 PM
RE: Oracle OCI8 support for CI 4 - by ajk - 04-15-2021, 11:57 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 10-13-2021, 12:11 AM
RE: Oracle OCI8 support for CI 4 - by b126 - 10-30-2021, 01:28 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 10-25-2021, 01:08 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 10-30-2021, 04:16 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 10-26-2021, 01:44 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 11-23-2021, 09:07 AM
RE: Oracle OCI8 support for CI 4 - by rocksvern - 11-29-2021, 07:51 AM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 12-09-2021, 05:24 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-28-2021, 06:16 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-30-2021, 01:01 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 12-29-2021, 02:48 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 01-25-2022, 04:54 PM
RE: Oracle OCI8 support for CI 4 - by b126 - 02-11-2022, 06:05 PM



Theme © iAndrew 2016 - Forum software by © MyBB