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...
Hi,
I am facing the below issue while updating a column using Oracle update snap. Please suggest what I am missing and how this can be corrected.
Extract Effective Date_2022_09_20.slp (10.2 KB)