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…

December 2019
S	M	T	W	T	F	S
« Nov
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31