MySQL Forums
Forum List  »  Oracle

convert oracle procedure to mysql procedure.
Posted by: navneet dhadak
Date: November 24, 2008 04:59AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
convert oracle procedure to mysql procedure.
5117
November 24, 2008 04:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.