[Oracle connector] Sample project

[Oracle connector] Sample project

  
Forge Component
(12)
Published on 2013-04-01 by Francisco Menezes
12 votes
Published on 2013-04-01 by Francisco Menezes
Could someone please create a sample project for this extension?

Kind regards,
Matthias
Hi,

If anybody is using this component then please share sample project for the same.

Thanks you in anticipation.

Regards,
Sagar Nannaware
Hello, I'm passing the objects but are not being passed on to the final call back the message: ORA-06550: line 1, column 7: PLS-00306: wrong number of types of arguments in chamada...PL / SQL: Statement ignored . What is the correct way?

Luciano wrote:

Hello, I'm passing the objects but are not being passed on to the final call back the message: ORA-06550: line 1, column 7: PLS-00306: wrong number of types of arguments in chamada...PL / SQL: Statement ignored . What is the correct way?

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


Solution

Matthias Preuter wrote:

Could someone please create a sample project for this extension?

Kind regards,
Matthias

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

Solution

thank you