old   1: select * from ak.MMS_WELL_REPORTS where uwi = '&api_well_number'
new   1: select * from ak.MMS_WELL_REPORTS where uwi = '552310000400'

UWI                  INDEX_NUMBER REPORT_NAME                                   
-------------------- ------------ --------------------------------------------- 
552310000400                      BIOSTRATIGRAPHIC REPORT                       
552310000400                  362 CHECKSHOT SURVEY                              
552310000400                  362 DIRECTIONAL SURVEY                            
552310000400                  362 DRILL STEM TEST                               
552310000400                  362 DRILLING REPORT                               
552310000400                  362 GEOCHEMICAL REPORT                            
552310000400                  362 OPERATIONS REPORT                             
552310000400                  362 PERMIT TO DRILL                               
552310000400                  362 SIDEWALL CORE REPORT                          
552310000400                  362 WATER SAMPLE ANALYSIS REPORT                  
552310000400                  362 WELL COMPLETION REPORT                        

11 rows selected.

SQL> spool off
