Doh! Worked like a charm. Many thanx!
ltg
> $getBlockSizeSQL = "select blocksize from sys_dba_segs where
segment_name
> = 'DUAL';";
^^^
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
abou
Laurie,
It's the semi-colon at the end of your statement. That character is used by
SQL*Plus to determine the end of a statement, so that it knows when to send it
to the database, but must not be part of the statement sent to the database.
Remove it and life will seem so much nicer :-).
Brgds,
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 c
