"Error: Object reference not set to an instance of an object." when publishing data set / snapshot to Toad Intelligence Central (4309516)

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

"Error: Object reference not set to an instance of an object." when publishing data set / snapshot to Toad Intelligence Central
Descrição

The following error occurs when publishing a query to Toad Intelligence Central(TIC):
"Error: Object reference not set to an instance of an object"
Publishing a simple query e.g. select * from <tablename> works OK
Causa

Oracle query is using a WITH clause, which is not supported when publishing to TIC
WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;
Resolução

rewrite query/script to not include the WITH statement e.g.
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
(SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno) dc
WHERE e.deptno = dc.deptno;

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título