Dear listers,
I am trying to copy an updated CLOB from a table in one database (let's call
it A) to the equivalent table in another database (called B just to be
original). I have written triggers and procedures to do this (one package
on each database), and I am passing the contents of the CLOB to the remote
update procedure as VARCHAR fields in a PL/SQL table.
Everything works perfectly well when I run an update against table A. I am
connecting via TOAD and am logged on to Oracle as the schema owner. The
contents of the CLOB are retrieved, passed across and used to update the
remote table.
When the client updates the CLOB in table A, however, the select statement
in my package on database A which 'locates' the CLOB, retrieves a CLOB of
zero length. No exception occurs in the Select statement. The client's
update succeeds on table A, and my package sends an empty PL/SQL table to
the remote procedure (and the CLOB on the remote table is duly erased). The
client is connecting through an ASP-driven web interface via IIS, which as
far as I can tell is also logging on to Oracle as the schema owner.
Anyone encountered this sort of behaviour before? I've just about run out
of ideas. If I can't solve this by direct means I can probably do something
kludgy like launch the remote update as a background process via
DBMS_JOB.SUBMIT, but I'd far rather have it under transactional control.
Oracle version is 8.1.6.3 on both databases.
Can supply contents of triggers etc. if needed.
Cheers,
James Campbell
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Campbell, James
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
