On Tue, Feb 27, 2001 at 11:53:00AM -0800, Laurie Gennari wrote:
> My connect goes just fine. After that, I'm trying to prepare a query, and it
> errors out with:
>
> DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERROR:
> OCIStmtExecute/Describe) at ./ltg.pl line 33.
>
> The code in question is:
>
> $getBlockSizeSQL = "select blocksize from sys_dba_segs where segment_name
> = 'DUAL';";
^^^
> Is there something wrong with my SQL or something? I've stared at this 'till
> I'm cross-eyed, and can't figure it out.
I made this mistake myself the other day. Remove the semicolon at the end
of the SQL statement. That's the invalid character it's complaining
about. (Okay for sqlplus, but not for DBI. :)
Ronald
