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

Hi! im testing the oralce driver and i got some bugs in it.. ill listing over here:
1) storeProcedures are not working correctly im doing something like this:
PHP Code:
$query $db->storedProcedure('PAC_WIKI''INSERT_DOCUMENT'$params);
return 
$query

and get the next error:
oci_parse() expects parameter 1 to be resource, bool given
SYSTEMPATH\Database\OCI8\Connection.php at line 507
Code:
500             if (isset($param['type']) && $param['type'] === OCI_B_CURSOR) {
501                 $haveCursor = true;
502             }
503         }
504         $sql = trim($sql, ',') . '); END;';
505         
506         $this->resetStmtId = false;
507         $this->stmtId      = oci_parse($this->connID, $sql);


its seems like $this->connID is not retrivieng the connection
2) this storeProcedure will work with procedures in packages but it will not work (i think) with procedures alone without a package
Code:
public function storedProcedure(string $package, string $procedure, array $params)
    {
        if ($package === '' || $procedure === '') {
            throw new DatabaseException(lang('Database.invalidArgument', [$package . $procedure]));
        }

        // Build the query string
        $sql = 'BEGIN ' . $package . '.' . $procedure . '(';

Last but not least.... i dont know if this is the correct place to show bugs or anything...
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
RE: Oracle OCI8 support for CI 4 - by kenjis - 06-08-2022, 05:23 PM
RE: Oracle OCI8 support for CI 4 - by b126 - 02-21-2023, 09:32 AM
RE: Oracle OCI8 support for CI 4 - by luckmoshy - 06-08-2022, 11:33 PM
RE: Oracle OCI8 support for CI 4 - by nilo - 11-29-2023, 04:33 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-29-2023, 04:47 PM
RE: Oracle OCI8 support for CI 4 - by nilo - 12-04-2023, 01:18 AM



Theme © iAndrew 2016 - Forum software by © MyBB