retry on PL.SQL question
- From: "Good, John" <John.Good@xxxxxxxxxxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 2 May 2008 11:18:59 -0400
Hello all,
The following was taken from the beginning of a procedure. It
defines the input and out parameters of the procedure. My question has
to do with the "as" clause. I am assuming that the entries following
the "as" statement are redefining the data or parameter out item
"o_v_err_msg". Can someone let me know if this assumption is correct or
not? If it isn't redefining the o_v_err_msg data element, what is it
doing?
(i_dt_report_date IN IT_TBL_T_CASH_TXNS.DATE_DRC%TYPE,
i_n_sysyear IN NUMBER,
o_n_return_value OUT NUMBER,
o_n_err_num OUT NUMBER,
o_v_err_msg OUT VARCHAR2)
AS
l_transaction_no IT_TBL_T_CASH_TXNS.TRANSACTION_NO%TYPE;
l_acct_no IT_TBL_T_CASH_TXNS.ACCT_NO%TYPE;
l_tax_yr IT_TBL_T_CASH_TXNS.TAX_YR%TYPE;
l_tax_period IT_TBL_T_CASH_TXNS.TAX_PERIOD%TYPE;
l_cont_exc_flag
IT_TBL_T_CASH_TXNS.CONTROLLERS_EXCEPTION_FLAG%TYPE;
l_source_of_txn IT_TBL_T_CASH_TXNS.SOURCE_OF_TRANSACTION%TYPE;
l_description IT_TBL_L_DEPOSIT_REPORT_DATA.DEPOSIT_DESCRIPTION%TYPE;
l_bank_acct_no IT_TBL_L_DEPOSIT_REPORT_DATA.BANK_ACCOUNT_NUMBER%TYPE;
l_good_amt IT_TBL_L_DEPOSIT_REPORT_DATA.TOTAL_GOOD_AMOUNT%TYPE;
l_resolved_amt IT_TBL_L_DEPOSIT_REPORT_DATA.RESOLVED_EXCEPTION_AMT%TYPE;
l_n_arb_account IT_TBL_L_DEPOSIT_REPORT_DATA.BANK_ACCOUNT_NUMBER%TYPE;
l_n_cshl_account
IT_TBL_L_DEPOSIT_REPORT_DATA.BANK_ACCOUNT_NUMBER%TYPE;
l_n_err_num Number;
l_v_err_msg Varchar2(255);
Thanks for any help you can give me. I wasn't able to find the
"as" cause in the various Oracle help pages I found on Google.
John
Other related posts:
