what is dynamic sql? what is different than sql? tank you selim turkey istanbul
ary nur <[EMAIL PROTECTED]> wrote: Pak Kiki, Perintah 'EXECUTE IMMEDIATE ' dijalankan dimana ? Di dalam Oracle database atau di Forms6i ? arynur On Thu, 3 Mar 2005 09:47:07 +0700, Kiki Kuswara <[EMAIL PROTECTED]> wrote: > > Milister, > > Saya sdh coba connect dengan menggunakan sys tapi sekarang errornya not > privilege, saya sdh coba juga memberikan grant object table tersebut ke sys, > tapi masih tetap error seperti diatas, saya beranggapan mungkin ada bug di > developer 6i atau harus di patch dulu, tapi itu tidak masalah, saya sdh coba > dengan menggunakan package dbms_sql dan berhasil, terimakasih buat Pak Ino > atas bantuannya, serta terimakasih untuk para milister. > > Terimakasih, > Kiki Kuswara > > ----- Original Message ----- > From: "Ino Kenichi" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, March 02, 2005 2:02 PM > Subject: Re: [indo-oracle] Re: Dynamic SQL > > > > > setahu saya execute immediate itu user yang mengeksekusi harus SYS deh, > > selain itu ga bisa. > > coba anda login sebagai SYS bisa ga > > > > regards > > > > ino > > > > > > On Wed, 2 Mar 2005 11:55:38 +0700, Kiki Kuswara <[EMAIL PROTECTED]> > wrote: > > > > > > Tujuan saya, saya mau query table supaya bisa di schema mana saja, tapi > > > procedure di simpan di schema tools(bukan database built in tapi di buat > > > sendiri oleh saya namanya Ow_Tools), saya sdh coba connect dengan > ow_tools, > > > dan menjalan procedurenya, tapi masih tetap error, dan kalau masih tetap > > > tidak bisa, saya akan coba pakai package dbms_sql, tapi sih kalau bisa, > saya > > > mau pakai execute immediate biar lebih native dan kata dokumentasinya > > > perfomancenya lebih bagus dari dbms_sql (kalau ngak salah), terimakasih > buat > > > Pak Ade Yoel atas bantuannya. > > > > > > Regards, > > > Kiki Kuswara > > > > > > ----- Original Message ----- > > > From: "Yoel Ade" <[EMAIL PROTECTED]> > > > To: <[email protected]> > > > Sent: Tuesday, March 01, 2005 5:07 PM > > > Subject: [indo-oracle] Re: Dynamic SQL > > > > > > > > > > > > > > > bisa coba create procedure itu di schema tools > > > > (karena tablenya di schema tools ya) > > > > kemudian execute dgn user Tools.. > > > > test apakah tetap bermasalah > > > > > > > > thanks > > > > > > > > --- In [email protected], "Kiki Kuswara" <[EMAIL PROTECTED]> > > > > wrote: > > > > > Saya sudah coba juga dibuatkan public synonymnya, tapi masih tetap > > > > saja. > > > > > errornya masih table atau view tdk ketemu, tetapi begitu saya > > > > select pakai > > > > > sql plus, atau toad atau lewat post query dengan user tersebut. > > > > ternyata > > > > > bisa tapi kalau dengan prosedur native dynamic sql tidak bisa yang > > > > error > > > > > table atau view tidak ada. > > > > > > > > > > Terimakasih, > > > > > Kiki Kuswara > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: "ahendi_elien" <[EMAIL PROTECTED]> > > > > > To: <[email protected]> > > > > > Sent: Tuesday, March 01, 2005 10:38 AM > > > > > Subject: [indo-oracle] Re: Dynamic SQL > > > > > > > > > > > > > > > > > > > > > > > > > > > > apakah tabel yang mau di share dari schema lain itu ssudah di > > > > buatkan > > > > > > public synonym? > > > > > > > > > > > > kalo belum coba bikin public synonym > > > > > > > > > > > > > > > > > > mudah2an solved > > > > > > > > > > > > > > > > > > --- In [email protected], "Kiki Kuswara" <[EMAIL > > > > > > PROTECTED]> > > > > wrote: > > > > > > > Dear Milister, > > > > > > > > > > > > > > Setelah saya rubah ternyata masih belum solved, system > > > > kelihatannya > > > > > > mencari > > > > > > > table yang di parse lewat execute immediate tetapi table > > > > tersebut > > > > > > tidak ada > > > > > > > atau masalah privilege, saya telah cek privilege atau trusty, > > > > untuk > > > > > > user > > > > > > > tersebut (execute procedure) dan semuanya sudah lengkap karena > > > > untuk > > > > > > > sementara, user tersebut saya beri grant DBA, Mungkin diantara > > > > para > > > > > > milister > > > > > > > dan sesepuh oracle ya ada yang pernah mengalami seperti saya, > > > > saya > > > > > > mohon > > > > > > > sharingnya. > > > > > > > > > > > > > > Nb: Database Server 9i R2, Developer 6i, Base Windows, procedure > > > > > > disimpan di > > > > > > > program unit level database > > > > > > > > > > > > > > Regard, > > > > > > > Kiki Kuswara > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > > From: "ary nur" <[EMAIL PROTECTED]> > > > > > > > To: <[email protected]> > > > > > > > Sent: Monday, February 28, 2005 10:33 AM > > > > > > > Subject: Re: [indo-oracle] Dynamic SQL > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Mon, 28 Feb 2005 09:42:40 +0700, Kiki Kuswara <[EMAIL > > > > > > > > PROTECTED]> > > > > > > > wrote: > > > > > > > > > > > > > > > > > > Dear Milister, > > > > > > > > > > > > > > > > > > Saya sedang mencoba menggunakan dynamic SQL, tetapi ketika > > > > saya > > > > > > > jalankan, terjadi error bahwa table atau view tidak di > > > > ketemukan, > > > > > > saya sdh > > > > > > > lihat grant yang diberikan sudah lengkap, serta table yang saya > > > > mau > > > > > > coba > > > > > > > select sudah berikut dengan nama schemanya, dibawah ini saya > > > > > > sertakan contoh > > > > > > > procedurenya mungkin antara milister atau pakar2, ada yang > > > > pernah > > > > > > mengalami > > > > > > > seperti saya, saya berharap sekali atas bantuan, Atas bantuan > > > > dan > > > > > > juga > > > > > > > sharingnya saya ucapkan terimakasih. > > > > > > > > > > > > > > > > > > Salam, > > > > > > > > > > > > > > > > > > Kiki Kuswara > > > > > > > > > > > > > > > > > > Procedure List_approval(cKey In VarChar2, cField_A Out > > > > VarChar2, > > > > > > > > > cField_b Out VarChar2, cField_c Out > > > > > > VarChar2) > > > > > > > > > DECLARE > > > > > > > > > sql_stmt VARCHAR2(1000); > > > > > > > > > BEGIN > > > > > > > > > sql_stmt := 'SELECT Field_A,Field_b,Field_c > > > > > > > > > FROM Tools.Approval > > > > > > > > > WHERE Key_App = :1'; > > > > > > > > > EXECUTE IMMEDIATE sql_stmt INTO cField_A, cField_b, > > > > cField_c > > > > > > USING > > > > > > > cKey; > > > > > > > > > END; > > > > > > > > > > > > > > > > > > > > > > > > > Kalau diubah seperti ini bagaimana : > > > > > > > > > > > > > > > > ========================================================== > > > > > > > > > > > > > > > > Procedure List_approval(cKey In VarChar2, > > > > > > > > cField_A Out VarChar2, > > > > > > > > cField_b Out VarChar2, > > > > > > > > cField_c Out VarChar2 ) > > > > > > > > IS > > > > > > > > sql_stmt VARCHAR2(1000); > > > > > > > > BEGIN > > > > > > > > sql_stmt := 'SELECT Field_A,Field_b,Field_c > > > > > > > > FROM Tools.Approval > > > > > > > > WHERE Key_App = :1'; > > > > > > > > EXECUTE IMMEDIATE sql_stmt INTO cField_A, cField_b, > > > > cField_c > > > > > > USING > > > > > > > cKey; > > > > > > > > END; > > > > > > > > > > > > > > > > ===================================================== > > > > > > > > arynur > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > > > > > Keluar: [EMAIL PROTECTED] > > > > > > > > Website: http://indo-oracle.blogspot.com > > > > > > > > ----------------------------------------------- > > > > > > > > > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > > > > > http://indo-thin.vze.com > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > > > Keluar: [EMAIL PROTECTED] > > > > > > Website: http://indo-oracle.blogspot.com > > > > > > ----------------------------------------------- > > > > > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > > > http://indo-thin.vze.com > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > Keluar: [EMAIL PROTECTED] > > > > Website: http://indo-oracle.blogspot.com > > > > ----------------------------------------------- > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > http://indo-thin.vze.com > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: [EMAIL PROTECTED] > > > Website: http://indo-oracle.blogspot.com > > > ----------------------------------------------- > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > http://indo-thin.vze.com > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.blogspot.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups SponsorADVERTISEMENT --------------------------------- 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 the Yahoo! Terms of Service. http://selimsaray.tripod.com/ The information contained in this message may be confidential and/or legally privileged. --------------------------------- Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web [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 ----------------------------------------------- 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/
