Re: Calling stored procedures from Visual Basic for appl?

In article <3h0dhi$482_at_newsbf02.news.aol.com>, gxun65a_at_aol.com (GXUN65A) says:
>
>The last that I had heard, was 'NO', at least where I work...We run under
>SQL Net, and use ODBC from Micosoft. I'd like to know, if anyone else
>hears different.
>
>Richard Clapp
>
>gxun65a_at_aol.com

Au contraire. I am doing exactly this. I am using VBA from within Excel, using the Oracle ODBC driver, and MS-TCP32 protocol stack over SQL*Net 2.1 and am using stored procedures. The trick that worked for me was to use the following syntax in the SQL call: "BEGIN <package>.<proc name>; END;".

I had no luck until I did it using the anonymous PL/SQL block.

BTW, the XLODBC.XLA add-in for Excel is flakey. Instead, code directly to the ODBC DLL. This has proven solid for me.

Cheers,

        Bruce Received on Tue Feb 07 1995 - 07:16:51 CET