topic Re: Pass IN OUT variable parameter in Operating System - HP-UX

Pass IN OUT variable parameter

la_cool — Mon, 04 Apr 2005 09:44:20 GMT

Hi,

I'm executing the Shell script with IN OUT PARAMETERS, Im UNABLE TO return the values:

Here is the exectuion os shell script:

define sTicket='A456';

define sUtime=$Utime

execute sp_aloghistorydw2($Time,:sTicket,:sUtime);

$Ticket=:sTicket

$Utime=:sUtime

I'm getting "no value", when I expect to see the value in ":sTicket" and ":sUtime" variable.

Please shed some ideas on this ..

Re: Pass IN OUT variable parameter

harry d brown jr — Mon, 04 Apr 2005 10:00:12 GMT

WHat shell are you using?

what does sp_aloghistorydw2 do ??

live free or die
harry d brown jr

Re: Pass IN OUT variable parameter

Jdamian — Mon, 04 Apr 2005 10:01:37 GMT

Is it a Korn-shell script or a SQL script ?

Re: Pass IN OUT variable parameter

A. Clay Stephenson — Mon, 04 Apr 2005 10:04:01 GMT

What shell is this? It's certainly not obvious to me.

One thing I notice is that you seem to be trying to change the value in a parent process by executing something as a child process -- that's never going to work in UNIX.

Re: Pass IN OUT variable parameter

A. Clay Stephenson — Mon, 04 Apr 2005 10:27:15 GMT

The more I look at this, it appears to be some sort of SQL script although you called it an OS shell script. You really need to identify the OS, Database, and scripting language.

Re: Pass IN OUT variable parameter

la_cool — Tue, 05 Apr 2005 11:36:56 GMT

I apologize for not sending the complete info.

The parent script is Shell script called using C shell.

Passing the parameter is for using Oracle SQL script .

Please see the attachment .
It has shell script calling .sql Script

Re: Pass IN OUT variable parameter

A. Clay Stephenson — Tue, 05 Apr 2005 12:07:16 GMT

As I suspected you are trying to change the environment of a parent process (in this case variables) by actions of a child process. This will never work. You can have sqlplus write tyhe values to a file and then read the file for the values.