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
<*> 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/
