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,
Mark
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
> = 'D
> UAL';";
>
> print "getBlockSizeSQL: [$getBlockSizeSQL]\n";
>
> $getBlockSizeHandle = $dbh->prepare($getBlockSizeSQL);
> $getBlockSizeHandle->execute()
> || die "Nope " . $getBlockSizeHandle->errstr;
> $getBlockSizeHandle->bind_columns(undef, \$blocksize);
> $getBlockSizeHandle->fetch;
>
> print "blocksize: [$blocksize]\n";
>
> 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.
>
> ltg
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
