Resolve ORA-06550, and PLS-00103

70 pts.
Tags:
I can't figure out why this isn't working. Any help please, here is the script: DECLARE counter NUMBER:=0; traineeID varchar2(100); BEGIN 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' AND rownum<=1'); Error: Error report: 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
ASKED: May 25, 2012  6:12 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following