Hi,

I try to log the some particular vlaues in a log file from a stored procedure by using the SYSTEM command. Stored procedures is compiled but at the time of execution its give "NOT OWNER " exception.

code sinppet


select alpha,beta,delta into a1,b1,c1 from sstable;
SYSTEM '/tmp/test.sh' || a1 || b1 || c1;


and in teh script I am catching the value as input variables

code sinppet

aa=$1
bb=$2
cc=$3
echo $1 $2 $3 >> logfile name

Actually I want to values (actual value ) should be append in a file .

Hi,

I think that the output file does not have permission or has another owner.

Gustavo.