**LLBLGen Version: **3.1 Final Database: Oracle 10g .NET Version: 4.0 **Template: **Adapter Framework: LLBLGen Pro Runtime Framework

Hello,

I am curious if LLBLGen Pro 3.1 as support for Associative Arrays (or index-by table) as stored procedure parameters.

I created a test LLBLGen project and imported a procedure that had an Associative Array as an out parameter, and when I tried to import into my LLBLGen project, it did not display in my list of procedures associated with the Relational Data Model. There was no error, just the procedure I selected didn't show up after retrieving the data from Oracle.

Here is the package code for the procedure I am trying to import:

CREATE OR REPLACE 
PACKAGE TEST_COLLECTION AS 

  type error_collection_idxtbl is table of varchar2(4000) index by Binary_integer;

  procedure test_collection_types(arg_idxtbl out error_collection_idxtbl);

END TEST_COLLECTION;

CREATE OR REPLACE
PACKAGE BODY TEST_COLLECTION AS

  procedure test_collection_types(arg_idxtbl out error_collection_idxtbl) as
  l_count number := 1;

  BEGIN
    for row in (select shared.shr_log4net.log_message from shared.shr_log4net where rownum < 4)
    loop
      arg_idxtbl(l_count):= row.log_message;   
      l_count := l_count + 1;
    end loop;
  END test_collection_types;

END TEST_COLLECTION;

Thanks, Shaun

No, at the moment array based parameters aren't supported. We do have it on our todo list, but not with a high priority.