nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

inline command

mangetak

Anyone knows which user uses IW to launch DCT?.
I have a problem with and inline command. I have developed a script to fill a combo on a DCT.

I used to have a problem when executing it on command line, but finally found out that the problem was on the enviroment variables to acess Oracle. Some users had the enviroment correctly set on their profile and others didn´t. So we decided to set on the global system enviroments so anyone could execute it and access oracle.

Once I solved the problem, I set on muy DCT the command line as shown:

<item name="efectos_silencio">
<label>Efectos del silencio (Isilbidearen Ondorioak)</label>
<description></description>
<select required="t">
<inline command="/usr/local/bin/perl /opt/iw-home/custom/loadCombos.pl 1 es"/>
</select>
</item>

But when trying to open the DCT, get the same error:

Root cause:
install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD: Smiley Surprised

racle: ld.so.1: /usr/local/bin/perl5.6.1: fatal: /oracle9/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at /opt/iw-home/custom/loadCombos.pl line 33

Oracle driver is correctly installed (aparently) and command works perfect in command line whtever user exectutes it.
We have no clue on what can be happening. Has anyone seen this before?

Find more posts tagged with

Comments

Dwayne

So we decided to set on the global system enviroments so anyone could execute it and access oracle

I suspect this to be the problem. Setting an environment variable "globally" does not mean that it will be set for your <inline> handler. Only those variabled defined by Interwoven are set - nothing else. So if you need some environment variables to be in place to access Oracle, you'll need to set them within your <inline> handler code.

--

Current project: TS 5.5.2/6.1 W2K

mangetak

We tried that aswell but still won´t work. ón´t know what are we doing wrong.

use DBI;

$ENV{LD_LIBRARY_PATH}='/oracle9/lib:/oracle9/lib32:/lib:/coblib:/oracle9/lib:/oracle9/lib32:/lib:/coblib';
$ENV{NLS_LANG}='AMERICAN_AMERICA.WE8ISO8859P1';
$ENV{ORACLE_BASE}='/oracle9';
$ENV{ORACLE_HOME}='/oracle9';
$ENV{ORA_NLS33}='/oracle9/ocommon/nls/admin/data';
$ENV{OSTYPE}='solaris';
$ENV{ORACLE_SID}='ede1';
$ENV{PATH}='/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/ssh/bin:/oracle9/bin:/usr/ccs/bin:/usr/local/bin:/etc:.:/usr/bin/X11:/bin:/usr/bin:/oracle9/bin:/usr/ccs/bin:/usr/bin:/etc:.:/usr/bin/X11:/bin:/usr/local/bin:/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle:/usr/local/lib/perl5/5.6.1/sun4-solaris';
$ENV{PWD}='/usr/bin';
$ENV{SHELL}='/usr/bin/ksh';

...

my $dbh=DBI->connect($cadena,$usuario,$password) or print("Error en la conexion a la BBDD");

...

Any clue?

Dwayne

Make sure that all of these variables are set witin a BEGIN block, and you might even make sure you set them before doing the use DBI;. (Don't know if it's needed, but it doesn't hurt.)

--

Current project: TS 5.5.2/6.1 W2K