246 results
Sorted by:
by
sshaik
in Designing and Running Pipelines
05-22-2023
10:41 PM
05-22-2023
10:41 PM
In this Scenario, I have to insert data onto an Oracle DB. Before that one I’m performing a Left Outer join and separating the data (for Update and Insert) by using router. In Insert snap I have to i...
08-03-2020
10:19 AM
I am getting below error while configuring Orcale thin account
below screenshot has error and tnsnames.ora file. I have set up the Orcale db on my personal device. Please suggest how to fix the err...
by
Szymon
in Designing and Running Pipelines
12-11-2020
06:49 AM
12-11-2020
06:49 AM
Hi,
How to insert multiple rows at a time into Oracle table within one transaction?
Example:
Reading 10 lines from CSV/Excel file.
Insert 10 lines into Oracle using Oracle insert.
When o...
by
GV2019
in Designing and Running Pipelines
11-27-2019
09:54 PM
11-27-2019
09:54 PM
I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter
to Oracle-Execute snap
Oracle-Execute has a sql =>
“select * from o...
by
sriiyengar
in Designing and Running Pipelines
05-10-2018
06:26 AM
05-10-2018
06:26 AM
I have been trying to set up Oracle thin Client account on snaplogic without much success. I used the options on the Oracle Account Setup documentation page and used the default JDBC driver class. P...
02-16-2023
05:43 AM
I am running select queries in Oracle execute. They run fine but i have 2 issues. I am unable to use any where clauses and I am unable to do any kind of date formatting in the mapper. For example, i...
07-28-2023
02:57 AM
I am trying to create a pipeline where I used the oracle stored procedure to insert data into a table and then link it in resultset output view and use the oracle select to read the data from that t...
04-13-2023
06:40 PM
Oracle SQL Stored Procedure status is not completing in snaplogic level
while its completed in sql level.
we are passing Date key as a Parameter
by
alchemiz
in Designing and Running Pipelines
04-02-2024
04:50 AM
04-02-2024
04:50 AM
Hi SMEs, Good day, any idea what is the root cause of this error? checked the stored procedure and all fields have alias. Thanks, EmEm
by
JanosIT
in Designing and Running Pipelines
05-15-2024
06:48 AM
05-15-2024
06:48 AM
I'm currently working on integrating data from an Oracle database (containing CLOB fields) with Salesforce using SnapLogic. The CLOB fields are causing difficulties in retrieving and processing the a...