problem updating the EDMX of EntityFramework via VisualStudio ALL_ARGUMENTS
the request does not succeed in 19.15.0.0.220419 So what works in 12.2.0.1
SELECT COUNT(*)
FROM SYS.ALL_OBJECTS obj LEFT OUTER JOIN SYS.ALL_ARGUMENTS arg
ON (arg.OWNER = obj.OWNER
AND arg.OBJECT_ID = obj.OBJECT_ID
AND (arg.POSITION = arg.SEQUENCE OR arg.SEQUENCE = 0)
AND NOT EXISTS (SELECT 1
FROM SYS.ALL_ARGUMENTS funcArgs
WHERE funcArgs.OWNER = obj.OWNER
AND funcArgs.OBJECT_ID = obj.OBJECT_ID
AND funcArgs.OBJECT_NAME = arg.OBJECT_NAME
AND funcArgs.ARGUMENT_NAME IS NULL
AND funcArgs.POSITION = 0)
)
where obj.OBJECT_TYPE IN ('PACKAGE', 'PROCEDURE')
AND obj.STATUS NOT LIKE 'INVALID'
AND NOT (obj.OBJECT_TYPE = 'PACKAGE' AND arg.OBJECT_ID IS NULL)