GetOracleTables()

Summary

Gets a list of Oracle tables available to the user.

 

Syntax

Table_list = GetOracleTables(string service_name, array options)

 

Argument	Contents
service_name	The name of the Oracle service

 

Option	Type	Contents
Views	String	"True" to include Oracle views as well as tables in the results, "False" (the default) otherwise

 

Returns

An array of two (2) elements (null if an error occurred or there are no tables in the Oracle data source):

 

Element	Type	Contents
1	Array	An array of table names (strings)
2	Array	An array of owner names (strings)

 

Notes

• The owner name for any table may be null.

Error Codes

Error Type	Meaning
Error	An error occurred while connecting to the given Oracle service

 

See Also

Function	Summary
GetOracleFields()	Gets a list of fields in an Oracle table and whether they are indexed