[Oracle connector] Sample project

Luciano wrote:

Why there is no correct sample for this extension?... 

Matthias Preuter wrote:

I suuceed using these steps:

1. this is the action flow on click screen action

2.  Define a type of struct:

3. Define two local variables, one for input user v_id with type text in case (same as the parameter function type), and the important one is the second one with type inputmestore.record, not struct:{find record in below.. and in input provided, type inputmestore}

4. that's it i run and it works, here is the procedure:

PROCEDURE GOJEK (v_id IN VARCHAR2)
   IS
   BEGIN
   NULL;
      DELETE FROM employees
            WHERE employees.id = v_id;

      COMMIT;
   END;

5. and i delete employee with id 5 (the variable is the local variable stated before... v_id of type text):

6. tq

thank you