Date: Wed, 3 Feb 2010 13:26:26 -0800 (PST)
Can you call a procedure from SQLPLUS that takes a collection as input?
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