SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Senior Member
    Join Date
    Jul 2001
    Posts
    207
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    desc {tablename} command fails in Silk

    I am trying to use the following command to get the table description

    "desc employee"
    The table employee exists in DB and silk comes up with exception as
    [ ] *** Error: (42000) [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement
    [ ] Occurred in DB_ExecuteSql

    any idea what's wrong ? The same query from sqlplus works fine.
    Is there any other query which can fetch this information from database? I am using Silk5.02

    p.s.:I am trying to browse the nesgroup for similar problem faced

  2. #2
    Member
    Join Date
    Oct 2001
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: desc {tablename} command fails in Silk

    jcrvs,

    I think the problem you are having here is the desc is an oracle command,not an SQL command so you cannot use it through the ODBC driver.

    You may be able do what you need using the user_ tables.

    Hope this help,

    Paul

    ------------------
    Paul Tucker
    Merit AT
    www.merit-at.com

  3. #3
    Junior Member
    Join Date
    Aug 1999
    Location
    Raleigh, NC, USA
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: desc {tablename} command fails in Silk

    I recall being able to use:
    describe tablename

    I hope your problem is just an unrecognized command abbreviation.

    ------------------

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 05:28 AM.

Copyright BetaSoft Inc.