Архив форумов ЦИТФорума

[mihhon]

hi, excuse me gor translit

Esli est' u kogo primer hranimoi procedury dlia Oracle (7.3, , kotoraia vozvrashaet Result Set, a ne prosto chto-to cherez parametr IN OUT, prishlite, pozhaluista, na mihhon2000@hotmail.com

zaranee blagodaren

[Бабичев Николай]

CREATE OR REPLACE PACKAGE CopyFast As
TYPE StudentArray IS
TABLE OF students%ROWTYPE;

PROCEDURE PassStudents1(p_Parameter1 IN
OUT StudentArray);
PROCEDURE Go;
END CopyFast;

CREATE OR REPLACE PACKAGE BODY CopyFast
PROCEDURE Go IS
v_StudentArray StudentArray :=
StudentArray(NULL);
BEGIN
SELECT *
INTO v_StudentArray
FROM students
WHERE ID BETWEEN 10007 AND 10027
PassStudents1(v_StudentArray);
.....

//Таким образом в качестве параметра мы передаем массив - процедура вернет набор строк

Николай, bazzman@rass.ru