I can't figure out why this isn't working. Any help please, here is the script:
WHILE (counter < 2) LOOP
traineeID := (
'SELECT info_card_id FROM tdc_doc_infocard
WHERE title_nm IN(
SELECT title_nm FROM tdc_doc_infocard
WHERE title_nm LIKE 'Trainee%')
AND revision_nm := '3'
OR revision_nm := '2'
ORA-06550: line 11, column 22:
PLS-00103: Encountered the symbol "TRAINEE" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem =>
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec as between || multiset member submultiset
06550. 00000 - "line %s, column %s:n%s"
Software/Hardware used: Oracle 11g