locked
oracle error 00933 RRS feed

  • Question

  • User-1075092149 posted

    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?

    Tuesday, October 16, 2012 4:47 AM

All replies

  • User477186420 posted

    Hey,

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

    let me know if any query

    Tuesday, October 16, 2012 8:44 AM
  • User-1075092149 posted

    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.

    Sunday, October 28, 2012 12:24 PM
  • User269602965 posted

    Add exception handler in the PL/SQL code to trap and manage the record not found condition.

    Sunday, October 28, 2012 3:53 PM