I been googling a good chunk of the day looking for any kind of examples on ... an invalid character oracle error, which it's complain about the percent sign being in the query.

If your business has an Oracle database you can create a process called a query to extract data to Excel ... "Application Development." Start the "SQL Plus" program by clicking on it.