This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
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...
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...
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...
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...
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...
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...