MySQL Forums
Forum List  »  Oracle

How to convert this Oracle PL/SQL Function to MySQL
Posted by: errolbug
Date: October 10, 2005 04:16AM

CREATE OR REPLACE FUNCTION DESC2RPT000105_FUNC ( INRPT101ID VARCHAR2,INRPT104ID VARCHAR2 )
RETURN VARCHAR2 IS
CURSOR MYCURSOR IS
SELECT DESCRIPTION FROM RPT000105
WHERE RPT000101ID = INRPT101ID
AND RPT000104ID = INRPT104ID
AND STRIP <> 'Y';
VRET VARCHAR2(500);
BEGIN
VRET := '';
FOR VPERROW IN MYCURSOR LOOP
VRET:=VRET||RTRIM(VPERROW.DESCRIPTION)||'/';
END LOOP;
RETURN RTRIM(VRET,'/');
END;

Options: ReplyQuote


Subject
Views
Written By
Posted
43870
January 03, 2005 10:56PM
25656
February 10, 2005 05:20PM
12651
August 26, 2005 03:28AM
11298
March 09, 2006 06:57AM
10595
March 09, 2006 02:09PM
7855
June 20, 2006 06:42PM
How to convert this Oracle PL/SQL Function to MySQL
19616
October 10, 2005 04:16AM
6311
January 23, 2006 10:37AM
5201
January 23, 2006 02:26PM
4696
September 30, 2006 01:18AM
5147
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.