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