Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug in DB/oci8.php ... oci_fetch_array called with wrong parameters #33

Open
jotazuz opened this issue Jan 24, 2024 · 3 comments
Open
Labels

Comments

@jotazuz
Copy link

jotazuz commented Jan 24, 2024

method fetchInfo (line 379 of oci8.php) doesn't work because it's calling oci_fetch_array with wrong parameters (is using the same parameters for the deprecated function OciFetchInto)

@schengawegga schengawegga added this to the Version 1.12.2 milestone Jan 25, 2024
@ashnazg ashnazg mentioned this issue Jan 28, 2024
@schengawegga
Copy link
Collaborator

schengawegga commented Apr 7, 2024

@jotazuz I will release the bugfix soon. Thank you for your hint.
Otherwise i think i found another bug in the connection function at the DSN.
Can you tell me, how do you call the connect function?
Do you connect via an dsn-string or via the connection ds paramter-array, like
$dsn['phptype'] = "oci8"; $dsn['hostspec'] = "localhost"; $dsn['database'] = "XEPDB1"; $dsn['port'] = 1521; $dsn['username'] = "SYSTEM"; $dsn['password'] = "MySystemPassword";
?

schengawegga added a commit that referenced this issue Apr 15, 2024
* fix fetch args

* fix fetch args #34
"Argument #1 ($value) must be of type Countable|array, bool given" at the end of the query

---------

Co-authored-by: Schengawegga <schengawegga@gmail.com>
@schengawegga schengawegga reopened this Apr 15, 2024
@schengawegga
Copy link
Collaborator

@jotazuz did you read my last comment? can you give me a quick response, please?

@jotazuz
Copy link
Author

jotazuz commented Apr 16, 2024

@schengawegga sorry, didn't get your last post. I connect via dsn string, something like this:

oci8://user:pass@(DESCRIPTION = (CONNECT_TIMEOUT=1)(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx)(PORT = 11521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = xxxx)(FAILOVER_MODE = (TYPE = SELECT)(ME
THOD = BASIC)(RETRIES = 2)(DELAY = 2))))/database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants