The next step in OLE DB Connection Manager, pick out the Oracle Connection.

In Data Access mode: Choose SQL Command from variable

In Variable Name: Pick out the variable for the whole query.