Collections

Hi,

Can you call a procedure from SQLPLUS that takes a collection as input?

INSERT_PORTFOLIO_ARR (

  p_customer_id    NUMBER,
  p_price          IN_ARR,
  p_shares       IN_ARR,
  p_date           IN_ARR,
  p_product      VARCHAR2 DEFAULT NULL)

IN_ARR is defined as:

CREATE OR REPLACE TYPE "IN_ARR"
AS VARRAY (100) OF VARCHAR2(100) Not sure how to do that. I'm looking around for some examples, but has anyone ever attempted this?

Many thanks! Received on Wed Feb 03 2010 - 15:26:26 CST