Explain Plan with Alter current_schema

[Jerry Bull]

I have setup an AfterConnect.sql file to contain the command 'alter session set current_schema='.

This works great for normal sql windows where I log in as my personal user id and reference objects defined by the generic user. However, when I select a statement and try to get an explain plan I just get an empty explain plan (no error, just the statement in the upper section and a completely blank plan). If I delete the AfterConnect.sql file and restart pl/sql developer, now the explain plan works except I need to prefix each table with the owner of the table.

How do we get the explain plan tool to recognize the current_schema and still give an explain plan?

 

[Marco Kalter]

This does indeed not work, no matter where the plan_table is defined. My guess is that the plan_table query that is used by the Plan Window is not working correctly for different current_schema's. We'll fix it.