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

UWI                  INDEX_NUMBER REPORT_NAME                                   
-------------------- ------------ --------------------------------------------- 
552310000500                  467 BIOSTRATIGRAPHIC REPORT                       
552310000500                  467 CHECKSHOT SURVEY                              
552310000500                  467 GEOCHEMICAL REPORT                            
552310000500                  467 OPERATIONS REPORT                             
552310000500                  467 SIDEWALL CORE REPORT                          
552310000500                      TAPE VERIFICATION LISTING                     
552310000500                  467 WELL COMPLETION REPORT                        
552310000500                  467 WELL SUMMARY                                  

8 rows selected.


SQL> spool off
