This discussion is archived
1 Reply Latest reply: Feb 20, 2013 4:38 AM by 974238 RSS

quote with in a quote

974238 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points