webMethods

webMethods

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.

 View Only

  • 1.  DESC

    Posted Tue July 12, 2011 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 Tue July 12, 2011 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 Thu February 16, 2012 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