 | | | Temp table created in dbproc outside not visibel with 7.6.00.32 | Temp table created in dbproc outside not visibel with 7.6.00.32 2007-04-03 - By Elke Schmidtke
Back
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/maxdb?unsub=mysql@(protected)
|
|
|