Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sqlplus update issue

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sqlplus update issue
# 1  
Old 08-09-2012
sqlplus update issue
Hi all,

I'm facing a problem with a query in a shell script (AIX).
Code:
sqlplus -s NAME/PASS@SCHEMA<<EOF
set echo off
UPDATE HISTORY SET HISTORY.ID = (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)) WHERE EXISTS (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE));
commit;
exit;
EOF

I have no answer after that. I try to type exit; but it does nothing like if sqlplus was "thinking".
When I try this query directly in Oracle, it works fine.
Through a sql script I have the same problem.

Could you please help me ?
Thanks in advance.

Deeper

Moderator's Comments:
Mod Comment How to use code tags
Last edited by Franklin52; 08-09-2012 at 07:07 AM..
# 2  
Old 08-09-2012
Did you load the same profile ? Can you reach the database using this ?

Code:
sqlplus NAME/PASS@SCHEMA

# 3  
Old 08-09-2012
Yes, no problem.
I tried with a select and it works, but this query don't...
# 4  
Old 08-09-2012
use below code to trace error.
Seems like sqlplus is unable to connect to database may be some issue with userid/password or SID.
Code:
sqlplus -s name/pass@schema<<EOF 1>error.txt
your query..
EOF

then check the error.txt for the error occured

Also try to write the sql query in a seperate file sqlquery.txt and execute it as below
Code:
sqlplus user/pass@SID @sqlquery.txt

and see what happens...
Last edited by aashish.sharma8; 08-09-2012 at 07:31 AM.. Reason: Added info
# 5  
Old 08-09-2012
Same problem with sqlquery.txt.
error.txt is empty.

> commit;
> exit;
> EOF
... nothing then
# 6  
Old 08-09-2012
Either sqlplus is waiting for your input or busy updating. Try
Code:
truss -o log sqlplus ...

then check the log to see what sqlplus is waiting for.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

RedHat 5 update 9 BASH update issue

Hi i want to update the BASH because of the "shell shock" vulnerability. my RedHat 5 is clean install with the default mirror site. when im running the command: yum update bash im getting a message saying there is no update. you can see in the attach picture... what am i doing wrong? is... (4 Replies)
Discussion started by: guy3145
4 Replies

2. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

3. Shell Programming and Scripting

Calling sqlplus from Korn shell heredoc issue

Hi, I am facing an issue wherein some temporary files (here docs) are getting created in /tmp and are not getting deleted automatically. When i check the list of open files with below command i can see one file is getting appended continuously.(In this case /tmp/sfe7h.34p) The output is... (4 Replies)
Discussion started by: Navin_Ramdhami
4 Replies

4. Shell Programming and Scripting

Issue with svn update using cron job.

I want to update svn code using a nightly job using cron, i have created a job in cron as, 30 17-19 * * 1-5 /home/saprab/svnUpdate.sh <branch> <svnusername> <svnpassword> >> <logfile> 2>&1 svnUpdate.sh : =============== #!/bin/bash branch=$1 svnuser=$2 svnpass=$3 cd ${branch}... (2 Replies)
Discussion started by: bhavesh.sapra
2 Replies

5. Red Hat

dns update issue

i have redhat service as public dns i have added new entry but when i reload the named service i got this error in log the working directory is not writable (1 Reply)
Discussion started by: leganti
1 Replies

6. Ubuntu

Automatic update script issue (Ubuntu server)

Hi, I've created a very basic script to run apt-get update and apt-get dist-upgrade unattended (run with cron) and save the logs. Though, it's not really a script, just a file containing the commands to run in order: pasteit .com/18601 I'm currently testing this and ran into some unexpected... (4 Replies)
Discussion started by: Raxje
4 Replies

7. Shell Programming and Scripting

production issue - shell sqlplus processing sometime success sometime fail

Hi Expert, Below is a real production environment issue: we are using shell script to FTP to a remote server and fetch around 150 files every day, for each file we need to keep a entry inside ORACLE DB table, before insert into table, each file has a associated logid, which need to be... (2 Replies)
Discussion started by: summer_cherry
2 Replies

8. Solaris

NIS password file update issue

Hi Our nis server running on Sun solaris 8 operating system. I have added a new user in the nis passwd file & when I am trying to update the file from nis server by using following command: # cd /var/yp # make updated passwd It updates the passwd file but does not come back to command... (3 Replies)
Discussion started by: dolphin
3 Replies

9. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ... (2 Replies)
Discussion started by: deepakgang
2 Replies

10. UNIX for Advanced & Expert Users

SQLPLUS and update statements using bind variables

Hello- The code below works fine expect that it does not update the table CTL_INTERFACE "red highlight". Any idea what I'm doing wrong here? Thanks:D # coNNECT to the database and insert a row then get the new row id cycle_id=`sqlplus -S $XXX_USER/$XXX_PW@$XXX_CONNECT << EOF SET ECHO... (3 Replies)
Discussion started by: Nomaad
3 Replies
Login or Register to Ask a Question