Patrick,
Oh, and take out this BEGIN and END marker, it's confusing the parser:
> begin
<snip>
> update ozpricing set useascurrprice = 0 where
> keyp_priceschedule = myRec.keyp_priceschedule;
> v_count = v_count + 1;
> end;
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
