Home » SQL & PL/SQL » SQL & PL/SQL » Exception Handling
Exception Handling [message #235789] Tue, 08 May 2007 00:50 Go to next message
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

I have some doubt .
This is sample program

SELECT employee_id, last_name, salary INTO emp_id, emp_lastname,
emp_salary FROM employees WHERE employee_id = 120;
UPDATE emp_name SET salary = salary * 1.1 WHERE employee_id = emp_id;
DELETE FROM emp_name WHERE employee_id = 130;
INSERT INTO emp_name VALUES (emp_id, emp_lastname, emp_salary);

--this is sample . but contain lot of statemnts are there in this body.
Delete .............
insert ...............
select ..................


i got an error .i don't known which statement.
How can i find out which statement(insert,delete,update) is got an error.How can i handle this error statement..

Pls explain briefly...........


Re: Exception Handling [message #235802 is a reply to message #235789] Tue, 08 May 2007 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ FORMAT YOUR POST, after 70 posts you should know that
2/ POST YOUR ORACLE VERSION, after 70 posts you should know that
3/ COPY AND PASTE YOUR SCREEN, after 70 posts you should know that

Re: Exception Handling [message #235805 is a reply to message #235802] Tue, 08 May 2007 01:19 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

hmmm also we have a fantastic thing called

[Updated on: Tue, 08 May 2007 01:19]

Report message to a moderator

Previous Topic: Why doesn't this rollback work?
Next Topic: Parallel execution: how to.
Goto Forum:

Current Time: Sat Oct 22 16:41:20 CDT 2016

Total time taken to generate the page: 0.12147 seconds