View Single Post
Old 02-23-2006, 07:52 PM   #1 (permalink)
ashok rajagopal
Registered User
 
ashok rajagopal's Avatar
 
Join Date: Sep 2005
Posts: 20
ashok rajagopal is on a distinguished road
SQLplus errors - oracle

I'm executing a query from my shell script thru sqlplus. following is the body.

select * from job_control where job_id ='1'
insert into job_control values ( ................................)
commit;
WHENEVER SQLERROR EXIT SQLCODE;
exit;


I just wanna know of which statement be the error message.
of the insert query,
or the commit ?

or both ?
ashok rajagopal is offline   Reply With Quote