What's the problem? Is it that you don't have access to the underlying database objects and thus cannot generate the plans? If so, look in the raw trace files. You'll see the plans right there on the lines beginning with "STAT" (from 7.3.4 onwards).

Could you tell me how to run explain plan and sql_trace for stored procedures.