Hi,This is Halim,working as a Sr. Oracle DBA and PL/SQL developer in Atlanta, USA. I very much like to play with SQL, PL/SQL and scripting languages along with my DBA job. I got a recognition for PL/SQL. Please see here at 16th position(http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html). I am maintaining this blog for helping myself while in work and sharing my knowledge with others. If you have any question. you can reach me at infohalimdba@gmail.com Thanks.

Friday, September 11, 2009

RANGE INPUT RESTRICTION

BEGIN FOR cur_r IN (SELECT frm_vin, to_vin FROM vin_upd WHERE gr_sub_cd = :BLOCK.gr_sub_cd) LOOP IF :BLOCK.frm_vin BETWEEN cur_r.frm_vin AND cur_r.to_vin OR :BLOCK.to_vin BETWEEN cur_r.frm_vin AND cur_r.to_vin THEN MESSAGE ('Invalid range'); RAISE form_application_error; END IF; END LOOP;END;