|
|
[ÀϹÝ] [sp] ÇÁ·Î½ÃÁ®¿¡¼ ³ª¿Â Äõ¸®°á°ú¸¦ ¸®ÅÏÇÑ´Ù. |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:3575 |
|
|
1. ÅÛÇÁÅ×À̺íÀ» »ç¿ëÇÑ´Ù.
Create Global Temporary table t_test
(
Ä÷³ ¸ñ·Ï
)
on commit delete rows;
ÀÌ·± ½ÄÀ¸·Î ÀÓ½ÃÅ×À̺íÀ» ¸¸µé¾î¼ °¡°øÈÄ ÀÌ Å×ÀÌºí¿¡¼ select Çؼ Ä¿¼¸¦ ±¸¼ºÇÏ½Ã¸é µË´Ï´Ù.
2. object ŸÀÔ »ý¼º ¹× table ŸÀÔÀ» ÅëÇØ Ä¿¼ ÀÛ¾÷ÀÌ °¡´ÉÇÕ´Ï´Ù.
¿¹¸¦ µé¾î
Create Or Replace Type t_rec as object
(
owner varchar2(30),
object_type varchar2(18),
object_id number
)
/
ÀÌ·± object ŸÀÔÀ» ¸¸µé°í
ÀÌ Å¸ÀÔÀ» »ç¿ëÇÏ¿©
Create Or Replace Type at_rec as table of t_rec
/
ÀÌ·± Å×À̺í ŸÀÔÀ» ¸¸µé°í
create or replace package pk_pkg
is
type t_ref_cursor is ref cursor;
procedure sp_test(vcur out t_ref_cursor);
end;
/
create or replace package body pk_pkg
is
procedure sp_test(vcur out t_ref_cursor)
is
l_rec at_rec;
begin
l_rec(l_rec.count + 1) := t_rec('KHS','FUNCTION',10);
open vcur for select * from table(l_rec);
end;
end;
/
ÀÌ·± ½ÄÀ¸·Î ¾²½Ç ¼ö ÀÖ½À´Ï´Ù.
|
|
|
|