OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Accessing external API (COM Objects)

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Accessing external API (COM Objects)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accessing external API (COM Objects) [message #262166]

Fri, 24 August 2007 14:50

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

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263331 is a reply to message #262166]

Wed, 29 August 2007 13:49

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.

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263362 is a reply to message #263331]

Wed, 29 August 2007 20:18

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

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263366 is a reply to message #263362]

Wed, 29 August 2007 20:48

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

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263413 is a reply to message #263366]

Thu, 30 August 2007 00:17

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

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263739 is a reply to message #263413]

Thu, 30 August 2007 22:20

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.

Report message to a moderator

Re: Accessing external API (COM Objects) [message #263773 is a reply to message #263739]

Fri, 31 August 2007 00:28

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 21 18:22:55 CST 2025