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" <[EMAIL PROTECTED]> 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 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/
