Dynamic statement to fill temp table in dbproc

[Elke Schmidtke]

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]