Bash function that executes Oracle SQL and builds URL and opens it with chrome

gistfile1.txt

function report
{
    num="$1"
    chrome $(sqlplus -S username/password@connect_identifier <<EOF
set echo off
set verify off
set timing off
set heading off
set feedback off
set linesize 32767
set pagesize 0
select 'http://web.xyz.com/data/' || vin
from automobile_data 
where license_number = '$num';
exit
EOF
)
}