Re: PL\SQL Brain Flatulence - Unexpected End of SQL Command

Nigel and a host of others have pointed out the missing parentheses.

Thanks all for the second set of eyes.

David

On Fri, Apr 20, 2018 at 11:24 AM, David Barbour <david.barbour1_at_gmail.com> wrote:

> open parmRec for
> 'select A_PARM, B_PARM from web_question
> where activity_oid in (184,267)
> and item_id =
> (select substr(instructions,2,16) from question_defn where
> instructions like ''%ESP_RC%''
> and oid =
> (select question_defn_oid from question where oid =
> :v_questionOID' using v_questionOID;
>
> Connecting to the database prdrepsvc.
> ORA-00921: unexpected end of SQL command
>
> The quotes around ''%ESP_RC%'' are two single quotes at the start and
> two single quotes at the end, but the program thinks it's the end of the
> entire statement. Obviously single quote/single quote won't compile.
>
> Experiencing brain freeze here.
>
> Suggestions (answers)?
>
> David
>

--
http://www.freelists.org/webpage/oracle-l