hi, minta bantuannya dong.
masalahnya:
saya buat stored procedure
create or replace type NUM_ARRAY as table of number;
create or replace
procedure give_me_an_array( p_array in num_array )
as
begin
for i in 1 .. p_array.count
loop
dbms_output.put_line( p_array(i) );
end loop;
end;
/
exec give_me_an_array('1,1,1');
exec give_me_an_array('[1,1,1]');
exec give_me_an_array('{1,1,1}');
exec give_me_an_array('<1,1,1>');
exec give_me_an_array('(1,1,1)');
dicoba dengan cara di atas untuk manggil procedure itu tapi gak
jalan dengan error:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of
arguments in call to 'GIVE_ME_AN_ARRAY' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
thaanks.