Immediate error when executing stored procedure from the beginning of the Script

Question

Immediate error when executing stored procedure from the beginning of the Script

Navigation

#1 by (0 votes)

0

I'm trying to run a Stored Procedure on Toad for Oracle 12.12 but I have not succeeded. I hardly execute the stored, I miss an error from the word Declare, I would appreciate your help.

DECLARE
   -- Declarations
   var_P_NROTRA    NUMBER;
   var_P_CODUSR    VARCHAR2 (32767);
   var_P_NROTOK    VARCHAR2 (32767);
   var_VR_OUTPUT   SYS_REFCURSOR;
BEGIN
   -- Initialization
   var_P_NROTRA := 1;
   var_P_CODUSR := 'CCELIS';
   var_P_NROTOK := '1';

   -- Call
   BSSOFT_APP.APP_PA_001.APP_PR_005 (P_NROTRA    => var_P_NROTRA,
                                     P_CODUSR    => var_P_CODUSR,
                                     P_NROTOK    => var_P_NROTOK,
                                     VR_OUTPUT   => var_VR_OUTPUT);

   -- Transaction Control
   COMMIT;

   -- Output values, do not modify
   :4 := var_VR_OUTPUT;
END;

oracle-11g stored-procedure packages toad

asked by J. Carlos 12.04.2018 в 00:36

source

1 answer

Merge to different branches in git Problem with pointers and valgrind

score 0 · Answer 1

It is the declaration of the variable NUMBER must put the number of digits:

DECLARE


-- Declarations
   var_P_NROTRA    NUMBER(5);
   var_P_CODUSR    VARCHAR2 (32767);
   var_P_NROTOK    VARCHAR2 (32767);
   var_VR_OUTPUT   SYS_REFCURSOR;
BEGIN
   -- Initialization
   var_P_NROTRA := 1;
   var_P_CODUSR := 'CCELIS';
   var_P_NROTOK := '1';

   -- Call
   BSSOFT_APP.APP_PA_001.APP_PR_005 (P_NROTRA    => var_P_NROTRA,
                                     P_CODUSR    => var_P_CODUSR,
                                     P_NROTOK    => var_P_NROTOK,
                                     VR_OUTPUT   => var_VR_OUTPUT);

   -- Transaction Control
   COMMIT;

   -- Output values, do not modify
   :4 := var_VR_OUTPUT;
END;