Hello,
Is it possible to combine cursor and dynamic query.
I need something like:
CREATE DBPROC GET_EVENT (IN eventTb Varchar(30)) RETURNS CURSOR AS
BEGIN
$CURSOR = 'USER_EVENT_CURSOR';
DECLARE :$CURSOR CURSOR FOR
SELECT * FROM :eventTb WHERE ROWNO <= 1;
END;
or
CREATE DBPROC GET_EVENT (IN eventTb Varchar(30)) RETURNS CURSOR AS
VAR
stmt Varchar(300);
BEGIN
SET stmt = 'SELECT * FROM ' || eventTb ||' WHERE ROWNO <= 1';
$CURSOR = 'USER_EVENT_CURSOR';
DECLARE :$CURSOR CURSOR FOR
EXECUTE :eventTb;
END;
These procedures are not correct - SQL grammer does not allows them.
Regards Dusan.
--
Dusan Kolesar
Helsinska 19
040 13 Kosice
Slovakia
e-mail : [EMAIL PROTECTED]
ICQ# : 160507424
-=x=-
Skontrolované antivírovým programom NOD32
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
