Error(55,8): PLS-00103: Encountered the symbol “C1″ when expecting one of the following: := . ( @ % ;

15 pts.
Tags:
Oracle error messages
PLS-00103
Hi All, I get the following error on compiling my stored procedure code - ****************************************************************************** Error(55,8): PLS-00103: Encountered the symbol "C1" when expecting one of the following: := . ( @ % ; ====================================================== Below is my code, any help appreciated :- ====================================================== create procedure FRAUDS_SIU_ADMIN.Frauds_Subm_Proc as begin EXECUTE IMMEDIATE 'TRUNCATE TABLE FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION'; COMMIT; insert into FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION ( "SUB_ID", "SUB_LEAD_NAIC", "SUB_GROUP_IND", "SUB_GROUP_CODE", "SUB_DATE", "SUB_STAT", "SUB_TOT1_NOOFREFERRALS", "SUB_TOT2_NOOFCIVILACTIONS", "SUB_TOT3_BUDGET", "SUB_TOT4_AMTOFCLAIM", "SUB_COMMENT", "SUB_TOT5_NOOFCLAIMS", "SUB_TOT6_NOOFIFBS", "SUB_TOT7_SIULOCATION", "SUB_TOT8_PEROFINVS", "SUB_TOT9_ISAMENDMENTSUB" ) (select ss.SUB_ID, ss.SUB_LEAD_NAIC, ss.SUB_GROUP_IND, ss.SUB_GROUP_CODE, ss.SUB_DATE, ss.SUB_STAT, ss.SUB_TOT1, ss.SUB_TOT2, ss.SUB_TOT3, ss.SUB_TOT4, ss.SUB_COMMENT, ss.SUB_TOT5, ss.SUB_TOT6, ss.SUB_TOT7, ss.SUB_TOT8, ss.SUB_TOT9 from FRAUDS_SIU_ADMIN.SIU_SUBMISSION ss ); COMMIT; CURSOR C1 IS select SUB_ID FROM FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION; BEGIN FOR subId IN C1 LOOP update FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION set "DET_POLICY_TYPE" = (select distinct b.DET_TYPE from FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION fs, "FRAUDS_SIU_ADMIN"."SIU_DETAIL" b where fs.SUB_ID = b.DET_SUBID AND fs.SUB_ID = subId.SUB_ID); END LOOP; COMMIT; END; END; *************************************************************************************************** Thanks, Ravi

Answer Wiki

Thanks. We'll let you know when a new response is added.

You need the word DECLARE, your statement should look like:
DECLARE
CURSOR C1 IS
select SUB_ID FROM FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION;

good luck

Discuss This Question: 1  Reply

 
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
  • Ravipatil2008
    Thanks Shamshe, It worked...
    15 pointsBadges:
    report

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