i’m trying to convert a date like 2022-08-09 to a julian date for send it to JDE. The problem is that default php functions like juliantojd() return a different result. The result i expected was something like this https://nimishprabhu.com/tools/jde-julian-date-converter-online.html I got this function from a very old code that is doing the job in .asp I’m trying to convert this
Tag: oracle
oci_execute(): ORA-06550: PLS-00306: wrong number or types of arguments in call to ‘GET_CITIZEN_INFO’
My PHP code: My procedure Error I am proving correct number of argument so what seems to be wrong here? Answer You are providing the correct number of arguments, but not necessarily the correct type of arguments. You might need to specify at least the first and last parameter types: docs
Why is cx_Oracle performing better than PHP OCI8?
I am trying to determine why a query that returns CLOB data runs so much faster using python3 and cx_Oracle in comparison to PHP 7.4 with OCI8. Oracle Client Libraries version is 19.5.0.0.0. Queries are ran on the same client and against the same database using the same user. See below for the test PHP and Python scripts. The PHP
Upload files to oracle cloud storage using PHP
I am looking in docs and Oracle sdk to see if there’s anything we can upload to oracle storage. But i didn’t found any php sdk from Oracle or am i missing something? I have researched a lot, please …
Values are not getting matched while using php with oracle
So i have just started working on PHP with Oracle and I am getting values from user using select option as you can see in HTML file, however when i apply where condition on ‘Job’, it wouldn’t match the values. I have also used ‘upper’ with where condition to avoid case-sensitivity but it wouldn’t work. On the contrary when i
How do I update CLOB column on oracle with PHP
I have problem with function: After execute I get “Updated” but in database column is empty. Before execute i have null on this column. Answer Here are two ways. The schema is: And the code would be like: You may want to look at the second half of Oracle’s free PHP book The Underground PHP and Oracle Manual.
Get connection handle details of Oracle resource handle in PHP for debugging validity of connection
Scenario I use a function, namely oci_connect, to connect to an Oracle database. Outputting oci_num_rows($handle) displays 0, which does not correspond to another page output that displays a value …
Understand and convert query to Oracle SQL
I am a little bit confusing and I am totally nOoB in PHP and I stuck in one query which made me problem. If I would like transform this to Oracle SQL Is is something like this Answer Check the following: It should produce an SQL query as follow, which will put the mark 2 if the student status equals
How to make Oracle keep the case of identifiers as they appear in the query?
I want to use a php library that uses PDO. And I want to use an Oracle database with it. The problem is that authors of that library use unquoted identifiers in their queries, e.g.: In this case, Oracle converts the case of identifiers to UPPER, but authors assume the case is lower, therefore an undefined index php error occurs.
ON DUPLICATE KEY UPDATE in oracle or equiv (defining key/column?)
I have the below working insert statement, where I am essentially mapping the column data from an uploaded .csv file through a loop into my VALUES variables below… All worked fine, except now I am just trying to add a tweak INSERT or UPDATE – if ‘app_id’ first column, value is found in the uploaded .csv, i.e. duplicate is found