Shell SQLPlus

Applications Programming
1

Hi,

I am trying to execute the update statment in shell sqlplus.But nothing prompts.if i do ctrl+c i got the below error.

SQL> update table set enabled='N' where type_code='xx';
^C update table set enabled='N' where type_code='xx'
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation.

if i use select statement records are retrived,
is it i need any access permissions...if so how to give that
can anyone advice this.

2 
echo "Enter value1: \c"
read value1
# assume value needs to a be '  ' delimited string
printf "'%s'" "$value" | read string
echo "Enter value2: \c" 
read value2
# assume value two is a number; no  ' ' is needed
sqlplus me/mypassword@someplace << EOF > logfile
set feedback on
update table set enabled= $value2 where type_code= $string;
commit;
exit;
EOF

I am guessing this is what you wanted.

3

nmahendran,
your update statement is still running or waiting when you cancel it.
Try to find out if any other session is holding locks on that table, what size that table is and how many rows would be affected by your update.