Re: executing a stored procedure thru ODBC

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/01/22
Message-ID: <6a7d3p$h33$1@news02.btx.dtag.de>#1/1

Hi Bill,

here's an VB3-example:

function fSAVEVALUES() as Integer
...
...

        szLclSQL = "BEGIN PACK_PROVABRECHNUNG.FAELLIGKEITAENDERN_NT("
        szLclSQL = szLclSQL & dwGblProv_OP & ","		'SP's parameter
        szLclSQL = szLclSQL & "'" & Trim$(sitxtDatum) & "'"	'SP's
parameter
        szLclSQL = szLclSQL & ");END;"
        
        fSAVEVALUES = (dbGblMakler.ExecuteSQL(szLclSQL) > 0)	'Returns

the number of rows affected

Keep in mind that in VB3 'ExecuteSQL' autocommits! If you don't want this, try 'Execute szLclSQL, SQL_PASSTHROUGH' where SQL_PASSTHROUGH has the value 64.

Bill Johnston wrote:
>
> Anyone know how to execute an Oracle stored procedure thru Access97?
>
> Thanks,
> whj2_at_erols.com
 

-- 
Regards

Matthias Gresz    :-)

Received on Thu Jan 22 1998 - 00:00:00 CST