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
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
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 126.96.36.199.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
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 …
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.
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 …
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
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.
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
I have confusion since I was looking inside and try to solve the problem. I have PHP application which is running in Oracle DB and so far some expression is written in MySQL and right now I want to migrate those query to Oracle SQL function and call function insted of writing query directly to model. The situation is following