wDevil wrote : >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? variables have to be defined before any statement in a db-procedure : CREATE DBPROC hotels_of_town (IN zip CHAR(5)) RETURNS CURSOR AS VAR new_variable INT; $CURSOR = 'HOTEL_CURSOR'; DECLARE :$CURSOR CURSOR FOR SELECT * FROM mona.hotel WHERE zip = :zip; FETCH INTO :new_variable; Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
