PL/SQL QUESTION(DYNAMIC)

In my procedure in PL/SQL, I have to check whether record exist in the Oracle Table before I update or insert a record.

Using dynamic PL/SQL, I have my update statement with exception. But when I display the value for SQLCODE, it returns a zero even though the record is not found in the Oracle Table. My update statement

Update student set name = 'RAMESH'
where student_ID = '1100'

Is create dynamically and executed using DBMS SQL.

How can I resolve this problem.

My e-mail is

ubsram_at_pacific.net.sg Received on Sun Jan 18 1998 - 00:00:00 CST