On Mon, 19 Jun 2006 14:31:55 +0100, Tim Bunce wrote:
Hi Tim
Thanx for the feedback. I don't delude myself into calling it peer review :-).
>> $sth_1 -> execute($_) for (1 .. 5);
>> $sth_1 -> finish();
> FYI the call to finish() isn't needed here (or in most of the other
> places you'll see it us
Hi List;
I have a scriptthat is working on a SuSe 386 laptop. However when I
attempt to run it on a Redhat x86_64 box I get this:
DBI object version 1.40 does not match $DBI::VERSION 1.51 at
/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 253.
BEGIN failed--compilation aborted
Hi,
This is a fairly complex setup to explain so I'll initially try and keep
it simple and can expand it necessary. I'm getting the error
$ perl a.pl
SV = RV(0x9fa6df4) at 0xa4450e8
REFCNT = 1
FLAGS = (TEMP,ROK)
RV = 0xa4451a8
dbih_getcom handle HASH(0xa4451a8) is not a DBI handle (has n
Just a hint: If you need temporary tables, this is usually an indicator
that something is terribly wrong with either the database or the way you
want to use the database. Usually, you can use a view or a simple
select, if that way has performance issues, think about indexes and in
really hard c
Ready, Mike [mailto:[EMAIL PROTECTED] wrote:
>
> Hi
> Is there a way to use a bind variable to pass a tablename into an oracle
> create table statement - e.g.
> CREATE TABLE ?
> (
> CASE_NUM NUMBER,
> TLM_PROG VARCHAR2(50 BYTE),
> TLM_REASON VARCHAR2(100 BYTE),
> TLM_CREA
The easiest way to do this is to use PL/SQL and the 'execute immediate'
statement.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ready, Mike [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 8:58 AM
To: dbi-users@perl.org
Subject: Creating an oracle temp table
Hi
Is there a way to use a bind variable to pass a tablename into an oracle
create table statement - e.g.
CREATE TABLE ?
(
CASE_NUM NUMBER,
TLM_PROG VARCHAR2(50 BYTE),
TLM_REASON VARCHAR2(100 BYTE),
TLM_CREATE_DT DATE,
TLM_TASK_NAME VARCHAR2(50 BYTE),
TLM_ACTION
On Sat, Jun 17, 2006 at 03:43:44PM -0500, Erik Paulson wrote:
> Hello -
>
> fetchrow_arrayref has a big warning that you need to copy the data
> in the array before using it, because the next call to fetchrow_arrayref
> will reuse the array.
>
> Does fetchall_arrayref have similiar limitations, a
Hello Ron. Just a couple of minor comments on your example code...
On Sun, Jun 18, 2006 at 10:31:01AM +1000, Ron Savage wrote:
>
> $sth_1 = $dbh_1 -> prepare('insert into t(i) values (?)');
>
> $sth_1 -> execute($_) for (1 .. 5);
> $sth_1 -> finish();
FYI the call to finish() isn't needed here