SPONSORS:






User Tag List

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

    DB_FetchNext truncates stored proc name to 30 chars??

    I am making a call to DB_Procedures and then using DB_FetchNext() to get list of stored procedures from DB
    But when i get the list it has truncated names of the store procs. The max length of the name printed is 30 chars? Procedures having names more than 30 chars display only first 30 chars.
    Any idea why this is happenning?
    I use the code as follows :-

    hstmt = DB_Procedures (hdbc, NULL, NULL, "%")
    while(DB_FetchNext(hstmt,col1,col2,name,remarks))
    Print(name)
    Print(remarks)
    Print(Len(name))

    Thanks in advance

  2. #2
    Junior Member
    Join Date
    Aug 2001
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_FetchNext truncates stored proc name to 30 chars??

    Is this with SQL Server? I have had the same problem. I ended up renaming my SP's to less than 30 characters. Sorry that I don't have a real solution.

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

  3. #3
    Member
    Join Date
    Feb 2001
    Location
    New York, NY
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_FetchNext truncates stored proc name to 30 chars??

    Check your server documentation. (Silk's is not very good.) Since DB_Procedures corresponds to SQLProcedures, look it up.
    According to MS SQL 7.0, the SQLProcedures syntax is

    SQLRETURN SQLProcedures(
    SQLHSTMT StatementHandle,
    SQLCHAR * CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR * SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR * ProcName,
    SQLSMALLINT NameLength3);

    The last line SQLSMALLINT controls the size of the ProcName.

    Hope it helps.


    ------------------
    -Lev Aks
    lev_aks@in-nyc.com

    [This message has been edited by levaks (edited 10-05-2001).]

  4. #4
    Senior Member
    Join Date
    Jul 2001
    Posts
    207
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_FetchNext truncates stored proc name to 30 chars??

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by glynch:
    Is this with SQL Server? I have had the same problem. I ended up renaming my SP's to less than 30 characters. Sorry that I don't have a real solution.

    <HR></BLOCKQUOTE>

    I am using a Oracle8.x server on Unix ...so let me check with the documentation of the same
    Thanks for the help

  5. #5
    Senior Member
    Join Date
    Jun 2000
    Location
    Chicago, IL USA
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_FetchNext truncates stored proc name to 30 chars??

    FYI:
    I thought I should post the solution to this old problem. It is all in the ODBC driver that you use.

    If you configure ODBC with the "Oracle ODBC Driver for Windows" -- the names are cut off.

    If you configure ODBC with the "Microsoft ODBC for Oracle" -- the names are returned in full.
    Rob Kapteyn, CSTE
    RobKapteyn@gmail.com

 

 

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 09:25 PM.

Copyright BetaSoft Inc.