Re: access

On Thu, 06 Nov 1997 18:47:08 +0100, Isaac Keslassy <keslasi0_at_cti.ecp.fr> wrote:

>How is it possible to execute an Oracle V7 stored procedure from an
>Access V2 application ?
>(we have Oracle ODBC)
>
>Thanks for your answer
>Isaac Keslassy

Hi Isaac,

take this as example:

This is a boolean function

Function fEinfuegenEinheit (szEinheitenTabelle As String, dwDirektion As Long, dwWohnanlage As Long, dwGebaeude As Long, dwEinheit As Long, dwObjekt As Long) As Integer

    szLclSQL = "Begin HIERARCHIE.EINHEITEINFUEGEN("     szLclSQL = szLclSQL & "'" & szEinheitenTabelle & "'" ' qotes must be added 'cause this is a string-parameter

    szLclSQL = szLclSQL & ","
    szLclSQL = szLclSQL & dwDirektion
    szLclSQL = szLclSQL & ","
    szLclSQL = szLclSQL & dwWohnanlage
    szLclSQL = szLclSQL & ","
    szLclSQL = szLclSQL & dwGebaeude
    szLclSQL = szLclSQL & ","
    szLclSQL = szLclSQL & dwEinheit
    szLclSQL = szLclSQL & ","
    szLclSQL = szLclSQL & dwObjekt
    szLclSQL = szLclSQL & "); END;"
    
    
    
    

    fEinfügenEinheit = (dbGblMakler.ExecuteSQL(szLclSQL) > 0)

        exit function

where SP is defined as :

   Procedure EINHEITEINFUEGEN(TABELLE VARCHAR2, DIR NUMBER, WANL NUMBER, GEB NUMBER, EINH NUMBER, OBJEKT NUMBER); Received on Fri Nov 07 1997 - 00:00:00 CST