melanjutkan saja, bisa begini:
create Procedure A(var1 as Number, result int out sys_refcursor) is
Begin
open result for
'Select Nama,Nik From Karyawan Where Nik=' || @var1
End;
kalo nanti procedure nya di panggil, maka fetch aja cursor resultnya.
contoh eksekusi dari SQL plus:
declare
result sys_refcursor;
var_nama number;
var_nik char(10);
nik_yang_dicari number;
begin
a(nik_yang_dicari,result);
loop
fetch result into var_nama,var_nik;
exit when result%notfound;
dbms_output.put_line(var_nama || ' ' || var_nik);
end loop;
end;
On Sat, Dec 12, 2009 at 7:12 AM, <[email protected]> wrote:
> Hampir sama cuma dia ga bisa hanya select aja harus masukin ke table
> tujuan.
>
> Regards,
>
> Febry kurniawan
> Sent from my BlackBerry®
> powered by Sinyal Kuat INDOSAT
>
> -----Original Message-----
> From: oracle-db-l <[email protected]>
> Date: Fri, 11 Dec 2009 10:24:50
> To: <[email protected]>
> Subject: [indo-oracle] Select di Store procedure Oracle
>
> Dear Rekan2
>
> Kalau di Sql Server storeprocedure untuk select (Query) seperti ini :
>
> Procedure A(@var1 as Numeric,Var2 As Char(10))
> Begin
> Select Nama,Nik From Karyawan Where n...@var1
> End;
>
> Nah Kalau di Oracle Gimana ya ?
>
> Thanks bangat ni bantuannya
>
> Tq
> Ismail
>
>
>
>
>
>
>
>
>
> Selalu bersama teman-teman di Yahoo! Messenger. Tambahkan mereka dari
> email atau jaringan sosial Anda sekarang!
> http://id.messenger.yahoo.com/invite/
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [email protected]
> Website: http://indooracle.wordpress.com
> http://www.facebook.com/group.php?gid=51973053515
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.comYahoo! Groups Links
>
>
>
>
--
Warm regards,
Rudy Wardhany
Yahoo ID: [email protected]
[Non-text portions of this message have been removed]
