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

Reply via email to