Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Accessing external API (COM Objects)
Accessing external API (COM Objects) [message #262166] Fri, 24 August 2007 14:50 Go to next message
felipe.bertaglia
Messages: 4
Registered: August 2007
Junior Member
Hello,

I'm trying to make a PL/SQL package to access and retrieve some data from TestDirector. These data will be used in my Oracle DB.
The only way I have to access TD (TestDirector) is by those API´s. TD offer a COM Object based collection of APIs.

How can I access those APIs using PL/SQL?
(In VBA and VBS is easy, just use CreateObject(host))

TD API documentation. [http://javachip.org/Tutorial/TD%20Tutorial.pdf]

I just need a direction, I´m kinda lost here.

Felipe.

@Oracle 10g XE + ApEx 3.01 + Windows 2003
Re: Accessing external API (COM Objects) [message #263331 is a reply to message #262166] Wed, 29 August 2007 13:49 Go to previous messageGo to next message
felipe.bertaglia
Messages: 4
Registered: August 2007
Junior Member
I´ll create a .vbs file bridge the communication between oracle DB and TD API. This .vbs will be runned by a pl/sql function.
Re: Accessing external API (COM Objects) [message #263362 is a reply to message #263331] Wed, 29 August 2007 20:18 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
@other people: Would using the C API be useful here or should felipe be using JDeveloper or Forms to act as the vehicle to communicate to the Oracle database and this TestDirector thing?

The problem as I see it is that the PL/SQL will be running on the database which may not be on the same machine as the TestDirector API.

David
Re: Accessing external API (COM Objects) [message #263366 is a reply to message #263362] Wed, 29 August 2007 20:48 Go to previous messageGo to next message
felipe.bertaglia
Messages: 4
Registered: August 2007
Junior Member
Well, TestDirector has a conection API. I'm using it in my .vbs (Windows Script Host platform). But it isn't good, I need to call that .VBS using some ID as parameter, then its connect to my DB and to TD API.

Thanks David,

Felipe
Re: Accessing external API (COM Objects) [message #263413 is a reply to message #263366] Thu, 30 August 2007 00:17 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I read some of the guide that you referenced. I can see some opportunities for my own work. What I want to know is what features you intend using and what information you need to get out of it. Why do you need to access the Oracle database?

David
Re: Accessing external API (COM Objects) [message #263739 is a reply to message #263413] Thu, 30 August 2007 22:20 Go to previous messageGo to next message
felipe.bertaglia
Messages: 4
Registered: August 2007
Junior Member
It's because I have a Oracle Application Express running in my Oracle DB's. That application need to query some data from TestDirector. Just some defects information.
Re: Accessing external API (COM Objects) [message #263773 is a reply to message #263739] Fri, 31 August 2007 00:28 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I am moving this question to APEX. IF you get no reply in 3 days use PM to get me to follow it up.

Davud
Previous Topic: APEX_Lib -- Text Messages
Next Topic: Import to Oracle from Excel .XLS files- it there a way?
Goto Forum:
  


Current Time: Thu Mar 28 15:25:32 CDT 2024