0
I’m creating a database to insert data into a table in the database, but this gives an error that I can’t identify:
Commando:
begin
INCLUIR_CLIENTE(1, 'SUPERMERCADO XYZ', '12345', NULL, 150000);
end;
Message presented:
ORA-06550: line 2, column 1: PLS-00905: Object PLSQL_SCHEMA_CARLOS.INCLUIR_CLIENTE is invalid ORA-06550: line 2, column 1: PL/SQL: Statement Ignored
Structure of the Client Table: Table Client
Procedure I am creating:
create or replace PROCEDURE INCLUIR_CLIENTE
(p_id in cliente.id%type,
p_razao_social IN cliente.razao_social%type,
p_cnpj cliente.cnpj%type ,
p_segmercado_id IN cliente.segmercado_id%type,
p_faturamento_previsto IN cliente.faturamento_previsto%type)
IS
v_categoria cliente.categoria%type;
BEGIN
IF p_faturamento_previsto < 10000 THEN
v_categoria := 'PEQUENO';
ELSIF p_faturamento_previsto < 50000 THEN
v_categoria := 'MEDIO';
ELSIF p_faturamento_previsto < 100000 THEN
v_categoria := 'MEDIO GRANDE';
ELSE
v_categoria := 'GRANDE';
END IF;
INSERT INTO cliente VALUES (p_id, UPPER(p_razao_social), p_cnpj,p_segmercado_id, SYSDATE, p_faturamente_previsao, v_categoria);
COMMIT;
END;
The table fields are all hitting, but even so is giving this error. Can anyone help me, use the Oracle Apex platform ?
I closed the previous question
– Carlos Silva
Compilation failed,line 21 (17:15:53) PL/SQL: ORA-00984: column not allowed hereCompilation failed,line 21 (17:15:53) PL/SQL: SQL Statement Ignored
– Carlos Silva
Can put in question the client table structure?
– Don't Panic
I put the link to the description of the question
– Carlos Silva