Re: ORACLE-L Digest -- Volume 2000, Number 365

From: Tiger Woods <arhk_at_yahoo.com>
Date: Sat, 30 Dec 2000 14:46:42 -0800 (PST)
Message-Id: <10726.125484@fatcity.com>

--0-648483337-978216402=:49131
Content-Type: text/plain; charset=us-ascii

I think I have solved the problem,
I have granted the user who created "HOWMUCHSPACE" stored procedure explicitely "ANALYZE ANY" system privilege, however the riddle remains the same, why the dbms_space return the out parameter values when called from script and caused the error which i have forwarded to list. regards,  

Asim Riaz Kaghzi
Oracle DBA,
Stamford, CT 06092
Res: 203.357.0255
Off: 203.316.6792

---

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! --0-648483337-978216402=:49131
Content-Type: text/html; charset=us-ascii

<P>I think I have solved the problem,
<P>I have granted the user who created "HOWMUCHSPACE" stored procedure explicitely "ANALYZE ANY" system privilege,
<P>however the riddle remains the same, why the dbms_space return the out parameter values when called from script and caused the error which i have forwarded to list.
<P>regards,
<P>&nbsp;</P><BR><BR>Asim Riaz Kaghzi<br>Oracle DBA,<br>Stamford, CT 06092<br>Res: 203.357.0255<br>Off: 203.316.6792<p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://photos.yahoo.com/">Yahoo! Photos</a> -
Share your holiday photos online!
--0-648483337-978216402=:49131-- Received on Sat Dec 30 2000 - 16:46:42 CST