MySQL Forums
Forum List  »  Oracle

Re: How to convert this Oracle PL/SQL Function to MySQL
Posted by: anupam tripathi
Date: August 06, 2008 03:24AM

YOU can try this

create function desc2rpt000105_func (rpt101id varchar(225),inrpt104id varchar(225) )returns varchar(225)
begin
declare mycursor cursor for select description from rpt000105 where rpt000101id = inrpt101id and rpt000104id = inrpt104id and strip <> 'y';
declare vret varchar(500);
set vret = '';
for vperrow in mycursor loop
set description)||'/';
end loop;
return rtrim(vret,'/');
end;

Options: ReplyQuote


Subject
Views
Written By
Posted
43850
January 03, 2005 10:56PM
25642
February 10, 2005 05:20PM
12645
August 26, 2005 03:28AM
11290
March 09, 2006 06:57AM
10590
March 09, 2006 02:09PM
7847
June 20, 2006 06:42PM
Re: How to convert this Oracle PL/SQL Function to MySQL
5624
August 06, 2008 03:24AM
6301
January 23, 2006 10:37AM
5192
January 23, 2006 02:26PM
4691
September 30, 2006 01:18AM
5142
February 06, 2007 12:17AM


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.