Quote:
Originally Posted by krizzie khonnie
Hi,
Yes. For example I want to validate each field if its NULL,If yes then there will be an error. I just placed an example on how the fields would look like in the forms. There were three fields, and each field has 3 records, now lets pretend there is a submit button under those fields. Once I hit that button the validation will take place. I planned to use a package. That package will be responsible in checking each field if its a null or not. My problem is I don't know how to create a package that will validate each field? Do I need to use a loop? A pl/sql nested table? a varray? I don't have any idea. Using a varray will limit me to a number of records? right? then if that is the case, then I can't use varray since the number of records in each field is not constant.
Please help. You're idea would on how to handle this would be very helful to the forms I'm creating.
Thanks a lot.
how are you selecting the values for each field?using a single query or 3 seperate query??
one best way is to use the condion in the query itself...for NULLS.
SOmething like WHERE column_name IS NOT NULL
