advance on inserting CLOB to XMLTYPE?
Well I have been hacking this one to death this weekend. Did manage to
get
it to work using a SP that creats a lob pointer before we do the update
but
this is a very bad hack on my part. I think this will require lob
locators
as the function
and had the same limit.
-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 8:25 PM
To: Garrett, Philip (MAN-Corporate)
Cc: Reidy, Ron; dbi-users@perl.org
Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?
Thanks Philip
the same limit.
-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 8:25 PM
To: Garrett, Philip (MAN-Corporate)
Cc: Reidy, Ron; dbi-users@perl.org
Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?
Thanks Philip
.
-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 8:25 PM
To: Garrett, Philip (MAN-Corporate)
Cc: Reidy, Ron; dbi-users@perl.org
Subject: Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?
Thanks Philip for the extra info.
I've attached a test
I ran this against v1.19 and had the same limit.
-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 8:25 PM
To: Garrett, Philip (MAN-Corporate)
Cc: Reidy, Ron; dbi-users@perl.org
Subject: Re: :Oracle - Any advance on inserting CLOB
Thanks Philip for the extra info.
I've attached a test case I'm working with .. wondering if anyone
using DBD 1.19 can try this out too and report the results?
Ron, can you check this also ... maybe your code is different in some way?
For me the limit is at 63/64 elements (results are in the
something didn't like me attaching the .pl file, so resending with a
link instead.
You can find the testcase at:
http://paulg.homelinux.com:8000/sources/xmltypeinsert-testcase.pl
On 2/17/07, Paul Gallagher [EMAIL PROTECTED] wrote:
Thanks Philip for the extra info.
I've attached a test case
Thanks Philip for the extra info.
I've posted a test case I'm working with at
http://paulg.homelinux.com:8000/sources/xmltypeinsert-testcase.pl ..
wondering if anyone using DBD 1.19 can try this out too and report the
results?
Ron, can you check this also ... maybe your code is different in
I can confirm I have the same problems as Paul when inserting large
XMLType.
Running on:
1. SUSE LINUX Enterprise Server 9 (i586)
2. DBI v1.50
3. DBD::Oracle v1.18
4. Oracle client: 9.2.0.4.0
5. Oracle server: 9.2.0.7.0 - 64bit
Regards,
Philip
Paul Gallagher wrote:
Thanks for the info
Well, it works for me out of the box as advertised.
Code snippet:
my $sth_admin_audit_files = $dbh-prepare(qq{
INSERT INTO array_audit.admin_audit_files
(instance_id
,file_crdt
,fname
,file_header
,file_header_raw
)
VALUES
(:instance_id
10 matches
Mail list logo