MySQL Forums
Forum List  »  Stored Procedures

Re: oracle procedure
Posted by: m a
Date: November 04, 2014 12:17AM

if i send the procedure can you please write it down according to mysql syntax ?,i will be grateful to you.

the oracle procedure is as shown below,how to write the same procedure for mysql

create PROCEDURE xxc
IS
CURSOR c1
IS
SELECT dg_no, ruc, codes, dgtype, expdt
FROM xx.test a
WHERE active = 'Yes';
BEGIN
FOR c2 IN c1
LOOP
UPDATE xx.xxc
SET (dg_no, ruc, codes, dgtype, expdt) =
(SELECT dg_no, ruc, codes, dgtype,
expdt
FROM xx.test a
WHERE active = 'Yes' AND dg_no = c2.dg_no)
WHERE dg_no = c2.dg_no AND active_user = 'Yes';
END LOOP;
END;
END;

Options: ReplyQuote


Subject
Views
Written By
Posted
2158
m a
November 03, 2014 06:33AM
1041
November 03, 2014 10:05AM
Re: oracle procedure
1169
m a
November 04, 2014 12:17AM
1038
November 04, 2014 12:55PM
1029
November 04, 2014 09:59PM
1127
m a
November 05, 2014 07:10AM


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.