iw_solution_inlinecallout.ipl

I'm trying to use the inline ipl example which Interwoven provides (iw_solution_inlinecallout.ipl - located in TeamSite/httpd/iw-bin) in order to dynamically populate
a drop down list box via a database call to an Oracle 8i database. From the command line - everything works fine - I open up my DCT and I get a blank page - does anyone know if I need some special enviornment setting in order for this to work - has anyone else had a similiar problem with this example!

Find more posts tagged with

Comments

Adam Stoller

(iw_solution_inlinecallout.ipl - located in TeamSite/httpd/iw-bin)

What version of TeamSite are you using? and are you sure about the above information?

I don't see a file with that name in that directory on my Windows 2000 TeamSite 5.5.2 machine.

I do see: example_datacapture_callout.ipl, and minimal_callback.cgi though.

Did you perhaps mean one of those?

--fish
(Interwoven, Curriculum Development)

Migrateduser

I'm running 5.5.2 - same as you - I could be wrong about the dir - but you do have it I believe - if not it is here:

http://devnet.interwoven.com/site.fcgi/odb/048942

Thanks

Adam Stoller

The script is part of the zip file in that referenced article and not part of the product deliverable (which is why I didn't see it).

That being said, you will probably need to set some environment variables (I am kind of surprised that the person who wrote it didn't run into this problem - but maybe things were set up differently on the system on which it was developed) - but unfortunately I do not remember exactly which environment variables need to be set.

The best way to determine the likely candidates is to save a copy of the environment variables set within your present shell (where it works) and create a dummy perl script in place of the iw_solution_inlinecallout.ipl that does the same thing (into a different file) - and then compare the results.

A simple Perl script like the following can be used to do this:

#!.../iwperl -w
my $ofname = "$ARGV[0]";
open(DBG, ">$ofname") || die " '$ofname' ($!)";
foreach my $e (sort(keys(%ENV))){
    print DBG "$e=$ENV{$e}\n";
}
close(DBG);
exit(0);

I believe you may need something like DBHOME and/or LD_LIBRARY_PATH, and possibly one or two others. If you do, I'd recommend inserting a block like the following near the top of the iw_solution_inlinecallout.ipl script:

BEGIN{
  $ENV{DBHOME} = "/whatever/path/is/needed";
  $ENV{LD_LIBRARY_PATH} = "...";
  ...
};

If you get this to work, please post the changes you needed to make so that we can update the script in the zip file associated with article 48942.

--fish
(Interwoven, Curriculum Development)

Migrateduser

Running the following from the command line - I get the following error - any suggestions? - If I comment out all m,y $ENV it runs fine from the command line but my DCT is blank
I can attach any code if need be

perl -w inline_kmo_test.ipl
DBI->connect failed: Specified driver could not be loaded due to system error 9
98 (Oracle in OraHome81). (SQL-IM003)(DBD: db_login/SQLConnect err=-1) at inline
_kmo_test.ipl line 113
Unable to open database connection at inline_kmo_test.ipl line 113.

Capture.PNG

Migrateduser

OK - this works now - I set three environment vars:

BEGIN {
$ENV {ORACLE_HOME} = 'path to my file';
$ENV {Path} = 'path to my files';
$ENV {SystemRoot} = 'path top my file';
}

Also, in the inline script itself - we serached for all instances of & and replaced them with a & - it just so happens my resultset that was returned had these values - which XML didn't like