Search

Oracle

This document describes the Oracle Storage Connector and the Query block.
Index

DB Storage Connection Block

1) Create

•
Blocks that declare variables for using Storage.

2) Set to

•
Assign Oracle Storage to a variable.

3) Oracle Connector

•
Select Oracle Storage from the drop-down list to connect.

Query Connection

1) Oracle Query

•
Enter the Oracle Query ID registered in Query Manager to pair.
•
Click the button to add or delete Query Parameter item.

2) Query Option Block

•
Query Option Block in Oracle > Query category.
No.
Function
1
Click the button to add or delete Query Parameter item.
2
Register Query Bind Parameter.
3
Commit (save changes) the DB Storage's transactions connected to the Connector.
4
Roll back (revoke changes) the transaction of the DB Storage connected to the Connector.

Procedure Connection

1) Oracle Procedure

•
Enter the Oracle Procedure ID registered in Query Manager to pair.
•
Click the button to add or delete Procedure Parameter item.

2) Procedure Option Block

•
Procedure option block in the Oracle > Procedure category.
No.
Function
1
Click the button to add or delete Procedure Parameter item.
2
Set the parameters of the Procedure input mode.
3
Set parameters of the Procedure output mode.
4
Set the parameters of Procedure input, output mode.
5
Set the datatype of the Procedure parameter. - Configurable types string, integer, Boolean, null, cursor