Re: ODBC Stored Procedure Problem.

From: Nasier <nf_at_isis.co.za>
Date: 1997/08/08
Message-ID: <33EAB824.5E38@isis.co.za>#1/1

leighj_at_merck.com wrote:
>
> I have a store procedure that I am trying start from VB 4.0 16bit. I
> can run SQL w/o a problem but I cannot get Execute to run my stored
> procedures. I get an error saying the ODBC Call failed. Any ideas?
>
> Leigh
>

Don't use execute - send an anonymous block e.g. if your procedure is called 'test_store_proc' set your SQL statement to the following:

'begin test_store_proc; end;'

instead of using the 'execute' command. Nowhere in the Oracle or ODBC client documentation could I find instructions to do it this way!

Cheers
Nasier. Received on Fri Aug 08 1997 - 00:00:00 CDT