General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

K_U
Occasional Advisor

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

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.
8 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
K_U
Occasional Advisor

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

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
Honored Contributor

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

What are the outputs of the following commands?

% package require Oratcl

% package names
K_U
Occasional Advisor

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

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
Honored Contributor

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

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
Occasional Advisor

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

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
Honored Contributor

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

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
Occasional Advisor

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

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.