Re: Using Spawnl function of VC+ to call a Oracle Procedure

On 31 Aug 2002 01:05:44 -0700, analysis_ak_at_yahoo.com (Arvind) wrote:

>Hi,
>
>I would like to write a code in VC that should be calling my PL/SQL
>Procedure in the Oracle Database. I have been made to understand that
>I can use SPAWNL function of VC. But I am not sure as to how to code
>it so that I get connected to Database and start the execution of a
>PL/SQL Procedure.
>
>If anybody can provide help on this matter with an example it would be
>of great help.
>
>Thanks & Regards,
>
>Arvind Kumar Singh

You don't need this clumsy and cumbersome method. Oracle Objects for OLE, aka OO4O, is a native DAO like interface to Oracle and can be called from VC and Visual Basic. It comes with every Oracle client, so you already have it.
You can do anything, including calling pl/sql procedures. Samples are online at http://otn.oracle.com

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 31 2002 - 04:07:18 CDT