estou com um pequeno problema na criaçao de uma procedure e gostaria muito da ajuda de v6 para solucuionar isso. segue abaixo o codigo e logo apos a msg do erro:
CREATE OR REPLACE PROCEDURE P_PESQCLICOB
( pRCA PCPREST.codusur%type)
AS
BEGIN
DECLARE PESQCLICOB INT;
SELECT pcprest.codfilial, pcprest.codcli, pcclient.cliente, pcprest.duplic, pcprest.prest,
pcprest.codusur, pcprest.dtvenc, pcprest.codcob, pcprest.dtemissao
INTO PESQCLICOB
FROM PCPREST
INNER JOIN PCCLIENT ON PCPREST.codcli=PCCLIENT.codcli
WHERE PCPREST.codusur=pRCA AND PCPREST.dtpag IS NULL;
END P_PESQCLICOB;
////////////////////////////////
[1]: Statement processed in 0,11 sec with warnings
[1]: (Warning) PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor The symbol "begin" was substituted for "SELECT" to continue.
[1]: (Warning) PLS-00103: Encountered the symbol "JOIN" when expecting one of the following:
, ; for group having intersect minus order start union where connect