Have you tried running the command from sqlplus or something other than the web app? Maybe you can get more information on why it's hanging. Try using explain plan to see the steps it's taking.

I haven't used intermedia a lot yet but do have it installed, once I get some time I'll run some test queries and see what I can find out.