Thanks in advance!
First of all I’m very new to TOAD/Oracle so please bear with me. I am using Toad PL/SQL and trying to write a stored procedure (SP) that will pass a Select statement as a text string to another SP. How can I assign it to a variable and pass it to the SP? The issue is the Select statement will have singe quotes in the string incasing text values. Below is an example - notice the text value ‘Analyst’ inside the Select statement.
INNER JOIN LRT_EMAIL_INDICATOR ON SECURITY_USER.USER_ID = LRT_EMAIL_INDICATOR.USER_ID WHERE (((SECURITY_USER.LRT_SECURITY)=‘Analyst’)
Message was edited by: MThomas