Devart Forums

Posted: **Tue 15 Sep 2020 08:33**

In the past I worked with the ODAC (oracle) components and we used the Query component (I don't remember the exact name). And we had this:

Table CUSTOMER
ID AUTOINCREMENT
NAME VARCHAR(100)

SQL

Code: Select all

select * from customer

SQLInsert

Code: Select all

BEGIN

  CUSTOMERS.Customer_Mng
  (
    :Customer_Id,  --p_Id IN OUT PARAMETER
    :Customer_Name,
    'I'                        -- p_TipAcc (I: Insert; U: Update; D: Delete)
  );

END;

SQLUpdate

Code: Select all

BEGIN

  CUSTOMERS.Customer_Mng
  (
    :Customer_Id,  --p_Id IN OUT PARAMETER
    :Customer_Name,
    'U'                        -- p_TipAcc (I: Insert; U: Update; D: Delete)
  );

END;

SQLDelete

Code: Select all

BEGIN

  CUSTOMERS.Customer_Mng
  (
    :Customer_Id,  --p_Id IN OUT PARAMETER
    :Customer_Name,
    'D'                        -- p_TipAcc (I: Insert; U: Update; D: Delete)
  );

END;

How would you do it in MySQL/MariaDB using packages?

the ReturnParams property is true in TMyQuery

In InsertMode I try to use

call CUSTOMERS.Customer_Mng(:Customer_Id, :Customer_Name, 'I') but doesn`t work.

Thanks

Posted: **Fri 18 Sep 2020 15:23**

MySQL does not fully support MySQL\MariaDB packages at this time.
We will consider adding this functionality in a future release of MyDAC.

Devart Forums

TMyQuery problems with IN OUT parameters

TMyQuery problems with IN OUT parameters

Re: TMyQuery problems with IN OUT parameters