RE: Oracle 9i Lite and DBD::Oracle problems [solved]

2003-09-02 Thread Brent LaVelle
With the help of Brian Haas and Ian Harisay I got DBD::Oracle working. The advice is to use the regular Oracle9i not the lite version. Another great source of help was: http://www.puschitz.com/InstallingOracle9i.html just getting 9i and 9i lite installed. I use fvwm2(nvidia X driver) as a window

RESOLVED: DBD::Oracle - selectcol_arrayref - Can't seem to get hash from query

2003-09-02 Thread Dave Anderson
I feel like such a n00b... I never ran "commit;" after creating my table. I did that, and like magic it works now. Sorry to have wasted anyone's time. Thanks, Dave A. Tim Bunce wrote: On Mon, Sep 01, 2003 at 11:58:37PM -0700, Dave Anderson wrote: Sorry for the spam, slipped key... again: Af

Re: fetchrow_hashref doesn't work for me!

2003-09-02 Thread Ian Harisay
I work with both MySQL and Oracle. As a standard practice I will write fetchrow_hashref('NAME_lc'). This forces all column names to be lower case. Thomas A. Lowery wrote: On Mon, Sep 01, 2003 at 09:38:04PM +0300, [EMAIL PROTECTED] wrote: The case of the column is correct. This does work w

Re: fetchrow_hashref doesn't work for me!

2003-09-02 Thread Thomas A. Lowery
I'm guessing you need to use $results->{COLUMN} as Oracle upper cases the column names. On Tue, Sep 02, 2003 at 10:58:54AM +0300, [EMAIL PROTECTED] wrote: > By adding that you mentioned i recieved what i expected. > > I am wondering why this doesn't work if i don't add on the top of the program

Re: Still having problems with the BLOBs

2003-09-02 Thread Ronald J Kimball
On Sat, Aug 30, 2003 at 05:56:47PM +0300, John wrote: > $stmt->bind_param(1, $doc, {ora_type => 24} ); Why are you hard-coding the ora_type instead of importing :ora_types from DBD::Oracle? > - > Length 4729DBD::Oracle::st execute failed: ORA-

DBD::Oracle - selectcol_arrayref - Can't seem to get hash from query

2003-09-02 Thread Dave Anderson
DBD::Oracle - selectcol_arrayref - Can't seem to get hash from query System is Solaris, running Perl 5.6.0. it was installed in pkgadd format so I'm not sure what to do about the following: The only two problems I had building DBD:Oracle were as follows: Warning: If you have problems you may nee

Re: DBD::Oracle - selectcol_arrayref - Can't seem to get hash from query

2003-09-02 Thread Tim Bunce
On Mon, Sep 01, 2003 at 11:58:37PM -0700, Dave Anderson wrote: > Sorry for the spam, slipped key... again: > > After much googling I found the following line of code: > > %hash = @{$dbh->selectcol_arrayref($sql,{ Columns=>[1,2]})} > > at http://archive.develooper.com/[EMAIL PROTECTED]/msg00039.h