Oratcl 4.4 doesn't work on HP-UX 11.31 normally

[K_U]

I've build Oratcl4.4 on HP-UX 11.31 (Itanium2).
When I try to use the following Oratcl command, I got no replies.

>tclsh8.4
% set dbh [oralogon scmdb/scmdb]
oratcl0
% set cur [oraopen $dbh]
oratcl0.0
% orasql $cur {select * from scheduling_horizon}
0
% set fetched [orafetch $cur]
0

But in Oratcl3.3 on HP-UX 11.21(Itanium2), I got the following replies.
>tclsh8.4
.....
% set fetched [orafetch $cur]
* * {} {} {} 00-01-01 01-01-04 10-02-16

I can't understand why this phenomenon happens.
Give me an advice that resolve this problem, please.

I use Oratcl4.4 and Oracle 11.2.0.1.0.
Both Application was compiled successfully.

Thanks for you help.

[Steven E. Protter]

shalom,

Check the shell these scripts are trying to use.

I am a little surprised at the shell being used in this case. You might try altering copies of these scripts to use posix or korn shell.

SEP

[K_U]

Hi.

Sorry. My explanation was not enough.

I need to use Oratcl and Tcl, because other core application uses Tcl.

What should I check to use Oratcl?

Thanks for your help.

[Turgay Cavdar]

What are the outputs of the following commands?

% package require Oratcl

% package names

[K_U]

Hi.

>tclsh8.4
% package require Oratcl
4.5
% package names
http Oratcl Oratcl::utils tcltest msgcat opt Tcl
%

Now I try to use Oratcl4.5 because I hear that I need to use it on Oracle 11g R2.
But same phenomenon happens.

Thanks for your help.

[Turgay Cavdar]

What is your oracle client and oracle server versions? 11.2.0.1.0? Years ago we have a similar problem, and there is a bug in oracle, after patching the oracle we have solved the problem.

[K_U]

Hi.

Thank you.

I use Oracle Server 11.2.0.1.0.
But I don't know how to check Oracle client versions.
Please tell me how to check it.
And please tell me details of your similar problem.

Thanks for your help.

[Turgay Cavdar]

As far as i know oracle client is required for oratcl so you should already have some environement varilables like:

ORACLE_HOME=/u01/app/oracle/product/10.2.0/client_1
ORACLE_LIBRARY=/u01/app/oracle/product/10.2.0/client_1/lib32/libclntsh.so
ORACLE_SID=CLIENT1
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib

You can check both oracle client versions on hp-ux 11.23 and 11.31 matches or not.

I talked with our dba but he couldnt remember the problem we had in the past. What i remember is we have hp-ux 11.23 with oracle 9i client and database server was 8i, when they run the oratcl scripts they get 0 value. After patching the database server the problem was solved.

[K_U]

Hi.

I solved the problem.
In oratcl4.5, the following descriptions are right.

% orafetch $cur -datavariable fetched

By the following descriptions, I get a return value(0).

% set fetched [orafetch $cur]

Thank you for a reply.