No answers here - we used dbiproxy for quite a while and I
never saw that error before, though we never generated SQL
strings as long as yours.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Douglas Smith [[EMAIL PROTECTED]] wrote:
>
> 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
> -----------------------------------------------------------
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
