What are some of you doing to check that the number of rows inserted into a table matches the number of rows from the source file? Is there a standard? I am using the UTL_FILE package to read the file, parse the data and then call another procedure that just inserts the data to the corresponding table.
What I had in mind is to take the source file in unix and get a count on the number of lines of the file that I will load to the oracle table...then I will pass this value within the procedure that uses UTL package to load the source file to the database.....I am wondering....is there SIMPLER way? A log file?
if [ -s $ext_invoice ]; then
exinvcount=`wc -l < $ext_invoice`
cc_invoice_count=`$dblogin sqlplus $user/$pword@$dbase <<EOF
VARIABLE g_load NUMBER
set pagesize 0