|
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 ?
|