Installation failure on DBD-Oracle 1.16

2005-11-23 Thread Martindale, Marty (NGIT)
I have tried to find something on this in google but was unable to locate an answer. I know the DBD interface is well used and someone other than myself should have seen this problem unless it is dealing with my directory structure Using ppm to install DBD-Oracle 1.16 on perl 5.8.7.813 I get

Re: Compiling dbd-oracle on hpux64

2005-11-23 Thread Markus Trenkle
Am 23.11.2005 um 01:17 schrieb Lincoln A. Baxter: Ok, so it looks like the Makefile.PL did not recognize that you were using the gcc (linker) instead of ld or the linker the HP C compilers (like the soft bench compiler) invoke. On the contrary, I'm using the softbench compiler and ld. I will

Binary packages for DBD-Oracle

2005-11-23 Thread Simon Windsor
Hi Is there a site where I download a binary package of DBD-Oracle for a Sun Solaris system? The company I work for has starting insisting that production services have no development tools, ie gcc, on them and it will be several weeks before I can get hold of a Sun Solaris development

Regards: grep: writing output: Broken pipe

2005-11-23 Thread Uthayakumar Paulraj
Dear Sir/Madam, I am using DBI module in my perl script. And also i am using the grep utility along with awk. This utility works fine when we are not initialize the DB connection. If we initialize the DBI connection it throws the error grep: writing output: Broken pipe

RE: Regards: grep: writing output: Broken pipe

2005-11-23 Thread Rutherdale, Will
This is a user group of other people like yourself who use DBI. It is not a support line. Please bear that in mind. The first thing I would look at is your open() statement. There are lots of things wrong with it. a) determine the uid separately and store it in a string, before the open()

Re: Installation failure on DBD-Oracle 1.16

2005-11-23 Thread Jay Strauss
On Tuesday 22 November 2005 12:25 pm, Martindale, Marty (NGIT) wrote: Can't remove directory C:\TEMP/DBD-Oracle-1-452-1132683710: Permission denied at C:/Documents and Settings/vaaacmartic/My I think the above might hold the clue Jay

Re: Installation failure on DBD-Oracle 1.16

2005-11-23 Thread Jay Strauss
Also try doing it in a directory that doesn't have spaces in the name (i.e. start ppm in c:\dbd Jay

Re: Regards: grep: writing output: Broken pipe

2005-11-23 Thread Tim Bunce
On Wed, Nov 23, 2005 at 01:29:51PM +0530, Uthayakumar Paulraj wrote: Dear Sir/Madam, I am using DBI module in my perl script. And also i am using the grep utility along with awk. This utility works fine when we are not initialize the DB connection. If we initialize the DBI connection it

Q: Oracle and BLOBs

2005-11-23 Thread Ron Savage
Hi Folks I've written CGI::Session::Driver::oracle.pm using a_session of type BLOB, and get the Oracle error ORA-01465: invalid hex number when the content to be inserted in that field is output from Data::Dumper. I've read Oracle docs and dozens of questions on AskTom, but nothing says that

RE: Oracle and BLOBs

2005-11-23 Thread Ted Behling
If I remember properly, I think I saw that error when setting up Apache::Session::Oracle. I have my A_SESSION column set up as type LONG. I'm running 9iR2. Hope that helps. Ted Behling -Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005

RE: Oracle and BLOBs

2005-11-23 Thread Ron Savage
On Wed, 23 Nov 2005 19:28:43 -0500, Ted Behling wrote: Hi Ted If I remember properly, I think I saw that error when setting up Apache::Session::Oracle. I have my A_SESSION column set up as type LONG. I'm running 9iR2. Hope that helps. That worked! Ah, well. So much for trying to do the

RE: Oracle and BLOBs

2005-11-23 Thread Steve Baldwin
I don't know if this helps, but if you want to insert into a BLOB column, you can by simply specifying the ora_type attribute. For example ... use DBD::Oracle qw(:ora_types); : my $sth = $dbh-prepare(q( insert into some_table (blob_col) values (:blob_data) ));

RE: Oracle and BLOBs

2005-11-23 Thread Ron Savage
On Thu, 24 Nov 2005 13:55:48 +1100, Steve Baldwin wrote: Hi Steve That's good to know. I won't use that, though, in V 1.00. Here's the context (pinched from the Postgres driver): if ($sth-fetchrow_array() ) { _run_sql($dbh, 'update ' . $self - table_name() . ' set a_session=?