Re: Calling stored proc's from VB
From: David Elliott <dae_at_pencom.com>
Date: 1995/06/16
Message-ID: <NEWTNews.803323722.28882.dae_at_redwood.pencom.com>#1/1
Date: 1995/06/16
Message-ID: <NEWTNews.803323722.28882.dae_at_redwood.pencom.com>#1/1
In article <3rnidm$t5n$2_at_mhafc.production.compuserve.com>,
>
> Does any know how the syntax for calling an Oracle stored
> procedure from Visual Basic? I have to pass two parameters in
> addition to calling the procedure.
>
> --
> ATK
>
Not that I've tried this myself, but previous similar posts have yielded the following answer:
Result% = ExecuteSQL("begin storedprocname('parm1', ...); end;")
Good luck!
David Elliott Sr. Software Eng. email: dae_at_pencom.com Pencom Software main: (512)-343-6666 9050 Capitol of TX Hwy N. FAX: (512)-343-9650 Austin, TX 78759Received on Fri Jun 16 1995 - 00:00:00 CEST