Re: Access to store procedures
Date: Sat, 4 Mar 2000 23:10:34 -0800
Message-ID: <89smlr$otg$1_at_ssauraaa-i-1.production.compuserve.com>
dbTools does support ODBC connections as well as direct connections using
Oracle OCI.
http://www.softtreetech.com
Connor McDonald wrote in message <38BCF91C.52A7_at_yahoo.com>...
>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
>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
Received on Sun Mar 05 2000 - 08:10:34 CET