Unable to Execute Stored Procedures with a PL/SQL Table When the Table Uses a Different Schema

You receive the following error when you attempt to use a stored procedure that contains a PL/SQL record, PL/SQL table, or boolean data type and the stored procedure is not defined in the schema used to create the connection. This is deliberately restricted because PL/SQL record, PL/SQL table, or boolean data types require wrappers to be generated that may fail when you do not have the required permissions on the selected schema.

Please select procedure from the same schema based on the username that was
used to create connection. This procedure contains PL/SQL RECORD, PL/SQL
TABLE, or BOOLEAN data type and hence wrapper generation can fails due to
privilege problems.

As a workaround, move the stored procedure to the schema used to create the connection. If you cannot change the schema, then define a wrapper stored procedure in the schema that does not reply on PL/SQL record, PL/SQL table, or boolean data types. Instead, you can use SQL object types.