SQL*Plus (MOSC)

MOSC Banner

problem updating the EDMX of EntityFramework via VisualStudio ALL_ARGUMENTS

edited Sep 12, 2022 2:25PM in SQL*Plus (MOSC) 4 commentsAnswered ✓
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center