oracle error 00933RSS

• • Reply
  -_-

  Member

  54 Points

  1286 Posts

  oracle error 00933

  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?

• • Reply
  dhol.gaurav

  Contributor

  2770 Points

  774 Posts

  Re: oracle error 00933

  Oct 16, 2012 08:44 AM|dhol.gaurav|LINK

  Hey,

  Can you share your full PL/SQL block here?? because select statement might not generate error

  let me know if any query

  Thanks,
  Gaurav Dhol
  Skype ID : dhol.gaurav
• • Reply
  -_-

  Member

  54 Points

  1286 Posts

  Re: oracle error 00933

  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.

• • Reply
  Lannie

  Contributor

  3412 Points

  1329 Posts

  Re: oracle error 00933

  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.