OWS21 and weird grant exec problem
From: Rashid Karimov <rashid_at_rk.wbs.com>
Date: 1996/12/10
Message-ID: <58img7$k5p_at_nnrp1.farm.idt.net>#1/1
Date: 1996/12/10
Message-ID: <58img7$k5p_at_nnrp1.farm.idt.net>#1/1
[Quoted] When I create a stored procedure as www_dba and do grant execute on it to other person, who also has valid DCD setup , for some reason when I access it, the procedure does fire up and completes succesfully ( checked from sqlplus), but does NOT produce anything - no HTML seen from the browser , nothing shows up after set serveroutput on exec procedure owa_util.showpage while in sqlplus It does work OK from DCD of( OWS21) and by original owner(sqlplus) of the procedure. If after create the same procedure using the very same source code as the _other person - it works fine. I don't quite think it's Web Server's problem per se, since it doesn't work from sqlplus either. I see the regular "succesful completion " messages in all cases. Any idea what's going on ? E-mail copy of reply if any'd be greatly appreciated. Rashid. -- ------------------ Beyond the horizon of the place we lived when we were young In the world of magnets and miracles Our thoughts strayed constantly and without boundary The ringing of the division bell had begun ... -=PF, The Division Bell=-Received on Tue Dec 10 1996 - 00:00:00 CET