Re: ANNOUNCE: DBIx::Librarian 0.1

On Thursday 15 November 2001 08:31 am, Terrence Brannon wrote: On Wednesday, November 14, 2001, at 10:33 PM, Jason W May wrote:     The implementation provided by DBIx::Librarian is sufficiently     different from other related modules (in particular, SQL::Catalog)     that this module is

Re: inserting into CLOB field

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

storing image fail

Hallo, I am working with Mysql-DB and tables with BLOB-field. Users can put Images into DB with a formular. I want a picture-manipulation with GD (Copyright-information in every picturefile) I have written a subroutine but its not working correct.

Out of memory error when using fetchall_arrayref or fetchall_hashref

DBI version 1.20 DBD::Ingres 0.30 on AIX 4.3 I'm getting this error, presumably from perl itself :- Out of memory! and things seem to die immediately. Has anyone seen anything like this before. Cheers, Mark. Mark Buckle, Database Administrator, Implementation - Intech Solutions DDI:

RE: Out of memory error when using fetchall_arrayref or fetchall_hash ref

Followup The query I am running here should only return a single row, so it can't be a genuine out of memory error (I've tested the query in isql) Mark. -Original Message- From: Mark Buckle [mailto:[EMAIL PROTECTED]] Sent: 16 November 2001 12:04 To: '[EMAIL PROTECTED]' Subject: Out of

Re: Out of memory error when using fetchall_arrayref or fetchall_ hash ref

On Fri, Nov 16, 2001 at 12:08:14 -, Mark Buckle wrote: From: Mark Buckle [mailto:[EMAIL PROTECTED]] I'm getting this error, presumably from perl itself :- Out of memory! The query I am running here should only return a single row, so it can't be a genuine out of memory error (I've

Re: inserting into CLOB field

Two things: 1) Wolfgang asked that if table crr is a synonym, then try using the real table name instead 2) Your DBI and DBD::Oracle versions are not current - this shouldn't(?) matter, but if you can I would try upgrading those to the recent versions. DBI - now at version

Re: inserting into CLOB field

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

RE: Out of memory error when using fetchall_arrayref or fetchall_ hash ref

The trouble with the perl I'm using is that it is supplied with the server OS, as is, by Bull. This may or may not make a difference. I very much doubt that it was compiled on this specific server. The DBI/DBD libraries were compiled on this server by myself. I do have the same problme with

Re: inserting into CLOB field

...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.

Re: inserting into CLOB field

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

Re: DBI - Raiserror

[ redirected to dbi-users ] Sonia Lodovichetti (LMC) writes: I'm having problems catching the error and error message sent by a database trigger using raiserror. I did a quick test with a simple insert trigger, and I did get the error in the client. Here is my code:

RE: ANNOUNCE: DBIx::Librarian 0.1

I recommend you examine DBI::AnyData as a means toward support multiple repositories for SQL (like XML, tab delimited, RDBMS). Good luck... -Original Message- From: Jason W May [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 8:52 PM To: Terrence Brannon; [EMAIL PROTECTED]

Re: inserting into CLOB field

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 :) --

Persistent Connection

BDY.RTF Description: RTF file

Re: dbi:Oracle connections always go through Net8?

Dong, I think you're mixing apples and oranges. You can get a local connection (avoid sqlnet and the listener) in 2 ways (that I know of): 1) $dbh = DBI-connect(dbi:Oracle:,$userid,$passwd); 2) define and entry in your tnsnames.ora like (*note my ORACLE_SID=o817): LOCAL.world =

DBI-ODBC-FileMaker Cannot extract data from DB to Web

Hi all, I'm using PERL and a PERL module called DBI and a sub module called DBD::ODBC I'm using Windows 2000 Server, and FileMaker Pro 5 v3 Under the command prompt (logged in as myself) I can connect and pull and print data out on the DOS shell. However, when I run the script under the web it

Module update for DBI

Record update in the PAUSE modules database: modid: [DBI] statd: [M] was [a] stats: [m] statl: [c] stati: [O] statp: [p] was [?] description: [Generic Database Interface (see DBD modules)] userid: [DBIML] chapterid: [ 7] mlstatus: [list]