Search Results

i have the following code inside a shell script .prog in oracle server when i call the program

DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id);
will return 0 , it is very strange , i try...

i tried change
l_result := fnd_concurrent.set_completion_status('ERROR','Review log file for details.');
fnd_concurrent.set_completion_status('NORMAL',... then it return the normal result.

i have the follow shell script that try to find any file in the specified path and upload to oracle.
if no file will output in the concurrent log and the program return as error , how do i change...

i am new to shell script, coudl you help explain a little about the code, i have no idea how it works ..

thanks for your answer, it work, but i discover that

the format is a bit different for users,

alex_li_20140304121212_tm1.csv

alex_cf_li_20140304121212_tm1.csv

there might be some user...

ya i am trying to sort the specific part of the filename, for the last modified date timestamp i am able to sort this


i tried ls -t | awk -F '_' '{print $3}'

it will output as...

originally the shellscript


#ln_file_name=`echo $ld_interface_date"_"${8}".csv"`
#ln_file_name=`echo 201202011527_HL_HLTM1_B04A.csv`
ln_file_name="*"`echo ${7}".csv"`...