CREATE DBPROC hotels_of_town (IN zip CHAR(5)) RETURNS CURSOR AS $CURSOR = 'HOTEL_CURSOR'; VAR new_variable INT; DECLARE :$CURSOR CURSOR FOR SELECT * FROM mona.hotel WHERE zip = :zip; FETCH INTO :new_variable;
Why i can't declare variable in the procedure, if a database procedure return cursor? May be i do that wrong? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
