EMBEDDED MYSQL Procedure Declare type

Question

Is it possible to declare parameters with some table struct type in "EMBEDDED MYSQL Procedure" ?

CREATE PROCEDURE Product_p()
BEGIN
    DECLARE ProductValue ProductTable;

Answer 1

There are two options:

1. Use a Cursor as parameter
2. Use Temporary Table, this case you don't have to pass the data, just insert into the temporary table, and select in your procedure.