PL/SQL (MOSC)

MOSC Banner

Wrapping of type specification seems not to be possible, when accessible by clause is used

Hi community,

I just found an unexpected limitation of the pl/sql wrapping utility (Oracle DB 21c Release 21.9) when I wanted to wrap the following type specification:

CREATE OR REPLACE TYPE tp_test_internal
AUTHID DEFINER ACCESSIBLE BY (TYPE tp_test)
AS OBJECT
(
id INTEGER
);
/

When run the wrapping utility with command

wrap iname=TP_TEST_INTERNAL.tps ONAME=TP_TEST_INTERNAL.wrp

I got the following output on screen

PL/SQL Wrapper: Release 21.0.0.0.0 - Production on Sa Mrz 4 22:14:01 2023
Version 21.9.0.0.0
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Processing TP_TEST_INTERNAL.tps to TP_TEST_INTERNAL.wrp

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