Hi, with MaxDB 7.6.00.32 I have the problem that a temporary table created inside a dbproc is not accessible outside the dbproc. With 7.5.0.24 it was possible.
I'm working e.g. with SQL studio: call PROC_BERICHTE_ERNENNUNG (2, '2005-1-1','2005-12-31') The job of the procedure is to fill a temporary table. If there are no data in the temporary table an error message is produced. With both versions 7.6.xx and 7.5.xx the call provides as expected: Statement successfully executed. No Result But select * from TEMP.PERS_AND_DBV with 7.5.xx shows content of the temporary table with 7.6.xx I get the following error Base table not found;-4004 POS(15) Unknown table name:PERS_AND_DBV The shortened procedure: CREATE DBPROC PROC_BERICHTE_ERNENNUNG (IN SANR INT, IN BBEGINN DATE, IN BENDE DATE) AS VAR DBV INT; BEGINN1 DATE; TRY DELETE FROM TEMP.PERS_AND_DBV; CATCH BEGIN CREATE TABLE TEMP.PERS_AND_DBV AS SELECT * FROM DBA.VT_PERS_AND_DBV_ZR_XX; DELETE FROM TEMP.PERS_AND_DBV; END; ... stuff to fill temporary table ... TRY SELECT PERS_NR FROM TEMP.PERS_AND_DBV; CATCH STOP (30334, 'Keine Daten für die Selektion !'); ---> end of procedure The problem also exists if using JDBC. What can I do ? Elke -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]