Q&A BY TAG '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
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
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
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
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
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
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
Data type mapping
answered
03-01-2019 08:04:42 -0500
Hi, Happy New Year I have been asked to produce a data type mapping from Oracle to Denodo. I can't figure out what happens, for instance to integers: In Oracle an integer would be a Number(38), so -999..(38 9s) to 999... In Denodo the Int data type h...
Answers:
3
Interpolation of function and variable.
answered
26-09-2018 08:27:23 -0400
I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...
Answers:
1
How to change database schema of Oracle base views
answered
07-05-2018 11:39:27 -0400
Hi, in our development system (denodo 6.0, latest update) we frequently want to change the database schema of many existing base views belonging to the same Oracle data source. The problem is that the schema name is included in every JDBC wrapper, fo...
Answers:
1