Oracle Snap Pack examples

The following examples demonstrate how to use Snaps in the Oracle Snap Pack.

Example Snaps used
Oracle - Delete

Delete student records

The following example pipeline demonstrates how to delete all the student records that have the same scores as Adam's. In this example, we have a table named STUDENT that stores students' scores. It h...

Error Handling

This example pipeline demonstrates the error handling of the Snap. We use the same pipeline as the one in Example #1 and let error messages route to the error view:
Oracle - Execute

Get the student's records from a table

In this example, we have a table named STUDENT that stores students' scores. It has 3 columns: ID, NAME and SCORE. We will get the record of a student named "Brace" with this pipeline:

Error handling on the Snap (Oracle Execute)

This example will show the error handling of the Snap.
Oracle - Insert

Insert input data into a table

The following example pipeline demonstrates how to insert a row of data into TEST_EMPLOYEE table.

Error Handling of the Snap

This example pipeline demonstrates error handling.
Oracle - Lookup

Finding a students score from the table

In this example, we have a table named STUDENT that stores students' scores. It has 3 columns: ID, NAME and SCORE. We will find all the student records that have same scores with Adam's with this pipe...

Error handling on the Snap (Oracle Lookup)

This example will show the error handling of the Snap.
Oracle - Merge

Using a conditional update

In the first example, we will drop a table, insert data into a newly created table, update one of records and then merge that update result into the same table.

Error handling (Oracle Merge)

In the second example, we use an error view on the Oracle Merge Snap.
Oracle - Parallel Load

Parallel Load batch insertions

The following example pipeline demonstrates the use of Parallel Load to insert 1000 documents. This example showcases Parallel Load's efficiency and capability in managing large-scale data insertion t...

Handle Database Insertion Failures with Open Error View

This example demonstrates a Mapper Snap configuration designed to intentionally cause a small number of records to fail during database insertion. For every failed insertion, an error document is gene...
Oracle - Select

Error view on the Oracle Select Snap

Here we mis-typed the variable in the condition, which will trigger an error. The error will be written to the error view of the Snap, which then can be used for debugging purpose or further processin...
Oracle - Stored Procedure

Calling a simple Stored Procedure

In this example we want to call stored procedure TEST_PROC.

Oracle Stored Procedure with user-defined parameters

In this example we will call a Oracle Stored Procedure PROC_WITH_CUSTOM_IN_PARAM which has parameters of user-defined types.

Calling a simple stored function with custom type mapping

This Pipeline demonstrates invoking a stored function using the Oracle Stored Procedure Snap by defining a custom type mapping and documenting the indexing behavior. The return value has index 1 and t...
Oracle - Table List

Get a list of all the tables

In this example, we will use an Oracle Table List Snap to get a list of all tables in schema TECTONIC, and store the list as a local file:

Error handling of the Snap

This example will show the error handling of the Snap.
Oracle - Update

Update a record in a table

In this example, we will update a record in a table.

Error handling (Oracle Update)

This example pipeline demonstrates how error handling works. We use the same pipeline as the one used in Example #1. The difference is this time we try to update the column "Titlee" which doesn't exis...

Northwind sample database

In this example, we will use the well-known Northwind sample database Following is a selection from the "Customers" table: