IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  DESC

    Posted 07/12/11 12:15 PM

    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.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: DESC

    Posted 07/12/11 01:42 PM

    try this (with oracle) :

    select column_name from user_tab_cols where table_name ='YOUR_TABLE_NAME'

    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: DESC

    Posted 02/16/12 07:36 AM

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

    Thanks
    Saravanan S


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


Related Content