This discussion is archived
1 Reply Latest reply: Aug 8, 2013 4:28 PM by Vadim Tropashko RSS

R4 EA - Run procedure - execution problem

Vin Steele Newbie
Currently Being Moderated

The  "Run" function (from either the right-click menu or the green icon in the top of the code editor) for standalone procedures has an problem. When the input parameters for the procedure have been set and the "OK" button has been clicked, it does not execute. It is necessary to invoke the "Run" function a 2nd time to get the procedure to execute. The input parameter changes are kept.

  • 1. Re: R4 EA - Run procedure - execution problem
    Vadim Tropashko Pro
    Currently Being Moderated

    Can't reproduce:

     

    1. create or replace FUNCTION ECHO1

    (

      PARAM1 IN VARCHAR2

    ) RETURN VARCHAR2 AS

    BEGIN

      RETURN PARAM1;

    END ECHO1;

     

    2. Initiate run dialog, then either

     

    2a edit assigment to

    PARAM1 := 'a1';

     

    or

     

    2b edit "Input Value" column

     

    3. Press OK

    4. Witness

     

    Connecting to the database gbr30060_scott.

    Process exited.

    Disconnecting from the database gbr30060_scott.

     

    in the log

     

    5. Witness the "Output Variables" grid to exhibit "a1" .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points