Calling perl script from TPL

Hi,
I have installed TeamSite 5.1 on windows. I have written a perl script that makes use of DBI, DBD Smiley Surprised

DBC to fire queries on database. I have created a system DSN.

The script runs fine when i execute it from command prompt however when i call the same script from a tpl file using <iw-system>. The script stops at 'create DB connection step'. It doesn't proceed further? I don't get any errors also.

Does it have something to so with system DSN? Ideally it shouldn't matter as its system DSN not user DSN.

Any help on this will be appreciated.

One more thing....i had earlier tried using DBD Smiley Surprised

racle for establishing connection. I don't have the Oracle module in my system. I tried using the oracle module downloaded from CPAN. However there was some version conflicts with the TeamSite DBI module. Is there a way to make it work?

-Madhu

Find more posts tagged with

Comments

Migrateduser

First off, there isn't a 5.1 for TST. We have a 5.0.1 and a 5.5.1. I'm assuming yours is 5.0.1.

Next: if your script runs correctly from the command line but not when envoked from the PT compiler, I'd suspect that there's an environmental difference. Ie, how do you run it from the command line? How are you running it in the iw_system element? Are you giving the full path to the iwperl.exe first, then the full path to the script? Could you show us a snip of your PT that includes the iw_system call? It sounds to me that your perl interpreter can't find the DBD module.

Also: did you know about the iw_sql_* tags? They might be able to do what you want without the custom coding you're doing.

Regarding the Oracle DBD driver, I'll have to defer to someone with more experience there, I haven't done this lately. However: if the ODBC driver is present and works, why do you need the Oracle DBD module?

bw

Bob Walden [bob.walden@interwoven.com]
Interwoven Education Group
IM: Yahoo, MSN bob_walden

mmadhu

I am using TeamSite 5.5.2.
I am using <iw-perl> block to execute the script. When i turn on the trace of DBI. I see that when i execute the TPL, its not able to find the target host.
The error file contains this:
(SQL-S1000)(DBD: db_login/SQLConnect err=-1)
!! ERROR: -1 '[Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist

When i run the same script via iwpt_compile it works fine. I guess it has something to do with the environment in which a TPL runs.

I am attaching the TPL file.

Any help on this will be appreciated.
-Madhu

Edited by mmadhu on 11/06/02 04:14 AM (server time).

Migrateduser

You're using libraries (c:/iw-home/iw-perl/site/lib/HICOM;c:/iw-home/iw-perl/site/lib;c:/iw-home/iw-perl/site/lib/DBD" Smiley Wink

in the iw_perl code that you're not actually invoking in the iw_perl routine.

THen you're calling an external script (c:/iw-home/iw-perl/bin/perl -w c:/iw-home/iw-perl/site/lib/HICOM/SaveDCR.pl $dcr_name), using the perl instead of iwperl interpreter.

Not knowing what's in SaveDCR.pl I can't say for sure, but I suspect your "use" statement in the iw_perl block should be in the external script instead.

I also don't know, and don't have time to test, the effects of calling a script this way from a TPL--I don't know if it's supported or not. The <iw_system> tag is designed to do this--I suspect you don't need the iw_perl block at all.

bw

Bob Walden [bob.walden@interwoven.com]
Interwoven Education Group
IM: Yahoo, MSN bob_walden