Search Results

I have set variables and then exported
export xxx_DB etc
But I do not see why in my script this does not wrk, can sonehelp

pass=`awk -F: '$xxx_DB ~ /'$ORACLE_SID'/ {print $xxxx_ID}' $pwfile`

I was wondering when you log on to a unix box how does unix know what the default shell type is, C shell, borne shell, korn shell. My understanding is it executes different login scripts depending...

I use to run my scripts by .test.ksh now I have to do ./test.sh.

I think something is not correctly set up on the server. Can someone tell me the difference between . and ./

I though ./ meant...

I use to be able to do a . test.sh shell script but now I have to do ./test.sh

Can someone explain what has most likely happen to cause this.

thank you

can someone tell me what is the difference between . and ./ in a script

In unix how to get a list of user id's that can su and to what ids they can su too?

sftp -v b $putlist $SFTP_ID@TARGET_SERVER


How can I get a return code if fails to put the file?

sftp -v b $getlist $SFTP_ID@TARGET_SERVER ($SFTP_ID@TARGET_SERVER)

How can I get a...

resolved and workin

I get an error no such file or directory.

Yet my permissions are 774.

is there anything else I could check.

thanks

using the script below I want to pass a parameters thorugh my sql
call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does...

I figured it ou at last. was suggesful in generating my list.

thanks all for the help. Hopefully one day I too can provide assistance.

but still no output
last part returned
+ 0<<
@/unixs317/home/cibcenv.sql
echo 0
exit
/

sqlplus -s "${ORA_USERNAME}\/${ORA_PASSWORD}@${ORACLE_SID}"@/unixsxxx/xxxxx/xxxenv.sql ("${ORA_USERNAME}\/${ORA_PASSWORD}@${ORACLE_SID}"@/unixs317/home/al389/cibcenv.sql)
echo $?

ksh:...

runs successfully bit not results are spooled.

I need help . I am not getting anything back from my setup. I have defined an oracle package which I am calling from within my sql call, but is returning no rows. If I run my sql from sqlplus works...

Your idea was good but I cannot use UTL_file. I did code using this package, got it to work but discovered that I am running on one server and the output is automatically going to another server...

Thanks for answering.
We are on Sun OS
we are using ksh and sh shell scripts calling sqlplus Oracle 9i
Utl_file_dir path variable
is this required to be set becuase I keep getting invalid path ....

Does one need to add to UTL_file_dir the path?

I do not have the ability to create directories, againest policies.

Hey all thanks, I did some research and I found infor on UTIL_FILE. Quesion with regrads to this, Do I not need to add the directory I want to the UTIL_FILE_DIR in order to work?

ORA-29280:...

I have korn shell scripts.

I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix...

I think I have it. decalrte all of these in a separate shell script, lets say function.sh

in my parent shell script insert

. function.sh

then all are avaialble and callable.

I have korn shells where I want to create a function passing $1 to a function , determine my $STAT_ENV value, set the paths and return
the paths for STATSH,STATPRM,STATSQR,STATSQL,STATCTL TO BE...

As I mentioned I am learning on the fly at work with no help from anyone here. No one here knows it. This is a real script I am trying to create. I will no longer ask any help from this site.
...

I also want to be able to include path of any file that contains what I am looking for. in my example I am looking for unixsip within files in all . (directories). Can anyone help.

I execute my...

NO idea what you are talking about. You would have to give an example.