1 Reply Latest reply: Feb 20, 2013 6:45 AM by vlethakula RSS

    quote with in a quote

      Iam trying following to get and insert into ERROR_LOG table:-


      It is throwing up an error when it is trying to insert into ERROR_LOG Table,the reason is error message has got following :-

      ' PLS-00201: identifier 'III_1742_2013011901' must be declared'

      i.e quote with in a quote if i take that one out from error message i can insert into ERROR LOG Table.

      How can we avoid this generally in SQL/PL/SQL?