summaryrefslogtreecommitdiff
path: root/drivers/adodb-oci8.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2024-05-26oci8: fix warning in qStr() with NULL on PHP 8.1Damien Regad1-5/+2
This is a follow-up commit on 1501ccd07868d626a51802d14ed41ed05a3532ad, as the original fix for #999 (see PR #1005) did not fully address the problem. Another PHP deprecated warning is thrown: strlen(): Passing null to parameter 1 ($string) of type string is deprecated. Fixes #1012 Backported from commit 8d88183538ae08b86c30af5b0f3280c2accd71c3.
2023-11-04oci8: Fix Automatic conversion of false to arrayDamien Regad1-1/+1
On PHP 8.1, when the _query() method is called, the oci8 driver throws Automatic conversion of false to array is deprecated. Fixes #998
2023-11-01Prevent str_replace NULL test error in PHP 8.1 (#1005)Mark Newnham1-0/+3
2023-07-25Remove unnecessary is_array() checkDamien Regad1-23/+22
2023-07-25oci8: deprecation warning in selecLimit() on PHP 8.1wesyah2341-4/+5
'Automatic conversion of false to array is deprecated' warning is triggered when $inputarr parameter is not provided (defaulted to false). Fixes #992
2023-04-30Define ADOConnection::_query() methodDamien Regad1-1/+7
- Update child classes to be consistent with this declaration. - Remove unnecessary, non-PHPDoc comments - Consistent parameter names Fixes #966
2023-04-30PHPDoc: fix ADOConnection::execute() return typeDamien Regad1-10/+0
Remove redundant PHPDoc block in child classes ADODB_mysqli, ADODB_oci8. Fixes #964
2023-03-17oci8: remove usage of undefined $seqField propertyDamien Regad1-4/+0
This fixes PHP 8.2 deprecation notice. Fixes #933
2023-03-17Replace obsolete function aliasDamien Regad1-1/+2
oci_free_cursor() alias was deprecated in PHP 5.4 and replaced by oci_free_statement() [1]. Fixes #937 [1]: https://www.php.net/manual/en/function.ocifreecursor.php
2023-03-17Fix PHP 8.2 dynamic properties deprecation warningsDamien Regad1-0/+3
- ADOConnection: add $_metars, $locale, $metaColumnsSQL, $identitySQL, $_genSeqSQL, $_dropSeqSQL and $_genIDSQL; add PHPDoc to $metaDatabasesSQL $metaTablesSQL - Exceptions: add $msg property - DB2: reference parent connection object and fix $_queryID case - Informix: don't cache version info in SetVersion - odbtp: define $odbc_name, $_canSelectDb, $_lastAffectedRows properties NOTE: this is somewhat academical as the driver is obsolete - oci8: define $_refcursor property - sybase: use existing $hasTransactions property instead of $_hastrans - text: rename unused ADOConnection::$_evalAll property to $evalAll - perf: define $settings property - xml: add properties dbTable::$currentPlatform, dbTable::$data, dbData::$current_field, adoSchema:$obj This is adapted from changes proposed in #926
2022-03-29oci8: fix PHP 8.1 array deprecation warningMark Newnham1-0/+5
Stop PHP 8.1 issuing deprecation warnings in selectLimit() method. Fixes #817
2022-01-16Fix reported errors in generated documentationDamien Regad1-7/+10
2022-01-16Add ADOConnection::releaseStatement() methodDamien Regad1-0/+16
This allows Oracle users to avoid reaching the maximum open cursors limit by releasing the statement resource allocated by oci_parse(), and prevent occurrence of an ORA-01000 error. The resource is cleared (set to null) after freeing statement, to avoid keeping a resource of type Unknown in the statement. Fixes #770
2021-11-07Uniformize metaForeignKeys() function signatureDamien Regad1-7/+8
- public visibility - camelCase - change $owner default from false to '' - add $associative param where missing - PHPDoc updates
2021-11-07WhitespaceDamien Regad1-2/+2
2021-08-17Redo Merge branch 'hotfix/5.21' Standardized file headersDamien Regad1-16/+21
Try to do it right this time... # Conflicts: # adodb-memcache.lib.inc.php Fixes #751
2021-08-17Reset version to avoid merge conflictsDamien Regad1-1/+1
Fixes #751
2021-08-17Revert changes since Standardized file headers mergeDamien Regad1-22/+22
The conflicts resolution applied when merging the Standardized file headers (commit e9dcce3df24912ad869d0193f0b419f2309101fc) was seriously messed up, actually overwriting a number of changes in the master branch. Rather than trying to go and fix things one by one which has a high risk of messing things further, it's easier to redo the merge from a clean slate, so this commit reverts the following: - "Merge branch 'hotfix/5.21' Standardized file headers", e9dcce3df24912ad869d0193f0b419f2309101fc - "Merge tag 'v5.21.1'", 5f437df3104159d5d659f60e31bef8d33c34995f - "Reset version to 5.22.0-dev" af9234a525c3255af051a330164486d73be4c63a - "Fix incorrect resolution of merge conflicts" a6733f61b0165b366c8d2c70d9af82edc3881951. - "Fix syntax error in toexport.inc.php" 20b01e83cb61b6b2460f64c7d1277c5f4cc28574. Fixes #751
2021-08-14Standard file header: /driversDamien Regad1-16/+21
2021-04-11WhitespaceDamien Regad1-11/+11
2021-04-11Add stub for ADOConnection::_insertID()Damien Regad1-11/+10
Update child classes so method signature matches the parent's.
2021-03-08Bump version to 5.21.1-devDamien Regad1-1/+1
2021-02-27Bump version to 5.21.0v5.21.0Damien Regad1-1/+1
2021-02-02Bump version to 5.21.0-rc.1v5.21.0-rc.1Damien Regad1-1/+1
2021-01-25Remove all magic quotes related codeDamien Regad1-24/+14
The $magic_quote parameter for public methods was kept for backwards compatibility purposes, but is no longer used. Fixes #674
2020-12-20Bump version to 5.21.0-beta.1v5.21.0-beta.1Damien Regad1-1/+1
2020-12-19adodb.org is now served over SSLDamien Regad1-1/+1
Change web site references from http://adodb.org to https.
2020-12-06Removed references to phplens.com, see #564Mark Newnham1-2/+2
2020-01-24Removed unused var $_hasOciFetchStatementDamien Regad1-1/+0
2020-01-24Remove useless ADODB_oci8 constructorDamien Regad1-7/+0
2020-01-24removed PHP4 dependency testsMark Newnham1-7/+7
2020-01-12oci8: create compact trigger/sequence namesMark Newnham1-0/+54
This enhancement provides a method of creating an emulated auto- increment column for a table with a name greater than 25 characters, built using createTableSql() and specifying an "AUTO" option on the required column. Instead of using the table name, a CRC32 value of the tablename is created and used for the name of the sequence and trigger, i.e. instead of a trigger called "TRIG_EMPLOYEES" for a table called "EMPLOYEES", it creates a trigger "TRIG_3129131776", and similarly, a trigger for a table named "EMPLOYEE_HOURLY_PAY_RATES" becomes "TRIG_3754194288". The name of the trigger and sequence can be easily obtained after the fact by finding the CRC32 value of the table name. The feature is provided with a compatibility flag that must be enabled. Existing configurations that already use this feature are unchanged. To activate, set the dictionary class variable `$dict->useCompactAutoIncrements = true` when building the table, and the connection class variable `$db->useCompactAutoIncrements = true` when using the table in ADOdb. The feature is global for the database and cannot be specified on a table level basis. Fixes #565
2018-08-06Merge branch 'hotfix/5.20' (v5.20.13)Damien Regad1-1/+1
# Conflicts: # adodb-time.inc.php # docs/changelog.md # drivers/adodb-mssql.inc.php # drivers/adodb-mssqlnative.inc.php # drivers/adodb-oci8po.inc.php
2018-08-06Reset version to avoid merge conflictsDamien Regad1-1/+1
2018-08-06Bump version to 5.20.13v5.20.13Damien Regad1-1/+1
2018-08-06Replace adodb.sourceforge.net URLs by adodb.orgDamien Regad1-1/+1
2018-07-20Fix #143 causes problems with prepared statements in driver, see #318Mark Newnham1-1/+7
The addition of the close method in the destructor of the core ADOrecordset class causes prepared statements to fail because the connection to the resource is closed too early. This fix overrides the destructor for the oracle driver which is the only one with reported issues.
2018-07-20Fix #143 causes problems with prepared statements in driver, see #318Mark Newnham1-1/+7
The addition of the close method in the destructor of the core ADOrecordset class causes prepared statements to fail because the connection to the resource is closed too early. This fix overrides the destructor for the oracle driver which is the only one with reported issues.
2018-03-30Bump version to 5.20.12v5.20.12Damien Regad1-1/+1
2018-03-30Merge branch 'hotfix/5.20'Damien Regad1-0/+2
I messed up the merge at c350c007ed585a4da4dc8c62ae7954cfe13b621f. Not sure what I did or how, but the changes from the hotfix branch got lost. Redoing the merge to fix the problem.
2018-03-30Bump version to 5.20.11v5.20.11Damien Regad1-1/+1
2018-03-30Fix potential SQL injection in SelectLimit()Dave Paul1-0/+2
The `SelectLimit` function has a potential SQL injection vulnerability through the use of the `nrows` and `offset` parameters which are not forced to integers. This is a follow-up on #311, and fixes all remaining drivers that do not use ADOConnection::SelectLimit(). Fixes #401 Signed-off-by: Damien Regad <dregad@mantisbt.org> Original commits squashed, message reworded. Fixed whitespace.
2018-03-08Bump version to 5.20.10v5.20.10Damien Regad1-1/+1
2016-12-21Bump version to 5.20.9v5.20.9Damien Regad1-1/+1
2016-12-17Merge branch 'hotfix/5.20.8'Damien Regad1-26/+30
Conflicts: drivers/adodb-mssqlnative.inc.php
2016-12-17Reset version to avoid merge conflictsDamien Regad1-1/+1
2016-12-17Bump version to 5.20.8v5.20.8Damien Regad1-1/+1
2016-12-17oci8po: fix SelectLimit() with prepared statementsDamien Regad1-23/+21
The ADOdb_oci8::SelectLimit() method performs Oracle-specific query optimization, manipulating the SQL to apply hints in a way that is not compatible with the oci8po driver, due to conversion of query parameters ('?' vs oci8 native ':xx'). To avoid the problem, we define the SelectLimit() method directly in ADODB_oci8po, and rely on the slower ADOConnection::SelectLimit() method from the base class. Also, to avoid issues with prepared statements causing PHP to throw a Warning: "oci_execute(): supplied resource is not a valid oci8 statement resource", we retrieve the prepared statement's SQL and pass it on to ADOConnection::SelectLimit(). Fixes #282
2016-11-19oci8po: fix inconsistent variable binding in SelectLimit()Pat Bateman1-3/+9
Allow indexed or associative array for bindvars. Fixes #288 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2016-10-11Remove references to ADOdb ExtensionDamien Regad1-3/+0
The ADOdb Extension's development stopped at version 5.04. It is no longer maintained or supported, yet the library still contains code referencing it. If those code branches are executed, ADOdb will not perform properly, due to missing constant declarations (among other things). This commit removes all references to the Extension. Fixes #270, #269