DBI and modules

2003-10-17 Thread Simon Taylor
-{ORA_PASS}) or throw TNBCriticalException($dbh-errstr); $dbh-func( 100, 'dbms_output_enable' ); $dbh-{RaiseError} = 1; $dbh-{PrintError} = 0; $dbh-{AutoCommit} = 0; $dbh-trace($trace_level); return $dbh; } 1; Simon Taylor Managed Services Technology Consultant Nortel

RE: Problems installing DBD1.12 on DBI1.34 and Perl 5.8

2003-03-04 Thread Simon Taylor
Will this include support for Oracle 8 objects? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: 04 March 2003 22:25 To: Andreas Koch Cc: [EMAIL PROTECTED] Subject: Re: Problems installing DBD1.12 on DBI1.34 and Perl 5.8 On Tue, Mar 04, 2003 at 04:33:59PM +0100,

DBD::ORACLE (1.12) DBI(1.30) - NESTED TABLE

2003-03-03 Thread Simon Taylor
I am trying to do either :- Retrieve data from an Oracle table with a nested table column or Retrieve data from an Oracle object table based on an object which contains a nested table Either attempt results in :- DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed but not

Re: DBD::ORACLE (1.12) DBI(1.30) - NESTED TABLE

2003-03-03 Thread Simon Taylor
Ok thanks - just wanted to check it wasn't down to how I was using it Michael A Chase [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 3 Mar 2003 20:50:09 - Simon Taylor [EMAIL PROTECTED] wrote: I am trying to do either :- Retrieve data from an Oracle table

DBD :Oracle - Nested Table

2003-03-03 Thread Simon Taylor
I am trying to insert into a table which has a nested table. I have an array in Perl which I want to load into the nested table. I have a variable number of entries in the array and dont want to have to enumerate them. How can I load my data into a nested table?

DBD::ORACLE (1.12) DBI(1.30) - NESTED TABLE

2003-03-03 Thread Simon Taylor
I am trying to do either :- Retrieve data from an Oracle table with a nested table column or Retrieve data from an Oracle object table based on an object which contains a nested table Either attempt results in :- DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed but not

DBD::ORACLE (1.12) DBI(1.30) - NESTED TABLE

2003-03-03 Thread Simon Taylor
I am trying to do either :- Retrieve data from an Oracle table with a nested table column or Retrieve data from an Oracle object table based on an object which contains a nested table Either attempt results in :- DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed but not

DBD::Oracle NT

2003-02-27 Thread Simon Taylor
I have performed the following steps and its not playing. (Usually used to doing this on Solaris - first time compiling on W2K) 1) Install Activestate 2) Install DBI using ppm 3) Go to install DBD::Oracle - find there isn't one for Activestate Perl 5.8 4) Try to build one 5) Dowload