# SQL Navigator supports PL/ SQL Oracle Collections. i.e type & tab

**URL:** <https://forums.toadworld.com/t/sql-navigator-supports-pl-sql-oracle-collections-i-e-type-tab/4455>\
**Category:** SQL Navigator\
**Created:** [May 18, 2011, 5:33pm UTC](https://forums.toadworld.com/t/sql-navigator-supports-pl-sql-oracle-collections-i-e-type-tab/4455 "2011-05-18T17:33:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![balaji](https://avatars.discourse-cdn.com/v4/letter/b/2bfe46/32.png) [@balaji](https://forums.toadworld.com/u/balaji)\
**Post date:** [May 18, 2011, 5:33pm UTC](https://forums.toadworld.com/t/sql-navigator-supports-pl-sql-oracle-collections-i-e-type-tab/4455/1 "2011-05-18T17:33:47Z")

</div>

i\_c user\_tab :=user\_tab();

get\_user (

i\_c =\> i\_c,  
i\_by =\> i\_by

);

Please advise me , how to execute this SP, Does SQL Navigator supports ORACLE COLLECTIONS,

SQL Navigator supports Oracle Collections. i.e type & tab

I would like to execute PL/SQL procedure , which has tab as input . For example

i\_by by\_type := by\_type( ‘a’, ‘b’, ‘c’ );

---

<div class="post-metadata">

**Author:** ![roman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/roman/32/65_2.png) [@roman](https://forums.toadworld.com/u/roman)\
**Post date:** [May 20, 2011, 3:15am UTC](https://forums.toadworld.com/t/sql-navigator-supports-pl-sql-oracle-collections-i-e-type-tab/4455/2 "2011-05-20T03:15:10Z")

</div>

Hi,

Unfortunately, SQL Navigator doesn’t support input parameters of collection types. If you try to run your procedure (get\_user), instead you will see a generated anonymous block, with no parameters assigned; you’ll have to assign their values manually (similarly to the example you gave us) and then press F9 again to run it. However, you CAN browse OUT parameters of collection types after you run a procedure.

Hope this helps,  
Roman
