Sep 14, 2015, 11:24 AM
Post #3 of 8
I don't have control over the versions of modules I am stuck using. They are likely old.
Re: [pdolinski] DBI Interface Problem
[In reply to]
perl -MDBD::Oracle -le "print $DBD::Oracle::VERSION"
perl -MDBI -le "print $DBI::VERSION"
I enabled RaiseError, but what does that change? The error is still the same.
Uncaught exception from user code:
DBD::Oracle::st execute failed: ORA-00987: missing or invalid username(s) (DBD ERROR: error possibly near <*> indicator at char 13 in 'grant dba to <*>:p1') [for Statement "grant dba to ?" with ParamValues: :p1='toms'] at db_util.pl line 1874.
#... function call chain
Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at db_util.pl line 1874.
>Does it work if you pass $usr_name in the execute statement?
No. Same error.
When comment out $sth->execute (), I get this:
Import: Release 22.214.171.124.0 - Production on Mon Sep 14 14:17:38 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning and OLAP options
ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import
Master table "TOMS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "TOMS"."SYS_SQL_FILE_FULL_01": #...commented out
Job "TOMS"."SYS_SQL_FILE_FULL_01" successfully completed at 14:17:42
Abnormal program termination.
(This post was edited by pdolinski on Sep 14, 2015, 11:26 AM)