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 :-)
>
>actua
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
:)
-
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
...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.
>
--
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
Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
I had emailed Becka yesterday to try the new versions.
ething obvious!
> Perl version: 5.005
> Oracle version: 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 PRO
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
D]>
>CC: [EMAIL PROTECTED], [EMAIL 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 "Inse
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:0
- 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
>
did give that a try, before. Unfortunately, I get the same error.
>
>
> >From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> >To: 'Becka Louden ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
> ><[EMAIL PROTECTED]>
> >S
> 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 = $inser
I did give that a try, before. Unfortunately, I get the same error.
>From: "Sterin, Ilya" <[EMAIL PROTECTED]>
>To: 'Becka Louden ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
><[EMAIL PROTECTED]>
>Subject: RE: inserti
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."
15 matches
Mail list logo
