On Monday 23 Aug 2004 17:11 pm, you said:
> Send me a patch to t/31lob.t that tests the functionality you want
> and I'll try to sort it out for you.
What would be the best way of including a large text string here ? Just inline
would make it very messy...
As far as I can see, there is no test for inserting into XMLtype() at all, and
in any case I'm not sure weather the intended functionality would be support
xmltype() cast in the select statement, or have DBD::Oracle notice it was an
insert into an xmltype column and use CLOB rather than LONG.
Thoughts ?
FYI the extra steps would be:
$dbh->do(qq{
CREATE TABLE $table_2 (
id INTEGER NOT NULL,
data xmltype
)
});
$stmt = "INSERT INTO $table (id,date) VALUES (1, xmltype(?))";
// or $stmt = "INSERT INTO $table (id,date) VALUES (1, ?)"; ???
$sth = $dbh->prepare($stmt);
$sth->execute($6k_of_xml);
//this will fail with an error about LONG insert, currently...
$dbh->do("DROP TABLE $table_2");
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
