Oracle Examples:
1. Oracle example of a call from a Stored Procedure:
Add the following to the declaration section of the stored procedure:
v_result varchar2(256);
Then add the call to Ws_Api_Glossary:
v_result := Ws_Api_Glossary('Data Warehouse','Overview','A repository of business information','ADD');
2. Oracle example of a call from sqlplus:
Note: the line beginning exec ... and end with ; must be one line.
Place the following code in a text file called FileName.sql:
set pages 0 feed off heading off
variable res varchar2(256);
exec :res:=Ws_Api_Glossary('Data Warehouse','Overview','A repository of business information','ADD');
print :res;
Execute the file from sqlplus (using @FileName). The following out is typical:
Data Warehouse element inserted