convert oracle procedure to mysql procedure.

[navneet dhadak]

Hello All,

In My project i am using oracle 10g to write procedure.
Now i want to shift to mysql 6.
In my Oracle Procedure i returns multiple cursor and custom object type array(varray).
CREATE OR REPLACE TYPE profile_photo AS OBJECT
(
ID NUMBER(16),
ALBUM_ID number(16)
);

CREATE OR REPLACE TYPE PROFILEPHOTOOBJARRAY IS VARRAY(100) OF profile_photo;

CREATE OR REPLACE PROCEDURE getRecentUpdates
(
logged_user_id in number,
v_photo out PROFILEPHOTOOBJARRAY
---
---
)
is
---
---
begin
---
---
end;

Is this is posible in Mysql 6.

Thanks
Navneet