Archive for the 'Databases' Category

Pointless error message

Published on December 21, 2009 in Databases. 0 Comments Tags: , .

Just ran a bit of SQL on Oracle and this was the oh-so helpful error message I got back:

Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-00932: inconsistent datatypes: expected BINARY got BINARY

So you’re expecting a binary value and what you got was a binary value, but that’s inconsistent with the binary value you were expecting to be binary?!

Oracle extension oddity

Published on August 22, 2007 in Databases and PHP. 0 Comments

Today I was working on some sql for Oracle and connecting to the database with the PHP4 OCI extension. I’ve done this many times before, but today ran in to a little oddity that I thought was worth mentioning (mainly so I don’t forget and fall in to the trap again!)…

Continue reading ‘Oracle extension oddity’