Informix IDS 11.5 on Linux.
We create temp tables using stored procedures(SPL) which are sometimes used by other stored procedures/functionality. The stored procedure can be executed more than once in a session, which means that an error occurs (temp table already exists) when the create statement is executed. To manage this, we use an exception statement 'WITH RESUME' to drop and create the table if the temp table already exists.
Is there any other way of determining wether a temp table with the same name already exists in a database session?
We create temp tables using stored procedures(SPL) which are sometimes used by other stored procedures/functionality. The stored procedure can be executed more than once in a session, which means that an error occurs (temp table already exists) when the create statement is executed. To manage this, we use an exception statement 'WITH RESUME' to drop and create the table if the temp table already exists.
Is there any other way of determining wether a temp table with the same name already exists in a database session?