Re: Call procedures from VBasic

Try setting sqlpassthrough option ( in the database properties , option set to 64 ) if you are using shema.object ( dot notation ) . Because SCHEMA.OBJECT notation is not allowed in VB
without setting sqlpassthru' option.

Regards
Jay

blackziggy wrote:

> 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 - 04:53:18 CDT