Tag Archives: Oracle

05Mar/14

ORA-01745: Invalid host/bind variable name error

March 5, 2014Databases, OracleDatabase, OracleMichael

I had a simple query where I was pulling data on a user, but binding with :user, as in select * from user_table u join other_table o on u.user_id = o.user_id whereRead More…

07Jan/14

OCI_NO_AUTO_COMMIT: Oracle OCI and PHP

January 7, 2014Databases, Oracle, PHP, ProgrammingOCI, Oracle, PHPMichael

So today I did something fun. I wrote a script to parse out data from a CSV file and push the various data into several different (and mostly unrelated) tables in theRead More…

02Aug/13

Converting Oracle (OCI) Results to JSON with PHP

August 2, 2013Databases, MySQL, Oracle, PHP, ProgrammingOCI, Oracle, PDO, PHPMichael

I normally use the PHP PDO to retrieve data from a MySQL database, and then convert the data to JSON after calling $statement->fetchAll(PDO::FETCH_ASSOC). This has worked well for me, and each rowRead More…