Icon

OracleStoredProcedure

Working with PL/SQL Procedures in Oracle

This workflow demonstrates how work with stored procedures in Microsoft SQL Server. The workflow first creates a stored procedure. Once procedure is created the workflow calls it and retrieves the result.

Node 5create test table and pass table name to next node via variable connectionCreate stored procedurethat selectes the row countfrom the created tableCall procedure andreturn resultDB ConnectionData Generator DB Writer DB SQL Executor DB Query Reader Oracle Connector Node 5create test table and pass table name to next node via variable connectionCreate stored procedurethat selectes the row countfrom the created tableCall procedure andreturn resultDB ConnectionData Generator DB Writer DB SQL Executor DB Query Reader Oracle Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: koetter
Created at: 2016-09-20
On NodePit since: 2023-03-02
Last update: 2024-11-17
Created with KNIME version: v4.7.1
Tags: dbstored procedureoracle

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!