Assigning the value to VARCHAR variable with special characters
Hi Gurus,
In declare section I have
sql_text VARCHAR2(500);
in procedure body
I have to assign the variable sql_text =' SELECT TO_CHAR (MAX (A.START_DATE_TIME), 'MMYY')
FROM
JTF_IH_ACTIVITIES A, JTF_IH_INTERACTIONS B WHERE A.INTERACTION_ID =
B.INTERACTION_ID AND B.PARTY_ID = :B1 AND A.ACTION_ITEM_ID = (SELECT
ACTION_ITEM_ID FROM JTF.JTF_IH_ACTION_ITEMS_TL WHERE UPPER (ACTION_ITEM) =
'LETTER') AND A.ACTION_ID = (SELECT ACTION_ID FROM JTF.JTF_IH_ACTIONS_TL
WHERE UPPER (ACTION) = 'SENT')'
the due to the special character like ( , ' = : ) I am not able to assign the above sql to the sql_text variable. Can someone please help how I can pass above SQL statement as varchar variable.
Thanks
Naveed