Mike wrote:
> Hi,
>
> I have a requirement.I have some values in table xx_payments.Taking
> those values from xx_paymentsI need to run a procedure bmf_insert.
> This procedure bmf_insert updates a table called bmf which also has a
> field tracking_id.I'll also have to update the same tracking_id in
> xx_payments table as
> well so that if the tracking_id exists in xx_payments already then
> running the procedure again should result in a error.
> Can someone help me write the pl/sql block with the above
> requirements.
> I have attached the code written.Can someone modify it for me?
>
> TIA
> Mike
>
>
>
> DECLARE
> l_max_no NUMBER;
> BEGIN --{
> BEGIN --{
> SELECT MAX(seq_num) INTO l_max_no
> FROM seq_num
> WHERE table_name='BMF_TABLE'
> ;
> EXCEPTION
> WHEN NO_DATA_FOUND THEN
> l_max_no := 0;
> WHEN OTHERS THEN
> l_max_no := 0;
> END; --}
> FOR cx IN
> (SELECT col1, col2 , col3
> FROM xx_payments
> WHERE condition
> )
> LOOP --{
> BEGIN --{
> execute bmf_insert(values,l_max_no)
> ;
> EXCEPTION
> WHEN DUP_VAL_ON_INDEX THEN
> do_reqd_taks
> WHEN OTHERS THEN
> do_reqd_taks;
> END; --}
> END LOOP; --}
> END; --}
Where are you going to school
and what is the email address of the instructor?
Received on Sat Apr 12 2003 - 08:47:20 CDT
