rekan-rekan,
Mohon bantuan ttg masalah berikut ini :
Masalahnya :Stored Proc tidak mengembalikan value yg ke powerbuilder
Meski sudah pake OUT parameter
Keterangan rinci sbb :
Saya membuat Stored proc di ORacle 8i dgn OUT parameter sbb :
CREATE OR REPLACE PROCEDURE GET_DUE_SCRIPT_VAL
(p_exch_date in date,
p_client_cd in varchar2,
p_stk_cd in varchar2,
p_mrkt_type in varchar2,
p_trans_type in varchar2,
p_due_script OUT date,
p_due_value OUT date,
p_brokerg_pct OUT number)
di N_TR declaration sbb :
subroutine GET_DUE_SCRIPT_VAL
(date P_EXCH_DATE, &
string P_CLIENT_CD, &
string P_STK_CD, &
string P_MRKT_TYPE, &
string P_TRANS_TYPE, &
REF date P_DUE_SCRIPT, &
REF date P_DUE_VAL, &
REF decimal P_BROKERG_PCT &
) RPCFUNC ALIAS FOR "GET_DUE_SCRIPT_VAL"
di Window, scriptnya sbb :
decimal ld_brokerg_pct
string ls_client_cd, ls_stk_cd, ls_mrkt_type, ls_trans_type
date ldt_exch_date
date ldt_due_script, ldt_due_val
.. harga IN parameter diisi disini
..
// SP diexecute :
SQLCA.GET_DUE_SCRIPT_VAL(ldt_exch_date, ls_client_cd, ls_stk_cd,
ls_mrkt_type, 'P', ldt_due_script, ldt_due_val, ld_brokerg_pct)
// setelahnya, variabl ldt_due_script, ldt_due_val, tetap NULL
SPnya sudah saya run dari Toad, tidak masalah.
salam n trimakasih
susanti
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/NhFolB/TM
--------------------------------------------------------------------~->
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> 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/
