Our BaaN run on bisam database and we have another add-on system that runs on oracle.
This add-on system needs data from BaaN based on certain criteria.
Hence a BaaN job is created that is executed by the users as and when reqd.
The job creates text files that are loaded to the oracle data base via a Pro*C program that uses SQL loader.

NOw the problem.
The Pro*c program needs to be run on the Oracle server itself and needs the DBA to execute it...
Now can the role of teh DBA be removed from this setup so that the LAN users can do teh BaaN job run and execute the Pro*c application on the server.


Thanks

Any Oracle application can be run client-server. Just install Oracle client network components on the client PC and configure them to talk to the database server. Make sure that the database has lsnrctl configured and running. Your DBA should be aquainted with all this.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.