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], "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]
>
