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 to [Release 11.1 to 11.2]
Information in this document applies to any platform.


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

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) ='' 
exec dbo.dt_displayoaerror @iObjectId, @iReturn 
goto CleanUp






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