Last post Oct 28, 2012 03:53 PM by Lannie
Oct 16, 2012 04:47 AM|-_-|LINK
i have a variable and select date into variableA from tableA where col_a='1'
when record could not be found then the pl/sql causes error about
ORA-00933 :SQL command not properly ended
how to avoid error when there is no record retrieve?
Oct 16, 2012 08:44 AM|dhol.gaurav|LINK
Can you share your full PL/SQL block here?? because select statement might not generate error
let me know if any query
Oct 28, 2012 12:24 PM|-_-|LINK
var v_date varchar2(10);
select createdate into v_date from tableA where id='001';
when there is no ID=001, then it causes error when i run the pl/sql, how can i avoid this error when the record could not be found in Oracle.
Oct 28, 2012 03:53 PM|Lannie|LINK
Add exception handler in the PL/SQL code to trap and manage the record not found condition.