PROCEDURE
11/09/2003
0
Pessoal estou criando uma procedure mais estou tendo o seguinte erro:
LINE/COL ERROR
-------- ---------------------------------------------------------------
10/5 PL/SQL: Item ignored
11/5 PLS-00597: expression ´<expression>´ in the INTO list is of wro
type
11/5 PLS-00597: expression ´<expression>´ in the INTO list is of wro
type
11/16 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
31/37 PL/SQL: SQL Statement ignored
38/37 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
60/39 PL/SQL: SQL Statement ignored
LINE/COL ERROR
-------- ---------------------------------------------------------------
67/37 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
102/9 PL/SQL: SQL Statement ignored
105/11 PL/SQL: SQL Statement ignored
106/26 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
115/9 PL/SQL: SQL Statement ignored
118/11 PL/SQL: SQL Statement ignored
119/26 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
----------------------------------------------------------------------------------
Estou fazendo a criação da Procedure da seguinte forma
CREATE OR REPLACE PROCEDURE mapa_vendas(v_data_inicio DATE,
v_data_fim DATE,
v_cod_empresa VARCHAR2,
v_clientes VARCHAR2,
v_flag_cli IN VARCHAR2) AS
BEGIN
.
.
.
.
.
END;
Se alguém souber qual o problema, agradeço muito.
Obrigado.
LINE/COL ERROR
-------- ---------------------------------------------------------------
10/5 PL/SQL: Item ignored
11/5 PLS-00597: expression ´<expression>´ in the INTO list is of wro
type
11/5 PLS-00597: expression ´<expression>´ in the INTO list is of wro
type
11/16 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
31/37 PL/SQL: SQL Statement ignored
38/37 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
60/39 PL/SQL: SQL Statement ignored
LINE/COL ERROR
-------- ---------------------------------------------------------------
67/37 PLS-00201: identifier ´LOGIX.NF_MESTRE´ must be declared
102/9 PL/SQL: SQL Statement ignored
105/11 PL/SQL: SQL Statement ignored
106/26 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
115/9 PL/SQL: SQL Statement ignored
118/11 PL/SQL: SQL Statement ignored
119/26 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
----------------------------------------------------------------------------------
Estou fazendo a criação da Procedure da seguinte forma
CREATE OR REPLACE PROCEDURE mapa_vendas(v_data_inicio DATE,
v_data_fim DATE,
v_cod_empresa VARCHAR2,
v_clientes VARCHAR2,
v_flag_cli IN VARCHAR2) AS
BEGIN
.
.
.
.
.
END;
Se alguém souber qual o problema, agradeço muito.
Obrigado.
Manjuneiro
Curtir tópico
+ 0
Responder
Clique aqui para fazer login e interagir na Comunidade :)