Calling C functions from an Oracle Form

From: Antonio Galdo <5978186832#agaldo_at_bbvnet.com>
Date: 1997/11/21
Message-ID: <34760739.44DB_at_bbvnet.com>#1/1

Hi everybody,

          
     I'm a little bit confused about how to resolve a problem:
          
     Inside an Oracle Form i have to parse a text string and detect

lexical or sintactic errors. I want to use lex and yacc (or bison) but there is no lex/yacc for PL/SQL -as far as i know-. So my idea is to call
from my Form this parse routine written in C for which i can use lex and Yacc.

      I've thought about creating a Win32 DLL (using VC++5.0) which could
provide several functions to the Oracle Form. Before i call the parse function, i need to load into my DLL some information about what i'm going to parse. There's a lot of information that has to be passed to the parse routine, each one is an item with its properties that's why i've thought about calling a function NextItem(...) several times before calling Parse. When all the info is loaded into de DLL i would call the parse routine and then reset the DLL.

     
     I'm not sure if this is the best solution (i'm novice in Windows 
programming) but i can't think of any other.
     
I will appreciate any comments or suggestions.
     
     Thanks,
     


     -------------------------

     Antonio Galdo
     Software Engineer
     ATOS Group - Spain
     email: agaldo_at_repsol.es
            agaldo_at_bbvnet.com


     -------------------------

Received on Fri Nov 21 1997 - 00:00:00 CET