[Sqlrelay-discussion] ORA-01480 with long CLOBs?

[Alexander K. <ak-...@cy...>]

Hi,

I am one of the core developers of the OpenXPKI project - an open source
certificate authority written in Perl and I was looking into sqlrelay as
a way to reduce the number of database connections we currently open
(but do not actively use at the same time).

We are using Oracle at a customer here and as a quick test I've
replaced the connection string to use SQLRelay instead of Oracle.

Unfortunately, now I run into the following problem:
ORA-01480: trailing null missing from STR bind value;
while doing the following query:
insert into L2CA1.config (config_identifier, data) VALUE (?, ?)
The config table consists of a data CLOB, and the bind value is
a few kilobytes big. Googling for the Oracle error shows that it
apparently looks for the \0 delimiter in the first few hundred(?)
characters only.

I assume the DBD::Oracle module enlarges this value and DBD::SQLRelay
doesn't - could this be the reason for my error?

Any help highly appreciated ...
Best regards,
  Alex
-- 
Dipl.-Math. Alexander Klink | IT-Security Engineer
        ak-...@cy... | working @ urn:oid:1.3.6.1.4.1.11417