thx bung yulius..... On 2/9/07, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > Berikut contoh sederhananya ... > > SQL> CREATE OR REPLACE TYPE My_Collection_Type AS OBJECT ( > 2 field1 NUMBER, > 3 field2 VARCHAR2(50)); > 4 / > > Type created. > > SQL> CREATE OR REPLACE TYPE My_Collection AS TABLE OF > My_Collection_Type; > 2 / > > Type created. > > SQL> CREATE OR REPLACE FUNCTION test_rs > 2 RETURN My_Collection > 3 PIPELINED AS > 4 v_temp My_Collection_Type; > 5 BEGIN > 6 FOR i IN 1..10 LOOP > 7 v_temp := My_Collection_Type (i, 'Hello PL/SQL World'); > 8 PIPE ROW(v_temp); > 9 END LOOP; > 10 RETURN; > 11 END; > 12 / > > Function created. > > SQL> select * from TABLE(test_rs); > > FIELD1 FIELD2 > ---------- -------------------------------------------------- > 1 Hello PL/SQL World > 2 Hello PL/SQL World > 3 Hello PL/SQL World > 4 Hello PL/SQL World > 5 Hello PL/SQL World > 6 Hello PL/SQL World > 7 Hello PL/SQL World > 8 Hello PL/SQL World > 9 Hello PL/SQL World > 10 Hello PL/SQL World > > 10 rows selected. > > CMIIW, > > Bowo > > --- In [email protected] <indo-oracle%40yahoogroups.com>, "Agus > Rahmat" <[EMAIL PROTECTED]> > > wrote: > > > > temen2......ada yg bisa bantu saya kasih contoh script procedure yg > > menghasilkan recordset ?, kalo bisa procedure yg sederhana aja > tapi bisa di > > execute. > > > > > > thx, > > > > > > [Non-text portions of this message have been removed] > > > > >
[Non-text portions of this message have been removed]
