In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Wolfgang Weisselberg) wrote:
Hi, I am new to this newsgroup, so I hope this is not a bad question.
It's a good question, but I thought it was a mailing list :-)
actually it's both..
On Thu, Nov 15, 2001 at 21:00:16 +, Becka Louden wrote:
Hi, I am new to this newsgroup, so I hope this is not a bad question.
It's a good question, but I thought it was a mailing list :-)
I trying to use the Perl::DBI to insert a string value into the Oracle
database. However, I get
: 8.0.4.3.2
DBI: 1.13.1
DBD::Oracle: 1.03
I really appreciate your help.
Becka
From: Hardy Merrill [EMAIL PROTECTED]
To: Becka Louden [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: inserting into CLOB field
Date: Thu, 15 Nov 2001 16:56:45 -0500
Maybe I'm missing
Your DBD::Oracle is built using the Oracle7 OCI API, it doesn't
know about LOBS.
Tim.
On Thu, Nov 15, 2001 at 09:00:16PM +, Becka Louden wrote:
Hi, I am new to this newsgroup, so I hope this is not a bad question.
I trying to use the Perl::DBI to insert a string value into the Oracle
...or I could be wrong :-)
Your DBD::Oracle is built using the Oracle7 OCI API, it doesn't
know about LOBS.
Tim.
On 16-Nov-01 Scott T. Hildreth wrote:
Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
I had emailed Becka yesterday to try the new versions.
Many thanks to Tim, Scott, and everyone else on the mailing list for helping
me with this!! Figuring this out really made my day.
Becka
From: Tim Bunce [EMAIL PROTECTED]
To: Becka Louden [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: inserting into CLOB field
Date: Fri, 16 Nov 2001 14
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Wolfgang Weisselberg) wrote:
Hi, I am new to this newsgroup, so I hope this is not a bad question.
It's a good question, but I thought it was a mailing list :-)
actually it's both.. point your news reader at nntp://nntp.perl.org
:)
--
Hi, I am new to this newsgroup, so I hope this is not a bad question.
I trying to use the Perl::DBI to insert a string value into the Oracle
database. However, I get this error : ORA-01461: can bind a LONG value
only for insert into a LONG column (DBD: oexec error) at query_crr.pl line
98.
use strict; use DBI; use DBD::Oracle qw(:ora_types);
$insert_cr-bind_param(1, $cr, {ora_type = ORA_CLOB});
Not that I'm doubting you, but I had the same error and I found
that the above bind works for me. Can you send a Trace use level 9.
my $result_ins = $insert_cr
], '[EMAIL PROTECTED] '
[EMAIL PROTECTED]
Subject: RE: inserting into CLOB field
Date: Thu, 15 Nov 2001 14:07:40 -0700
How about
$insert_cr-bind_param(1, $cr);
Ilya
-Original Message-
From: Becka Louden
To: [EMAIL PROTECTED]
Sent: 11/15/01 2:00 PM
Subject: inserting
- Original Message -
From: Becka Louden [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 10:00 PM
Subject: inserting into CLOB field
[...]
my $result_ins = $insert_cr -execute() || print Insert into CRR table
failed!!\n;
try this:
bind_param(1, $cr
Good idea.. tried it, though, only to get the same error message.
Becka
From: M.W. Koskamp [EMAIL PROTECTED]
To: Becka Louden [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: inserting into CLOB field
Date: Thu, 15 Nov 2001 23:06:56 +0100
- Original Message -
From: Becka Louden
PROTECTED]
Subject: Re: inserting into CLOB field
Date: Thu, 15 Nov 2001 16:56:45 -0500
Maybe I'm missing something - this seems too easy, but in your
statement:
my $result_ins = $insert_cr -execute() || print Insert into CRR table
failed!!\n;
you have a space before the -execute() - try
13 matches
Mail list logo