oracle procedure error and help me to solve

[Rumeshzoysa]

code is

CREATE OR REPLACE PROCEDURE AGECHECK
as
DECLARE
v_DOB DATE;
v_AGE NUMBER(10);
v_CNAME VARCHAR2(20);
v_CADDRESS VARCHAR2;
v_CPHONE NUMBER(10);
v_PIN NUMBER(10);
v_NIC NUMBER(10);

BEGIN

EXECUTE IMMEDIATE 'CREATE TABLE ADULT(NAMES VARCHAR2(20),ADDRESSES VARCHAR2(20),PHONE NUMBER(10),PIN NUMBER(10),NIC NUMBER(10))';

EXECUTE IMMEDIATE 'CREATE TABLE CHILD(NAMES VARCHAR2(20),ADDRESSES VARCHAR2(20),PHONE NUMBER(10),PIN NUMBER(10),NIC NUMBER(10))';
CURSOR CHECKAGE IS
SELECT DOB,CNAME,CADDRESS,CPHONE,PIN,NIC FROM CUSTOMER C
INNER JOIN ACCOUNT A
ON A.CUSTOMERNO=C.CUSTOMERNO;
OPEN CHECKAGE;
FETCH NEXT FROM; CHECKAGE INTO v_DOB,v_CNAME,v_CADDRESS,v_CPHONE,v_PIN,v_NIC
WHILE NEXT%FOUND
LOOP
v_AGE := months_between(systimestamp,v_DOB) / 12 FROM dual;
IF(v_AGE > 18)
THEN
INSERT INTO ADULT VALUES(v_CNAME,v_CADDRESS,v_CPHONE,v_PIN,v_NIC);
ELSE
INSERT INTO CHILD VALUES(v_CNAME,v_CADDRESS,v_CPHONE,v_PIN,v_NIC);
END IF;
FETCH NEXT FROM; CHECKAGE INTO v_DOB,v_CNAME,v_CADDRESS,v_CPHONE,v_PIN,v_NIC
END LOOP;
CLOSE CHECKAGE;
END;


EXECUTE IMMEDIATE AGECHECK ;



oracle sql developer error are:-

/1 PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior external language The symbol "begin" was substituted for "DECLARE" to continue.

17/8 PLS-00103: Encountered the symbol "CHECKAGE" when expecting one of the following: := . ( @ % ;

---

bump
------ Post added on Sep 10, 2021 at 11:29 PM

 

[U-tag]

oracle bump.

 

[Sword_Fish]

DECLARE eka ain karanna. PL SQL procedure eka create karanakota declare kiyala danne na. Create or Replace procedure syntax balanna.

Procedure ekak hadanne nathuwa oya block eke thiyena tika execute karaganna onenam witharak declare danna.

Ex :

Declare

....

Begin

<Your logic>

End;

 

[Dumbledore]

okkotama kalin kiyapan oya magula execute karana karana sereta ara create table kiyana 1 run venava neda. eka ehema venna one na neh. one time vedak vage mata nm therenne. Nikan kiyavala balala meka kiuve...pl sql langakadi karala na. meke athi pl sql jeevithe karagathu un. syntax errors nikanuth hoyala dei un

 

[inranasingha]

Sir gen ahanna

 

[hodakolla]

BUMPER

 

[Rumeshzoysa]

DECLARE eka ain karanna. PL SQL procedure eka create karanakota declare kiyala danne na. Create or Replace procedure syntax balanna.

Procedure ekak hadanne nathuwa oya block eke thiyena tika execute karaganna onenam witharak declare danna.

Ex :

Declare

....

Begin

<Your logic>

End;

ela goda giya

---

I'm a beginner for oracle
------ Post added on Sep 11, 2021 at 2:17 PM