You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
SELECT * FROM RDB$DEPENDENCIES; returns nothing.
SQL> CREATE DATABASE 'SUB_DEPEND.FDB'
CON> user 'SYSDBA' password 'masterkey';
summary: Dependencies are not stored when using some type of contructions in subroutines => Dependencies are not stored when using some type of constructions in subroutines
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
SELECT * FROM RDB$DEPENDENCIES; returns nothing.
SQL> CREATE DATABASE 'SUB_DEPEND.FDB'
CON> user 'SYSDBA' password 'masterkey';
isql -i SUB_DEPEND.sql -user SYSDBA 'SUB_DEPEND.FDB'
SUB_DEPEND.sql:
CREATE TABLE NEW_TABLE (NEW_FIELD INTEGER);
COMMIT;
SET TERM ^;
CREATE PROCEDURE NEW_PROCEDURE
AS
DECLARE PROCEDURE PROC1
AS
DECLARE VARIABLE VAR1 INTEGER;
BEGIN
SELECT NEW_FIELD FROM NEW_TABLE INTO VAR1;
END
BEGIN
EXECUTE PROCEDURE PROC1;
END;
^
SET TERM ;^
COMMIT;
DROP TABLE NEW_TABLE;
COMMIT;
Commits: d7e131b 48d43a8
The text was updated successfully, but these errors were encountered: