aku juga pengin tahu nich...
----- Original Message -----
From: "BONY IRAWAN" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, April 11, 2006 7:33 PM
Subject: [indo-oracle] hasil query dg procedure tidak sama (URGENT)
> haloooo rekan2, saya ada masalah yang bagi saya (yang awam) rada aneh
> yaitu ketika saya menjalankan query di SQL editor dan saya menjalankan
> query yang sama di dalam store procedure hasilnya berbeda.
> Store procedure-nya seperti ini :
>
> PROCEDURE OUTBOUND_CALL(areacode VARCHAR2,Divre VARCHAR2,SESSION_USERID
> VARCHAR2,Result OUT cursor_type) AS
> v_jMDN1 NUMBER(2);
> v_jTUGAS NUMBER:=11;
>
> BEGIN
> -- jumlah daftar telepon yang harus dikerjakan (B)
> DBMS_OUTPUT.PUT_LINE('MULAI1');
> SELECT count(DISTINCT A.MDN) INTO v_jMDN1
> FROM OUTBOUND_CALL_LIST A,
> X_DUMMY B
> WHERE PETUGAS IS NULL
> AND SUBSTR(MDN,1,LENGTH(areacode)) = areacode
> AND B.XS1 = 'AREACODE'
> AND SUBSTR(B.xs4,3,1) = Divre
> AND B.XS3 = SUBSTR(MDN,1,LENGTH(areacode))
> AND ROWNUM < v_jTUGAS;
> exception
> when others then
> dbms_output.put_line(sqlerrm());
> DBMS_OUTPUT.PUT_LINE('MULAI2 '||v_jMDN1);
> END;
>
> ketika query yg bercetak tebal saya running di SQL editor hasilnya 10.
>
> ketika saya jalankan procedure diatas (procedure di dalam
> package=OUTBOUND) dgn sintak spt ini :
>
> declare
> j outbound.Cursor_type;
> begin
> outbound.OUTBOUND_CALL('022','3','BONY',j);
> end;
>
> hasil pada variable v_jMDN1 = 0
>
> catatan: parameter yg digunakan sama persis
>
> terima kasih atas bantuannya
>
>
> BONY
>
>
>
>
>
> ---------------------------------
> New Yahoo! Messenger with Voice. Call regular phones from your PC and save
> big.
>
> [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
>
>
>
>
>
>
>
--
-----------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/
