Re: Access to store procedures

Michael Shapiro wrote:
>
> I have NT machine and I need to verify if store procedure on my SUN box
> server is working.
>
> Is there any tool on NT platform where you can access store procedure via
> ODBC and don't need to write any script.
>
> TIA
select object_name, status
from all_objects
[Quoted] where object_name = '...'
and object_type = '...' (PROCEDURE, FUNCTION etc)

will tell that its there and compiled.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse