Search Results

Search: Posts Made By: senmng
5,295
Posted By senmng
Shell script to capture a value from the log file and initiate some action based on that
Hi - I have korn script to execute a oracle job to process a data file . Here in the shell script we are a capturing all the activities in a log file(LOG_File) and we are capturing the record count...
3,315
Posted By senmng
Apologize for the delay in response. Here are the...
Apologize for the delay in response. Here are the little bit detailed code snippet where it starts with execution of procedure and check the error and execution status and then transmits the...
3,315
Posted By senmng
ksh script to validate the record count status
Hi - I have a KSH script to execute a oracle job to generate a data file and then ftp the same file to the downstream application. Here currently we have a validation check that not to send the file...
5,137
Posted By senmng
Dear Robin-That will really help me to do the...
Dear Robin-That will really help me to do the sanity check.
5,137
Posted By senmng
Sure Robin. In this case, we are handling only 0...
Sure Robin. In this case, we are handling only 0 and 3 digit numeric values . But in other cases like you mentioned (multiple lines,empty files) can we use sed(for displaying nth line) and grep(for...
5,137
Posted By senmng
Awesome! It's working as expected now by...
Awesome! It's working as expected now by assigning the variable value in this approach.
outvar=$(<test.out)
if [ $outvar -eq 0 ]

Please wrap all code, data files, input & output/errors in CODE...
5,137
Posted By senmng
Hi - Apologize for the delayed response. Here is...
Hi - Apologize for the delayed response. Here is the code which i tired where it passes the value to the shell script(in echo command) but not able to get the variable value in the IF condition. Am...
5,137
Posted By senmng
What's the other option to return the value to...
What's the other option to return the value to the shell script and use the same in the IF condition?

Can you please show some examples using UTL_SMTP and UTL_mail to send emails on the success?
5,137
Posted By senmng
Hi - Thanks for your reply. - Yes, that...
Hi - Thanks for your reply.


- Yes, that issue has been fixed and it's now reading that file which has username,password and parameters
- Not necessarily but we need the full access for the...
5,137
Posted By senmng
Thanks for your reply Robin. Here is the modified...
Thanks for your reply Robin. Here is the modified code. Also could you assist me in how to store the return value of procedure to the shell script.Here the variable V_COUNT value is not returning to...
5,137
Posted By senmng
Also , i'd like to have an accurate mechanism to...
Also , i'd like to have an accurate mechanism to store the return value of procedure to the shell script. Here my requirement is to execute a stored procedure from this shell script once done i need...
5,137
Posted By senmng
I tried with the same code by giving the exact...
I tried with the same code by giving the exact path for funct.sh. Now that error not found [No such file or directory got rectified but it's not connecting with Oracle and not executing the proc. ...
5,137
Posted By senmng
Shell script to execute Oracle procedure and trigerring email on success and failure
Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log...
4,346
Posted By senmng
Hi - Where can we give? the < /dev/null(exit...
Hi - Where can we give? the < /dev/null(exit suppresss exit status command) in my code ? also what's the difference between ksh -x and ksh -xv while debugging the code?
4,346
Posted By senmng
Just adding wait will work? wait exit 0
Just adding wait will work?

wait
exit 0
4,346
Posted By senmng
Shell script is hanging up every time even after it's successful
We are using a korn shell script which is meant to trigger a Oracle job to load the data from a flat file to an Oracle database . Also the same script addresses the following tasks also like...
Showing results 1 to 16 of 16

 
All times are GMT -4. The time now is 07:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy