Código:
Errores: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;
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.