"So if the insert transaction completes after the full backup is complete, how many rows where inserted till the backup gets completed will be included in the backup."

Shocking use of...

Hasn't anyone here (or who read the Oracle magazine) heard of correlated sub-queries?

select aField from aTable t1

where 2 = (select count(*) from aTable t2

where t2.aField > t1.aField)

>Did you remember to specify the output parameter as an output?:

Well - I wouldn't be getting the correct (non-NULL) values returned in QA if it wasn't, would I?

>exec proc_name @output_Param...