DESC <tableName>

Hi All,

I want only the table column names how can I get that using our adapter services ( tried both custome and dynamic am getting the below error.

[ADA.1.316] Cannot execute the SQL statement “describe STPL_EDIV_EXEMPT_MGM”. "
(42000/900) ORA-00900: invalid SQL statement
ORA-00900: invalid SQL statement

Any clue in this?


try this (with oracle) :

select column_name from user_tab_cols where table_name ='YOUR_TABLE_NAME'

DESC is not a sql statement, (it is not a sql query). It is a sqlplus command.

Saravanan S