Can I Call the API functions of some tool running on HP-UNIX from ORACLE SP?

[ashish23]

How can I call the API functions of some tool running on HP9000-UNIX from ORACLE stored procedure which is also running on the HP9000-UNIX . ?

I am developing a Powerbuilder(Ver7) application on windows2000/NT/98 platform.
Powerbuilder can connect to the ORACLE database running on the HP9000-UNIX and it can also execute the ORACLE Stored Procedures.

I want to call the API functions of a Data Conversion Tool called "DataJunction" which is running on the HP9000 UNIX.
The backend is ORACLE database which is also running on HP 9000 UNIX.
The file which contains the API function of Datajunction is also on the HP 9000 UNIX box.
Is there any way to call these API functions from PL/SQL and Oracle Stored Procedure?

Thanks.

Ashish

[sambavan]

You can call it through an external proc. Or write an java or Proc'C code that would call it and then invoke this java/pro*c
in your plsql


Sam

[ashish23]

Thank you very much for such a quick response!!!!
I have one more question to you. When I was reading the
help about "Calling External Procedures"
in chapter 10 of "Oracle9i Application Developer's Guide - Fundamentals" I noticed that the following restrictions apply to external procedures:

[1] This feature is available only on platforms that support
DLLs. (Please see the heading "Restrictions on External C Procedures")


My Question---
[a]Does it mean that the call to external procedure will work only on Windows platform and not on UNIX platform?

[Shestakov]

dll on win this is same objects as *.so on unix.

[ashish23]

Thank you very much !! You are wonderful!!