2008/10/15 haryanto80_lee <[EMAIL PROTECTED]>

>   Coba aja script ini
>
> DECLARE
> CURSOR REPET IS
> SELECT ACCNAME,DEBIT FROM ACCS WHERE ACCNAME='PTA';
> X_ACCNAME VARCHAR2(10);
> X_DEBIT NUMBER;
> X_I NUMBER;
> BEGIN
> OPEN REPET;
>
> LOOP
> FETCH REPET INTO X_aCCNAME,X_DEBIT;
> FOR X_I IN 1..X_DEBIT-1
> LOOP
> DBMS_OUTPUT.PUT_LINE (X_aCCNAME);
> END LOOP;
>
> EXIT WHEN REPET%NOTFOUND;
> END LOOP;
> END;
>
> ---
>


Tidak ada error, namun query tidak muncul hasilnya..


-- 
YM_id : muh_ilman_a
http://misisawa.blogspot.com
http://anrof.myminicity.com/


[Non-text portions of this message have been removed]

Kirim email ke