Oracle: Packaged Custom Types Failing Introspection
Introspection for Oracle is flagging custom types returned by a custom function as an unresolved reference.
The custom type and the function are both defined in the same package. Both are also defined in the package specification and therefore available for introspection. The function is a pipelined table function. The custom type is anchored to columns in an existing view. The columns in the view used for anchoring are defined as built-in types, either varhcar2, date, or number in this case. Introspection level is set to 3. The SQL file is attached to the correct schema. In this case I created the view, the package, the type, and the function so I definitely have sufficient access to view both the signature and the body of the package.
Has anyone else run into this problem?
Please sign in to leave a comment.
Hi kdwhite ,
To investigate this behavior, we need the following logs:
- introspector logs
- Dump Model
I'd also appreciate if you could provide your package with defined custom types (it could be a truncated version with just a few types) so we can perform tests of our own in the meantime.
We'll have a look.
Aleksandr Molchanov can you provide a secure location to send the logs and model?
Yes kdwhite , you can upload the logs onto our FTP server and provide the upload id in your reply.
Aleksandr Molchanov Upload id: 2023_12_20_vv8SkyUeTsumjsJ2FABcZS (file: introspection-diagnostic-Archive Prod.zip)
Let me know if this works.
Thank you Aleksandr Molchanov I have created the following ticket Oracle: Packaged Custom Types Failing Introspection : DBE-19610 (jetbrains.com)
Thanks kdwhite . We'll investigate and fix this issue.