Que hay de malo en este procedure que me da error
Código:
CREATE OR REPLACE PROCEDURE P_PROCE (
pCOD IN INTEGER,
pVAL IN VARCHAR2,
pFEC IN VARCHAR2,
pFECF IN VARCHAR2,
pUSE IN VARCHAR2,
nEWID OUT INTEGER);
DECLARE
TYPE MIREC_ID IS RECORD (NID TABLA1.ID%TYPE);
OBJREC MIREC_ID;
AS
BEGIN
INSERT INTO TABLA1 (ID,
COD,
VAL,
FEC,
FECF,
FECM,
USU)
VALUES (S_MISEQ.NEXTVAL,
pCOD,
pVAL,
pFEC,
pFECF,
SYSDATE,
pUSE)
RETURNING TABLA1.ID INTO OBJREC;
nEWID := OBJREC.NID;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR');
ROLLBACK;
END P_PROCE;
Errores:
ORA-06550: line 20, column 14:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 7, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 23, column 5:
PLS-00201: identifier 'NID' must be declared
ORA-06550: line 23, column 5:
PL/SQL: Statement ignored
De ante mano gracias.
EDITADO---
Me auto respondo era el AS deespues del declare.