Re: [Sqlrelay-discussion] Getting SQLRelay to play happily with Oracle 8i, CLOBs, and Perl DBI

[Chris F. <cfu...@gm...>]

Okay,

After looking through the source code and documentation, I've realized
that I'm probably going to have to hack in CLOB support for
bind_inout_param so I can get SQLRelay to support retrieval of oracle
CLOBs.

I'll also take a look at the OCI driver and see how that does it's thing.

Cheers!

On 8/4/05, Ionut Ciocirlan <ion...@av...> wrote:
> Oracle CLOBS are meant to be fetched using output binds, so what you're
> experiencing is not an SQL Relay issue, but an Oracle "feature".
>=20
> If you didn't experience this before, it might be because DBI probably do=
es
> its part of abstractization, parsing the query and rewriting it to fetch =
the
> CLOBS separately, then transparently delivering the full result set to th=
e
> client app.
>=20
> This is what one would expect when running such a query against a DBMS th=
at
> doesn't support CLOBS (or supports some sort of an unlimited TEXT data
> type) -- postgres, mysql etc., but no, not Oracle.
>=20
> If I'm right and DBI performs such query rewrites, then it should be able=
 to
> do that when using the Sql Relay driver too, so it's an implementation th=
at
> has to be done within this driver, to resemble the original OCI driver.
>=20
> Ionut
>=20


--=20
Chris Fuhrman
cfu...@gm...