What errors do you get?
For one, your sqlplus query has syntax errors.
Related to the parameters, you should not use double and single quotes.
Also if you wish to execute a query, use '@' instead of '<' in the command line, try this:
PHP Code:
ret=`sqlplus -s $db_user/$db_pwd@$db_sid "$a" "$b" "$c" @./${DirectoryName}/Query.sql <<EOF
-- here go your additional sql commands --
exit
EOF`
Last edited by LKBrwn_DBA; 03-27-2012 at 03:57 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote