Dependencies are not stored when using some type of constructions in subroutines [CORE5410] #5683
Submitted by: Gabor Boros (gaborboros)
In the below isql test case the NEW_PROCEDURE stored procedure (with PROC1 sub-procedure) depend on the NEW_TABLE table which can be dropped without any error
SQL> CREATE DATABASE 'SUB_DEPEND.FDB'
isql -i SUB_DEPEND.sql -user SYSDBA 'SUB_DEPEND.FDB'
CREATE TABLE NEW_TABLE (NEW_FIELD INTEGER);
SET TERM ^;
CREATE PROCEDURE NEW_PROCEDURE
DECLARE PROCEDURE PROC1
SET TERM ;^
DROP TABLE NEW_TABLE;
The text was updated successfully, but these errors were encountered: