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

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

Howdy,

Trying to get SQLrelay to work with an Oracle 8i (8.1.7) database and
am having an issue pulling Oracle CLOBs.  Here's the environment
Specifics:

Data Base Server: Solaris 8 x86 running Oracle 8i (8.1.7)
SQL-Relay Server: Redhat Linux 9 running SQL-Relay 0.36.4
Application Server: Solaris 9 x86 w/ perl 5.8.0

I'm trying to pull from this table:

 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------=
-----
 SES_ID                                    NOT NULL VARCHAR2(64)
 USR_ID                                             NUMBER(12)
 CLI_ID                                             NUMBER(12)
 AUTH_LEVEL                                         NUMBER(12)
 IP_ADDR                                            VARCHAR2(32)
 DATA                                               CLOB
 DATA_SIZE                                          NUMBER(12)
 STATUS                                    NOT NULL NUMBER(2)
 CTIME                                     NOT NULL DATE
 MTIME                                     NOT NULL DATE
 SECURITY                                           NUMBER(20)

As you may notice, the DATA column is a CLOB.

I've found SQL-Relay's debugging feature and tried to see what was going on=
:

08/04/2005 13:43:39 EDT connection [6005] :             fetching 100 rows..=
.

08/04/2005 13:43:39 EDT connection [6005] :                   =20
"81","2004/11/09 00:00:00","^E^F^C


And here is the SQL that was run:

  SELECT auth_level, cli_id, TO_CHAR( ctime, 'YYYY/MM/DD HH24:MI:SS'
), data, ip_addr, TO_CHAR( mtime, 'YYYY/MM/DD HH24:MI:SS' ), security,
ses_id, data_size, status, usr_id FROM ucs3_user.sess WHERE status IN
( ?, ? ) AND ses_id =3D ?
Bind values:
  [0] 0
  [1] 1
  [2] 724a33a8a67d7a7cdd0951995cb1b5bc1792a2b0

Yet I seem to be getting garbage back.  If anyone has any experience
getting SQL-relay to properly digest Oracle CLOBs or if you require
additional information, let me know.

Cheers!

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