plsql - Oracle equivalent of Java's Varargs -


i'm trying create pl/sql procedure can handle unknown, relatively small, number of strings/varchar2s parameter. equivalent in java use varargs:

public void foo(string... bar) { } 

looking @ oracle's documentation on collections , records seem using associative array suitable choice, i'm not certain.

can please tell me if associative array correct way go?

if it's possible pass in anonymous associative array when invoking call procedure?

thanks

create or replace type strings_type table of varchar2(50); select * table (strings_type ('dd','cc','ee')); 

Comments

Popular posts from this blog

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

javascript - firefox memory leak -

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -