Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00103: Encountered the symbol Error

551557Jul 11 2007 — edited Jul 11 2007
I Have the following piece of code : i get following error in the if statement:

PLS-00103: Encountered the symbol "PRODUCT" when expecting one of the following:

. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <=
IF(pd_rec.product_hierarchy!='Product Family' AND pd_rec.product_hierarchy!='Component')THEN	
		 BEGIN
	  	 SELECT life_cycle_id
           INTO v_status
           FROM lkp_life_cycle
          WHERE UPPER (TRIM (life_cycle_name)) =
                                           UPPER (TRIM (pd_rec.market_status));
      EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
		 DBMS_OUTPUT.PUT_LINE(''Hello');
         --  pkg_bulkload.log_error ('createnew_market',
                --                    'Trail Id not found',
                       --             'ETL',
                       --             '20002',
                       --             'Trail Id not found'
                        --           );
            --raise_application_error (-20002, 'Life cycle id not specfied');
      END;
	 ELSE
	  	  v_status:=pd_rec.product_status;
	 END IF;
	  
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2007
Added on Jul 11 2007
3 comments
499 views