Inline cmd useage error

Hi All,

Thanks for the continued efforts in helping each other. I am trying to connect to the Oracle database through a perl script (invoked by inline cmd) in DCT. If I try opening the DCR, it gives out an error

Root cause:
[Wed Jul 11 07:57:29 2007] planningtodesign.ipl: DBI connect('DNS.DEV.ccc','user',...) failed: Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g). (SQL-IM003)(DBD: db_login/SQLConnect err=-1) at

/iw-home/iw-perl/site/lib/plc/planningtodesign.ipl line 21 [Wed Jul 11 07:57:29 2007] planningtodesign.ipl: ERROR at

/iw-home/iw-perl/site/lib/plc/planningtodesign.ipl line 21.

But the same code runs fine and fetches the values from the database when I try to run at the command line. I am attaching my ipl file along with this thread. Any ideas?

Thanks!
Jenni

Find more posts tagged with

Comments

ISCBorisB

Hi All,

Thanks for the continued efforts in helping each other. I am trying to connect to the Oracle database through a perl script (invoked by inline cmd) in DCT. If I try opening the DCR, it gives out an error

Root cause:
[Wed Jul 11 07:57:29 2007] planningtodesign.ipl: DBI connect('DNS.DEV.ccc','user',...) failed: Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g). (SQL-IM003)(DBD: db_login/SQLConnect err=-1) at /iw-home/iw-perl/site/lib/plc/planningtodesign.ipl line 21 [Wed Jul 11 07:57:29 2007] planningtodesign.ipl: ERROR at /iw-home/iw-perl/site/lib/plc/planningtodesign.ipl line 21.

But the same code runs fine and fetches the values from the database when I try to run at the command line. I am attaching my ipl file along with this thread. Any ideas?

Thanks!
Jenni

You are not the first and I'm afraid not the last. For some unfathomable reason, TS processes clear out forked shell's
environment variables and substitute them with their own. DB Connection mechanisms often obtain some of the information
from the Environment variables. You would have to supply them yourself. Look for example [thread=20586]here[/thread]

Jenni

You are not the first and I'm afraid not the last. For some unfathomable reason, TS processes clear out forked shell's
environment variables and substitute them with their own. DB Connection mechanisms often obtain some of the information
from the Environment variables. You would have to supply them yourself. Look for example [thread=20586]here[/thread]

Thanks a bunch. You are right.

$ENV{SYSTEMROOT} = 'C:/WINDOWS';
$ENV{ORACLE_HOME} = 'C:/Oracle/ORAC10.2.0';

The above variables were the missing ones.

Thanks!
Jenni