What is API and what is open interface? 
Posted: 12 August 2005 07:16 PM   [ Ignore ]
Newbie
Rank
Total Posts:  1
Joined  2005-08-11

What is API? and what is open interface?what is the difference between two?

Profile
 
 
Posted: 17 August 2005 01:00 PM   [ Ignore ]   [ # 1 ]
Newbie
Rank
Total Posts:  2
Joined  2005-03-08

The term Open Interfaces actually refers to table driven interfaces, where you put data in a table that sits between your external application and the Oracle module you are interfacing with.

The term API refers to stored procedure driven interfaces, where you call a stored procedure to perform an action within an Oracle Module, and the data from your external application is passed through the stored procedure’s parameters.

Historically, there were only table driven interfaces and they were called Open Interfaces. Later, stored procedures were added and were called APIs.

 Signature 

--
François Gendron
Independant Oracle eBusiness Suite Consultant
(418) 682-5391 ext. 2000

Profile