get_week_date()
{
`sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 0
SET SERVEROUTPUT ON
SET VERIFY OFF
SET TRIMSPOOL ON
(update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt' where FQ.CHECK_NAME = 'HPS_FILE_NAME_CHK');
(update data_source_master m set M.FILE_NAME_PATTERN='Hyvee_Pharmacy_Solutions_201304_v1.txt' where M.DATA_SRC_CD=998777);
/
(commit);
EOF
`
}
################################################################################
# MAIN FUNCTION
################################################################################
get_week_date
I need to update a table in oracle through .sh script in unix
When i execute the above code it gives me select keyword missing error
Can you help me how to resolve this in order to update a table
Thats not how it works here : You submit your code between code tags, the same with the output and explain what is not going or the result you expected or the error message
all that with your OS version and shell you use...
A keyword missing error will be coming from sqlplus itself, not the script. I'd say your query must be flawed.
Try running that from the commandline and see if it works there:
# DQM_SQL_LOGON="<set this>"
# export DQM_SQL_LOGON
# DQM_SID="<set this>"
# export DQM_SID
# sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF
> SET ECHO OFF
> SET FEEDBACK OFF
> SET PAGES 0
> SET SERVEROUTPUT ON
> SET VERIFY OFF
> SET TRIMSPOOL ON
> (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt' where FQ.CHECK_NAME = 'HPS_FILE_NAME_CHK');
> (update data_source_master m set M.FILE_NAME_PATTERN='Hyvee_Pharmacy_Solutions_201304_v1.txt' where M.DATA_SRC_CD=998777);
> /
>
> (commit);
> EOF