Pakai dbms_sql saja untuk execute nya
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of wawan mulyawan Sent: Friday, October 13, 2006 1:56 PM To: [email protected] Subject: [indo-oracle] Panggil sequence dengan variable Saya punya permasalahan mengenai sequence yang berbeda beda tapi ingin di panggil dalam satu prosedure.. Spesifikasinya seperti ini. Saya punya sequence untuk nomor urut transaksi, tetapi sequence itu untuk masih masing cabang Sample adalah nourut_100 untuk cabang 100 nourut_200 untuk cabang 200 dst dst bagai mana memanggil sequence tersebut dengan function database yang mem-passing kode kantornya.. misalnya function get_nourut(kdkntr number) nourut number; begin select nourut_???.nextval into nourut from dual; return(nourut); end; terima kasih atas bantuannya. Ti Mulyawan [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://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
