When I try to view the a stored procedure I instead get the following text:
-- auto-generated definition
-- No source text available
Right clicking the package and copying the DDL to clipboard outputs nothing. I have "Introspect using JDBC metadata" checked and all sources (excluding system schemas) are supposed to be loaded.When I try to copy the DDL of a procedure from the package I get the below text instead:
-- we don't know how to generate routine EFFECTIVENESSCHECK_Q1 (class PackageRoutine) :(
-- comment on routine EFFECTIVENESSCHECK_Q1 not supported: Packaged procedure
Does anyone know any fixes that could get the DDL for the package and its stored procedures to be displayed properly?