PL/SQL Tables of Objects

[RMB]

I used the Package Wizard to create a Delphi unit for use with Advanced Queuing (DBMS_AQ). I was pleasantly surprized with the results! (Great job on this tool!)

Now the bad news: A few of the PL/SQL records required by the AQ routines use PL/SQL tables of objects. I understand that the current version of DOA only supports PL/SQL tables of scalars. Is there a workaround for this problem? (I'm getting into some unknown territory here as far as my knowledge of PL/SQL, so any help will be greatly appreciated.)

thanks,
randy

 

[Marco Kalter]

The only workaround I can think of is to define a collection type (varray or nested table) for this object type, and to create a wrapper for the functions that take this PL/SQL Table as a parameter, using this newly defined collection type instead. Inside the wrapper function you copy the collection to a PL/SQL Table and call the actual AQ function.

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