Bonsoir,
J'ai une erreur dans le script suivant. l'erreur m'est indiquée:
Error(2,1): PLS-00103: Encountered the symbol "SET" when expecting one of the following: ; is with authid as cluster order using external deterministic parallel_enable pipelined
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 create or replace procedure EmpNaoEntregue (code_funcionario in funcionario.cod_func%type) set SERVEROUTPUT on declare texto char(25); begin select artigo_roupa.design into texto from funcionario,encomendas, artigo_roupa, linha_encomenda where funcionario.cod_func = encomendas.cod_func and encomendas.cod_encomenda = linha_encomenda.cod_encomenda and linha_encomenda.cod_artigo = artigo_roupa.cod_artigo and linha_encomenda.estado_enc like '0' and funcionario.cod_func = code_funcionario; dbms_output.put_line(texto); end; /
Partager