Professional Web Applications Themes

Extended Stored ProcedureExtended SP's - srv_paramsetoutput length > 255 - Microsoft SQL / MS SQL Server

Hi! In my extended stored procedure i´m trying to set an outputparameter >255 with the srv_setparamoutput function but it fails! I think i have the correct include and lib files installed. This stuff is new for me, what am i doing wrong!! //Wolf...

  1. #1

    Default Extended Stored ProcedureExtended SP's - srv_paramsetoutput length > 255

    Hi!
    In my extended stored procedure i´m trying to set an
    outputparameter >255 with the srv_setparamoutput function
    but it fails! I think i have the correct include and lib
    files installed. This stuff is new for me, what am i doing
    wrong!!
    //Wolf
    Uffe Guest

  2. #2

    Default Re: Extended Stored ProcedureExtended SP's - srv_paramsetoutput length > 255


    Thanks for your answer!
    Still have the same problem. The include and lib files seems
    to be ok, how can I check that? This is how the call is made.

    // Set the output parameter
    if (FAIL == srv_paramsetoutput(srvproc, 3, (unsigned char*) str.c_str(),
    (ULONG) str.length(), FALSE))
    {
    printError (srvproc, "srv_paramsetoutput failed...");
    return (XP_ERROR);
    }
    //Uffe

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Ulf Guest

  3. #3

    Default Re: Extended Stored ProcedureExtended SP's - srv_paramsetoutput length > 255

    Check what?

    This is what I use:
    RETCODE setparam(SRV_PROC* srvproc, INT ordinal, const CHAR* pValue)

    {

    size_t charlen = strlen(pValue);

    return srv_paramsetoutput(srvproc, ordinal, (BYTE*)pValue, (ULONG) charlen,
    (charlen == 0 ? TRUE : FALSE));

    }


    Net

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright © SQLDev.Net 1991-2003 All rights reserved.

    "Ulf Bergström" <se> wrote in message
    news:phx.gbl... 


    Gert Guest

Similar Threads

  1. Max. Length of varchar2 from Oracle Stored Procedure
    By MX_Oracle in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 12th, 04:10 PM
  2. stored proc 128 length limit
    By AJ in forum ASP Database
    Replies: 13
    Last Post: September 22nd, 06:59 PM
  3. Extended stored procedure and Cursors
    By Partha Mandayam in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 9th, 02:34 AM
  4. Extended Stored Proc diff btw 7.0 and 2000
    By Gert E.R. Drapers in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 11:20 PM
  5. Extended Stored Procedures accepting Real Parameters
    By Microfirm in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 09:59 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139