PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <um identificador>
<um identificador delimitado por aspas duplas> delete exists
prior <uma string SQL com aspas simples>
The symbol ";" was substituted for "end-of-file" to continue.
para esse código
CREATE OR REPLACE PROCEDURE OCUP_LEITO
AS
BEGIN
insert into DBAHAB.HAB_LEITO
SELECT SYSDATE
,CD_LEITO
,TP_OCUPACAO
,CD_UNID_INT
,DS_LEITO
FROM DBAMV.LEITO;
END