1 Reply Latest reply: Feb 20, 2013 6:38 AM by 974238 RSS

    quote with in a quote

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

      SUBSTR('<%=odiRef.getPrevStepLog("MESSAGE")%>',1,1000)

      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?
      Cheers