Environment:MAXDB Version 7.00.8
Hi,
i want to execute an SQL-statement generated by
an sub-dbproc (see the example code please).
I can call the CREATE_KST_LEISTUNG dbproc
but the SQL-statement does not executed by the caller dbproc.
Where is my mistake?
Thank you,
Raik Thalheim
/*##################################################################*/
CREATE DBPROC CREATE_KST_LEISTUNG(IN int_Test Integer) AS
VAR
SQL_KST_PRO_LST VARCHAR(8000);
call GET_STRING(:SQL_KST_PRO_LST);
execute SQL_KST_PRO_LST;
/*##################################################################*/
CREATE DBPROC GET_STRING(OUT SQL VARCHAR(8000))AS
SET SQL = 'INSERT INTO .......
SELECT ... FROM "TEMP"."TABLE" ';
/*##################################################################*/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
