Temp table created in dbproc outside not visibel with 7.6.00.32

"Elke Schmidtke" <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.