RE: Call procedures from VBasic

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Mon, 16 Oct 2000 12:57:13 -0400
Message-Id: <10651.119346@fatcity.com>

"execute" is purely a SQL*Plus shortcut for begin <block> end;

You just need to explicitly do the begin..end

Regards,
Diana

-----Original Message-----
From: blackziggy [mailto:blackziggy_at_sammic.com] Sent: Monday, October 16, 2000 5: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 Mon Oct 16 2000 - 11:57:13 CDT