Dynamic statement to fill temp table in dbproc

Hi,

in my procedure I want to fill a temporary table with a select statement that is dynamic build.
But executing the dynamic statement produces the error:
General error;-9111 ABGL1 Unknown table name:TT_STAT_ABGL

Using 7.5.0.19

CREATE DBPROC PROC_STATISTIK_ABGLEICH
	(IN SANR INT, IN STICHTAG DATE, IN STATISTIK VARCHAR(255), IN BEARBEITER VARCHAR(120),
	IN NUTZERID INT, IN SCHULEN VARCHAR(800)) 
AS
VAR
SEL VARCHAR(1000); 
...

DROP TABLE TEMP.TT_STAT_ABGL;
TRY
	CREATE TABLE TEMP.TT_STAT_ABGL (
		PERS_NR INT,
		SCHULE INT,
		STUNDEN FIXED(5,2));
	CATCH 
		STOP  ($RC, 'ABGL0 ' & $ERRMSG);

SET SEL = 	'INSERT INTO TEMP.TT_STAT_ABGL (PERS_NR, SCHULE) ' ||
		'SELECT PERS_NR, SCHUL_ID FROM T_DBV ' ||
		'WHERE BEGINN <= ''' || STICHTAG || ''' AND ''' || STICHTAG || ''' <= ENDE ' ||
		'AND SCHUL_ID IN (';
IF SCHULEN = '' THEN
	SET SEL = SEL || 'SELECT SCHUL_ID FROM DBA.T_SCHULE WHERE SCHULAMT_NR=' || SANR || ')'
ELSE
	SET SEL = SEL || SCHULEN || ')';
TRY
	EXECUTE SEL;
CATCH
    STOP ($RC, 'ABGL1 ' & $ERRMSG);


Any help ?
Elke


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]