My Oracle Support Banner

ORA-942 When Select Excel Table via DG4ODBC In A Procedure (Doc ID 1380538.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Microsoft Windows (32-bit)

Symptoms

Using the Database Gateway for ODBC 11.1.0.7 to connect to MS Excel , a SELECT statement  executed in SQL*PLUS session is successful:

SELECT ROWNUM  FROM "Sheet1$"@EXCEL;

But  when it is executed  from a procedure or a package it fails with ORA-00942 error:


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.