I try to create a procedure that produces 3 output files:
file_handleQ := utl_file.fopen('H_RESOURE',outfilenameQ,'w');
file_handleA := utl_file.fopen('H_RESOURE',outfilenameA,'w');
file_handleR := utl_file.fopen('H_RESOURE'',outfilenameR,'w');
These 3 output files are identical except the ‘location’:
When ‘outfilenameQ’ location = 1
and I need to update table H_Resource, set HR = ‘y’
When ‘outfilenameA’ location = 2
When ‘outfilenameR’ location = 3
Would you please to show me the way I can write one procedure to produce 3 output files instead of writing 3 procedures.
Your answer is appreciated and waited for.