gt; separate
>> statements)
>>
>> Shouldn't you be using a bind variable instead of interpolating $period
>> into
>> the SQL as well?
>>
>> --
>> Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
>> http://www.andyhsoftware.co.uk/space ::
k/space :: disk and FTP usage analysis tool
>
> -Original Message-
> From: Ravi Malghan [mailto:[EMAIL PROTECTED]
> Sent: 27 November 2006 22:55
> To: dbi-users@perl.org
> Subject: DBD Oracle: multiple statements in a single execute?
>
> Hi: my dba has asked to exec
PL/SQL docs describe this
command.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ravi Malghan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 27, 2006 3:55 PM
To: dbi-users@perl.org
Subject: DBD Oracle: multiple statements in a single execute?
Hi: my dba has asked
7, 2006 3:55 PM
To: dbi-users@perl.org
Subject: DBD Oracle: multiple statements in a single execute?
Hi: my dba has asked to execute a alter statement before the select
statement. So I need to run the following
alter session set db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, E
D] :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
-Original Message-
From: Ravi Malghan [mailto:[EMAIL PROTECTED]
Sent: 27 November 2006 22:55
To: dbi-users@perl.org
Subject: DBD Oracle: multiple statements in a single execute?
Hi: my dba ha
Hi: my dba has asked to execute a alter statement before the select
statement. So I need to run the following
alter session set db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id FROM EVENT_DATA ED WHERE ED.utime
between $period order by ED.utime;
where $period is a stri