I have a mystery, and I can't seem to find the answer in the docs,
atleast not quickly.
I have a perl program using the DBI (obviously) that produces a
very long sql, 116 words, 1225 characters (don't ask someone
else wrote the program and it was dropped in my lap).
When I connect to Oracle using the DBD, everything works just
fine, but when I connect through the Proxy Server, using dbi:proxy
I get this error:
Server returned error: Failed to execute method CallMethod:
DBD::Oracle::st execute failed: ORA-00933: SQL command not
properly ended (DBD ERROR: OCIStmtExecute)
Every other sql I throw at the proxy server has worked so far.
So, my question is, is there something in the dbi:proxy interface
which would trim long sql statements? Like a limit on sqls of
1k bytes?
Just wondering if anyone has a good idea of what might be wrong?
Douglas
--
-----------------------------------------------------------
Douglas A. Smith [EMAIL PROTECTED]
Office: Bld 40, Rm Y105 (650)926-2369
-----------------------------------------------------------
