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;
-- Correct
MERGE INTO PACKAGE_WITH_TABLE.t_pub T1
USING (SELECT * FROM PACKAGE_WITH_TABLE.t_pub) T2 on T1.ID = T2.ID
WHEN MATCHED THEN UPDATE SET
ID = T2.ID
MERGE INTO PUBLIC.PACKAGE_WITH_TABLE.t_pub T1
USING (SELECT * FROM PACKAGE_WITH_TABLE.t_pub) T2 on T1.ID = T2.ID
WHEN MATCHED THEN UPDATE SET
ID = T2.ID
/*
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 37
-.
*/