Package Wizard and dbms_aq.message_properties_t

[genetics]

Hello To All !!!

I'm using greate tool: Package Wizard.
And I'm also using AQ mechanism from Oracle (8.1.7... in future 9) but....
there is one problem.
I have one proc in my package where I have defined parameter OUT:
MSG_PROP OIUT dbms_aq.message_properties_t
and it doesn't work! I can't call this proc!!!
There is problem with one property of that structure: AQ$_AGENT...
Is this a BUG? When it will be fixed? How to solve this problem quickly?

Regards
Lukasz Zeligowski

------------------

 

[Marco Kalter]

What exactly is the problem?

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

 

[genetics]

Originally posted by mkalter:
What exactly is the problem?

Simple package procedure definition:
PROCEDURE DequeueRecord2(
piNavigation IN BINARY_INTEGER,
poMsg OUT TF2MRecord,
poMsgProp OUT dbms_aq.message_properties_t,
pRESULT OUT NUMBER);

Wizard is creating also type:
DbmsAqMessagePropertiesT (it could be usefull to give the posibility to add T on the beginning).

When I'm calling that procedure exception occurs when in internal part of package object (still Delphi) delphi tries to create DbmsAqMessagePropertiesT object.
There is a constructor
// DbmsAqMessagePropertiesT object (dbms_aq.message_properties_t)
constructor DbmsAqMessagePropertiesT.Create(ASession: TOracleSession);
begin
inherited;
RecipientList := TPLSQLTable.Create(DefaultPLSQLTableSize, 0);
SenderId := TOracleObject.Create(ASession, '"AQ$_AGENT"', '');
end;

Exception occurs when program is trying to execute line: SenderId:=....
Error is:
ORA-24372: invalid object for describe.

The problem is not in the body of procedure - it happens BEFORE true call.

Please solve this!!!!

Best regards (and TIA)
Lukasz Zeligowski

 

[genetics]

I forgot write that when I create the same procedure and change (make some conversion) that problematic type to diffrent one (without senderId field) than everything is Ok.

B.R.
Lukasz Z.