Prinsipnya sederhana, yaitu menggunakan anonymous PL/SQL block sbg
string value-nya.
Contoh dgn menggunakan Incomplete (tanpa declare) Anonymous PL/SQL
Block:
BEGIN
stmt1;
stmt2;
proc1;
proc2;
END;
Jadi, anda bisa masukkan PL/SQL block tsb ke dalam execute immediate
BEGIN
EXECUTE IMMEDIATE
'BEGIN
stmt1;
stmt2;
proc1;
proc2;
END;'; -- end dari inner/string-ed PL/SQL block
END; -- end dari real PL/SQL
/
---------------
Contoh real di database saya
SQL> begin
2 execute immediate
3 'begin
4 test_sp1;
5 null;
6 null;
7 end;';
8* end;
SQL> /
PL/SQL procedure successfully completed.
Bowo
--- In [email protected], "Anang Rahmadyan" <[EMAIL PROTECTED]>
wrote:
>
> Ok pak juliun tanks berat. saya tadi juga coba dengan execute
immediate, hanya pada block Begin Proc End;
> jadi tidak ada ; setelah Proc dan end makanya seakan tidak bisa.
Thanks.
> ----- Original Message -----
> From: Yulius Wibowo
> To: [email protected]
> Sent: 17 February 2006 2:24
> Subject: [indo-oracle] Re: Running Procedure
>
>
> Coba didalam string, gunakan 'BEGIN proc_name;END;'
>
> Contoh:
> Saya menggunakan EXECUTE IMMEDIATE
> sebagai alternatif DBMS_SQL.
> EXECUTE IMMEDIATE mulai ada di 8i.
> Procedure yg dipanggil = test_sp
>
> SQL>begin
> 2 execute immediate 'begin test_sp;end;';
> 3* end;
> SQL> /
>
> PL/SQL procedure successfully completed.
>
>
> Bowo
>
>
> --- In [email protected], "Anang Rahmadyan" <anang@>
> wrote:
> >
> > Bapak-bapak yth
> > Ada yang bisa kasih saya contoh PL/SQL (Store Procedure) untuk
> Running Procedure atau package dengan string operation.
> > sebagai contoh pada package DBMS_SQL saya bisa ambil query
dari
> string value. (Dbms_SQL....'Select * from Table')
> > Tapi hal ini tidak berlaku apa bila kita hendak execute
> Procedure/Package.
> > Mohon penjelasannya.
> > Thanx
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
>
>
>
> SPONSORED LINKS Membership database software Database mortgage
software Pda database software
> Database management software Oracle database
administration Oracle database management
>
>
> -------------------------------------------------------------------
-----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "indo-oracle" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> -------------------------------------------------------------------
-----------
>
>
>
>
> -------------------------------------------------------------------
-----------
>
>
> ===================================================
>
> This Mail Scanned By Messaging Security Suite
>
> ================= Provided by IT Hardware =================
>
>
> [Non-text portions of this message have been removed]
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
