Oracle - Crystal Variables

New to Oracle. Using Crytsal 10. Unable to create views or Stored Proc on database. Having to just use SQL code in Crystal. Need to know how to pass variables from Crystal to the SQL code that will run on Oracle DB. Also can I create a temp table and use in the SQL Code. Thank you for the help. David

I do not have privilege to create any object in the DB. It's hosted by a 3rd party so we just run our reports off their Oracle Data. Using Crystal Reports version 10 to create reports. We were using SQL Servers but switched to Oracle. Some of our SQL Code written for SQL server does not work with Oracle. Creating temp tables and passing variables is one of the parts that does not work now that we are using Oracle. David

Sorry, but I don't understand your question. I just want to pass in a variable that will return only one records from a table that the ID matches what the variable is. In this care the results one be one records for Facility ID = 4