Select From Dba_tab_columns Reports Columns That Do Not Belong To Tables Using DG4MSQL (Doc ID 602704.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

When selecting from the data dictionary table dba_tab_columns using Database Gateway for SQL*Server 11.1.0.6 -

select table_name, column_name from dba_tab_columns@dg4msql ;



the table names returned include procedure names and the column name is a parameter to the procedure.
For example - 

 

select table_name, column_name from dba_tab_columns@dg4msql order by table_name ;


 - returns 875 rows - including objects which are procedures for example - 

 

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
dt_addtosourcecontrol          @vchComment
dt_addtosourcecontrol          @vchLoginName
dt_addtosourcecontrol          @vchPassword
dt_addtosourcecontrol          @vchProjectName
dt_addtosourcecontrol          @vchSourceSafeINI 



 
 In SQL*Server Enterprise Manager dt_addtosourcecontrol is shown to be a procedure - 
 

create proc dbo.dt_addtosourcecontrol 
vchSourceSafeINI varchar(255) = '', 
vchProjectName varchar(255) ='', 
vchComment varchar(255) ='', 
vchLoginName varchar(255) ='', 
vchPassword varchar(255) ='' 
... 
... 
E_OAError: 
exec dbo.dt_displayoaerror @iObjectId, @iReturn 
goto CleanUp

 

 

 



.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms