package wizard and object type...

[genetics]

Hi!

What's going on?

I repeat my question... please, I need this feature...

I'm using package wizard, and I have problems with one, predefined by Oracle type, called: dbms_aq.message_properties
When procedure has a parameter with this type, I can't call that one.
When I try to do this I recieve an error and procedure is not executed. It looks like:
ble..ble..ble type aq$_agent does'n exists ble..ble..ble. This aq$_agent is also predefined type and one of the properties of message_properties is that type.
What I should to do or when you will produce patch!

 

[Marco Kalter]

Did you generate the package class, connected as SYS? If so, did you enable the "Prefix database objects with schema name" option in the Package Wizard? Otherwise the type owner will be omitted, and only SYS can use your package class.

------------------
Marco Kalter
Allround Automations