Help - Search - Members - Calendar
Full Version: sqlcolumns in oracle using otl
Oracle DBA Forums > Oracle > Oracle Forum
AsifIshaq
Hi,
I am using otl lib for database related operations. I am trying to get the table schema using sqlcolumns (provided for odbc supported databases for getting table columns information). I am getting an error "Optional feature not implemented". Please help me out in this matter.

Thanks,
Asif
burleson
Hi Asif,

>> I am using otl lib for database related operations.

Did you install the right ODBC driver?

http://www.oracle.com/technology/software/...odbc/index.html

****************************************************
>> I am getting an error "Optional feature not implemented".

OK, please paste-in the call and the whole error message!
AsifIshaq
Thanks for responding.
I have used this call "$SQLColumns $1:'dbname' $:'' $3:'tablename'" . Sqlcolumns is provided for getting the table columns from any database that supports odbc. This is not oracle version of sqlcolumns.The error is "Optional features not implemented". I have downloaded the latest driver but getting the same error even after installing the driver. Waiting for your positive reply.

Thanks,
Asif
AsifIshaq
I was doing R&D on this and i found that the catalog options is by default off(disable). Do you know something about this ? How can I Enable Catalog options ? I think that this is creating problem in my case.
burleson
>> can I Enable Catalog options ?

Read the docs, it;s there:

http://www.datadirect.com/products/odbc/or...r_faq/index.ssp

"click the Advanced and Performance tabs to specify data source settings such as Default User Name, Array Size, Lock Timeout, Default Buffer Size for Long/LOB Columns, and Catalog Options"
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.