Re: UNIX and sqlplus

"Mike Tinney" <michael_tinney_at_hp.com> wrote in message news:<aokbtn$b3n$1_at_web1.cup.hp.com>...
> I looking for the correct syntax or a easy way to do a select from a remote
> system on UNIX to be used via a sqript.
>
> Listed below is the current syntax that I have but I can't get it to work.
>
> Is there an easier way to include the sql script file in the original
> script? or should I have it on the remote system ?
>
>
>
>
> remsh entorap -l ods_dba -n ". /u01/entitle/app/oracle/.profile \;
> sqlplus -s system/passwd < queue_count.sql" >
> /opt/apache_sd/cgi-bin/count.log 2>&1
>
> Thanks
> Mike

Set up a listener on entorap. Install the oracle client on your source system.
Configure tnsnames.ora to include an tns_alias for the database on entorap and run:
sqlplus -s system/passwd_at_tns_alias @queue_count

The results of this will be on your local system. If you want them in a location on entorap you could use utl_file to write the log from the sql script.

Ronald