Search Results

Dear Friends,

I am running a script which runs a select query from a sybase table and outputs the result (1 row) into a .txt file in unix. When I run the script manually it behaves normally....

Hi Guys,

Any more suggestions?

regards,
Santosh.

Hi Jith,


The permission of file '$ORACLE_HOME/bin/oracle' is set to '-rwsr-s--x' from the start.

Still no luck.

Has anyone ever run this before?

regards,
Santosh.

Hi Ranjithpr,

Yes I am able to execute '/home/ivbbuild/tosh.sh' from any directory. Additionally I am able to execute:
/u01/app/oracle/product/9.0.1/bin/sqlplus -s xxxx/xxxx...

Hi Ranjithpr,

Will the exit clause in the .sql file have a semi colon? Please advise.

Hi ranjithpr/Zaxxon,

Here is my .sql file:
$ more rec.sql
select sum (balancechange)
from thistory INNER JOIN account ON
accounthistory.subscriberid = account.subscriberid
where...

Hi,
Can someone please help me here with this one.

This is my script:

# more tosh.sh
#!/usr/bin/ksh
clear
. /home/oracle/.profile
echo "Good morning, world."
export...