'ALTER is not a valid PL/SQL command. You need to use 'EXECUTE
IMMEDIATE' for this command. The Oracle 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
Use two statements. You can't combine them into one like that.
(without amounts of pain far exceeding that of just executing two 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.a
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
Steffen Goeldner <[EMAIL PROTECTED]> wrote:
> Attached is a fixed implementation for bind_param(). It would be nice if you
> (and
> others) give it a trial.
Steffen,
I'm at some off-site training all of this week; if I can, I will try this
week, otherwise I'll follow up on Monday or Tues
Hello,
I'm using SQLOLEDB to connect to a MSSQL database where I've inserted
some data using the "BULK INSERT" with the option "SET DATEFORMAT DMY".
The SO language installed on the computer where the Sql Server and my
programs runs is English with "Italian" as regional option.
My connection string
[EMAIL PROTECTED] wrote:
Hello all,
Sometimes it is just more sensible to find a workaround rather than a solution.
So, here is an updated script that uses DBI::ADO to create the database, DBI::ODBC
to populate and test it, and DBI::ADO to retrieve the pics via CGI.
Thanks for the pointe