DESC <tableName>

, ,
1

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?

Thanks,
Sam.

2

try this (with oracle) :

select column_name from user_tab_cols where table_name ='YOUR_TABLE_NAME'
3

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

Thanks
Saravanan S