Q&A BY TAG 'oracle'

You must sign in to ask a question. If you do not have an account, you can register here

Error when trying access to Oracle Autonomous Database with Wallet
answered 02-03-2022 07:58:01 -0500

Hello, I tried to follow guide lines in this article to make a connection to an Oracle Database with wallet https://community.denodo.com/kb/en/view/document/Accessing%20Oracle%20Autonomous%20Database%20from%20Denodo Test connection receives this error...

Answers: 1

tls1.2 wallet Oracle

Problems in converting oracle math operation and the concatenation operator
answered 09-02-2022 04:57:35 -0500

Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...

Answers: 1

Date Conversion concatenate Oracle

Denodo cache got invalidated while having changes at the source level
answered 01-02-2022 06:48:37 -0500

Hi Support, I have noticed that, whenever I have any of the column/data type changes at source level of any of my developed(cached) views, My cached views got automatically invalidated? so the Question is, Is there any way to keep the cache db as it ...

Answers: 1

cache oracle

Is it possible to connect to Oracle Stored Procedures?
answered 02-12-2021 07:31:22 -0500

Trying to create base view from an Oracle Stored Procedure... following message appears "Unsupported type PL/SQL RECORD type for database: Oracle Stored Procedures". Anyone has solved this?

Answers: 1

Stored Procedure Oracle

Create Base View for Oracle Function that returns Table Type
answered 25-08-2021 07:21:24 -0400

I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...

Answers: 1

VQL VQL Base view Custom Functions Stored Procedure Oracle

Query delegation
answered 12-08-2021 12:43:20 -0400

Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, T...

Answers: 1

oracle query delegation denodo 7

Converting Oracle Functions to Denodo
answered 12-03-2021 05:37:37 -0500

Hello, I have an Oracle function that takes a few parameters and spits back out an output based on the logic inside the function. From what I can tell about Denodo, in order to be able to use this function, we would have to convert it to Java and then ...

Answers: 1

custom policy java oracle

Error while inserting data with bulk load activated on Oracle Data source
answered 05-03-2021 03:27:34 -0500

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have an Oracle instance running on the same computer. I run catldr.sql as sysdba on the Oracle database. I created a data source (dstrcr) and activated "Use Bulk D...

Answers: 3

Bulk Data Load Oracle

oracle "date" column convert to "timestamp" column in Denodo
answered 15-12-2020 05:45:51 -0500

Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...

Answers: 1

date oracle timestamp

Fail to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM.
answered 31-07-2020 04:07:13 -0400

Hello, I try to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM. A screenhot is joined for illustrate, the error message is (ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )...

Answers: 2

DQVM Oracle