Perhaps I misunderstand. What sort of procedure, stored procedure?
I don't think of dragging stored procedures to the report, but selecting them like you would a table from your connection.
If this is what you are doing, I would take a look at the stored proc and see if how it works.
while I haven't used Oracle, I have used stored proc through both OLE and ODBC drivers for years on CR.
HTH