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 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 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...
As part of the November (4.35) release, we are upgrading the Oracle JDBC driver from version 11.2.0.4 to 19.20.0.0 to improve security, performance, stability, and reliability of the Oracle Snap P...