In Excel, I'm trying to create an OLE DB type QueryTable to an Oracle
database.
I've tried from the Data | Get External Data menu and I've tried creating it
programatically.

I can do that OK and it returns data as it should, but I'm unable to use
parameters. It throws an error.

My query is:
select * from my_table where my_id = ?

If I change the connection to ODBC, then it works fine.

Is someone else out there running Excel 2002 and Oracle able to give it a go
and confirm it's a bug or that I'm just plain doin' it wrong?

Thanks