Re: Calls between Oracle & Operating System

Hi,
What do you mean "from inside Oracle"? The only means of Oracle7 (i have not tried Oracle8) is using a host language. You cannot call outside the kernel from PL/SQL (stored procedures).

But in a way it is "kinda" possible, using a server/host PRO*C (for instance) program that logs onto the database, and listens to a pipe for commands. The commands will instruct it to do the OS specific calls and it will return the result on a specific/private pipe. The kernel will the be able to have procedures that calls this pipe and waits on another pipe for answer. But as you see, it still requires a PRO*C (or another host-langauge) program to do the actual host-call.

• Peter H. Larsen

Rui Cavalheiro wrote:

> Hi,
>
> I'm new to Oracle, but very soon I'll need to make some programs
> (using IBM
> C/C++ for AIX 4.2, probably!) that have to call routines inside an
> Oracle
> 7.3 database. I will have also, to call other 3GL programs from inside
>
> Oracle.
>
> At this moment I'm just preparing this work, so, can anyone advise me
> on
> what will be the best way to do this interfaces? Thanks.
>
> Rui
Received on Wed Aug 06 1997 - 00:00:00 CEST