Dear All
I have like this scenario
create table test_Data (name varchar2(500));
-- procedure
CREATE OR REPLACE PROCEDURE test_array(
p IN dbms_sql.varchar2_table )
AS
BEGIN
FOR i IN p.FIRST .. p.LAST
LOOP
insert into test_Data values(p(i));
END LOOP;
commit;
END test_array;
/
I need to call test_array procedure by a simple way like this
begin
test_array('a','b','c','d');
end;
thanks in advance