RE: Call procedures from VBasic

From: Frank N. Pettinato <frankp_at_extremezone.com>
Date: Tue, 17 Oct 2000 05:01:24 -0700
Message-Id: <10652.119444@fatcity.com>

Check out ADO from MS.

HTh,
Frank Pettinato

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of blackziggy Sent: Monday, October 16, 2000 2:05 AM
To: Multiple recipients of list ORACLE-L Subject: Call procedures from VBasic

Hello!
I'm working on a Windows-NT, and Oracle it's in a Unix computer. In this project i must call to a Oracle's stored procedure from a visual basic application. I can use PL/SQL in VB to insert, erase or modify registers in Oracle, but now, i want to call to a procedure. I'm trying with "execute proc_name(param1, param2)" but it doesn't work:

for example,

     dim SSQL as string

     SSQL=" execute proc_name(param1, param2) "
     Set vaanEskaria = vaanLotura.OpenResultSet(SSQL, rdOpenKeyset,

rdConcurValues)

In the SQL plus shell, i can use

SQL> execute proc_name(param1, param2);

and it works very well.

Can somebody help me?

Thanks

Iqaki Larraqaga

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: blackziggy
  INET: blackziggy_at_sammic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 17 2000 - 07:01:24 CDT