OraFAQ Forum: Programming Interfaces » DBD::Oracle wont delete by rowid

Home » Open Source » Programming Interfaces » DBD::Oracle wont delete by rowid (DBD::Oracle (version 1.15), DBI (version 1.41), Oracles v5.8.3, Oracle 10.2.0, Sun 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBD::Oracle wont delete by rowid [message #349953]

Tue, 23 September 2008 10:25

JurgyMan
Messages: 3
Registered: September 2008
Location: USA

Junior Member

Using DBD::Oracle I'm trying to delete by rowid but not having any luck. heres the code:

$dbh = DBI->connect("DBI:Oracle:host=$host;sid=$sid;port=$port", $user, $pass,
  { AutoCommit => 1,RaiseError=>1,PrintError=>1 } )
$dbh->do("delete from $table where rowid = chartorowid('$rowid')")

but get ora errors:

DBD::Oracle::db do failed: ORA-00904:
"AAALpCAAGAACjZ0ABW": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 56 in 'delete from USER.TABLE where rowid = chartorowid(<*>"AAALpCAAGAACjZ0ABW")')
for Statement "delete from USER.TABLE where rowid = chartorowid("AAALpCAAGAACjZ0ABW")"]
at ./dbbulkdelete line 64, <STDIN> line 1.

Ive tried newer perl's but same problem. currently using the perl that comes with Oracle client. also have attempted without the chartorowid() call.

DBD::Oracle (version 1.15), DBI (version 1.41), Oracles v5.8.3, Oracle 10.2.0, Sun 10

Report message to a moderator