Re: Need help with ORAtcl

In article <01bd9844$392a1820$496a0691_at_ksed24518.ksepl.shell.nl>, Justin Chaffey <j.t.chaffey_at_siep.shell.com> wrote:
>I am building a data link from an Oracle database to an application running
>on a PC (Win'95 and NT). Currently, I'm thinking about using ODBC to
>connect the two together but we have one problem - some of the data in the
>Oracle database is stored as binary blobs.
>
>I think I'll need to put in some code that translates the blobs before the
>PC application sees the data. However, there are several options for this
>- ASCII files, ODBC translators (i.e. Windows dll's), PL/SQL modules,
>Oracle views and, I think, 'ORAtcl'.
>
>Some of these I know about but I have never used ORAtcl. Hence, does
>anyone have any advice or experience in this area? Do you think it might
>work for blob data?

Oratcl does indeed read and write LONG and LONG RAW columns (BLOBs). The current interface reads and writes that BLOB data to files, in which you could then read with TCL or other external programs, and of course, Tcl 8.0+ can read files in pure binary. You are left with dealing with any data dependencies, such as byte ordering, etc.

-- 
Tom Poindexter                       Does any spammer really think that I'd
tpoindex_at_nyx.net                     buy something from them?
http://www.nyx.net/~tpoindex/