I was about to upgrade our installation when I noticed this in the changelog.
Tim Bunce <[EMAIL PROTECTED]> writes:
> Changes in DBD::Oracle 1.09 27th August 2001
>
> Changed behaviour when OCIStmtExecute() returns OCI_SUCCESS_WITH_INFO:
> used to be treated as OCI_SUCCESS, now also se
Hi,
I'm trying to insert JPGs into a db/2 database. Here's the perl code
I'm using to accomplish this:
#Open the table, and tell the client to insert a JPG file into the DB.
$sth = $dbh->prepare( "INSERT INTO T301DBA.NPAUX2 (AUXID, AUXVER,
AUXVALUE) VALUES ('1' 1 ?)" );
$sth->bind_param( 1, '
Hi,
Sorry to bother u guys, but can one of u please suggest an appropriate
mailing list for file/directory manipulation in perl.
Thanks
Simon
p.s. if anyone is interested it is: how do i get a perl program to execute
in all subdirectores of a top level drive, i.e. i want to execute a .pl
But you must understand that this is not a DBI nor a DBD::Oracle problem,
but rather passing a query that is parsed by you DB engine which throws the
error. Look into your Oracle configurations, etc...
Ilya
-Original Message-
From: Wojciech Pietron
To: Peter J . Holzer
Cc: [EMAIL PROTEC
First of all you can set LongReadLen to the bigest size a BLOB will except
and it will only fetch the right amount.
In your case, it's probably best to use blob_read method to fetch in chunks.
See Readme.longs in DBD::Oracle package for examples.
Ilya
-Original Message-
From: Adam Kenne
Peter J . Holzer <[EMAIL PROTECTED]> [010921 16:31]:
> On 2001-09-21 16:06:22 +0200, Wojciech Pietron wrote:
> > I still don't know if it was bug#1112313 but when I changed (a piece
> > of Perl source code):
> >
> > qq| insert [...] to_date(sysdate, '-MM-DD HH24:MI:SS') [...]|;
> >
>
On 2001-09-21 16:06:22 +0200, Wojciech Pietron wrote:
> I still don't know if it was bug#1112313 but when I changed (a piece
> of Perl source code):
>
> [...] to_date(sysdate, '-MM-DD HH24:MI:SS')
>
> to:
> my $time = qx|date +"%Y-%m-%e %T"|;
> [...] to_date($time, '
Hi,
I still don't know if it was bug#1112313 but when I changed (a piece
of Perl source code):
[...] to_date(sysdate, '-MM-DD HH24:MI:SS')
to:
my $time = qx|date +"%Y-%m-%e %T"|;
[...] to_date($time, '-MM-DD HH24:MI:SS')
everything went OK. It looks like it wa
On 2001-09-21 12:30:07 +1000, Adam Kennedy wrote:
> BTW, I do know what the size of the BLOBs are, using a
>
> SELECT DBMS_LOB.GETLENGTH($field) AS $field FROM $table
>
> type command.
You can always use the DBMS_LOB package to read parts of the LOB.
I happen to have this snippet of code lyin