RECREATE PACKAGE PACKAGE_WITH_TABLE AS
BEGIN
TEMPORARY TABLE T_PUB(
ID INTEGER
) ON COMMIT PRESERVE ROWS
INDEX IDX_T_PUB_ID (ID);
END;
RECREATE PACKAGE BODY PACKAGE_WITH_TABLE AS
BEGIN
END;
INSERT INTO PACKAGE_WITH_TABLE.t_pub values (1); -- Correct
INSERT INTO PUBLIC.PACKAGE_WITH_TABLE.t_pub values (2);
/*
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 38
-.
*/
-- Both selects are working correctly.
SELECT * FROM PACKAGE_WITH_TABLE.t_pub;
SELECT * FROM PUBLIC.PACKAGE_WITH_TABLE.t_pub;
Firebird-6.0.0.2167
Firebird-6.0.0.2167