Professional Web Applications Themes

Problems with extended procedures - Microsoft SQL / MS SQL Server

This is probably a bit of an obscure one but I am trying to set up a call from a telephony scripting language to an extended procedure calling e.g. xp_hello(?) from the samples and one of two things happen : 1) I call it using the specified number of parameters (one being an output parameter) and it gets upset that "SQL result table does not have the same number of fields". 2) I add a return field to the call and I get SQL errors about changes in cursor type. Is there any way that I can use a stored ...

  1. #1

    Default Problems with extended procedures

    This is probably a bit of an obscure one but I am trying
    to set up a call from a telephony scripting language to an
    extended procedure calling e.g. xp_hello(?) from the
    samples and one of two things happen :

    1) I call it using the specified number of parameters (one
    being an output parameter) and it gets upset that "SQL
    result table does not have the same number of fields".

    2) I add a return field to the call and I get SQL errors
    about changes in cursor type.

    Is there any way that I can use a stored procedure or
    change the code in the extended procedure to eliminate the
    results table and simply return values within the
    parameters?

    Thanks,

    Nick
    Nick Eynon Guest

  2. #2

    Default Re: Problems with extended procedures

    Without the code of your XP it is hard to tell, but you can have an XP
    return via output parameters and not return a resultset or the other way
    around or even do both. But do you need to know how to write an XP which
    seem to be the problem in this case.

    [email]GertDSQLDev.Net[/email]

    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.

    "Nick Eynon" <nick.eynontransactgroup.net> wrote in message
    news:04b801c34166$51fd4bd0$a001280aphx.gbl...
    > This is probably a bit of an obscure one but I am trying
    > to set up a call from a telephony scripting language to an
    > extended procedure calling e.g. xp_hello(?) from the
    > samples and one of two things happen :
    >
    > 1) I call it using the specified number of parameters (one
    > being an output parameter) and it gets upset that "SQL
    > result table does not have the same number of fields".
    >
    > 2) I add a return field to the call and I get SQL errors
    > about changes in cursor type.
    >
    > Is there any way that I can use a stored procedure or
    > change the code in the extended procedure to eliminate the
    > results table and simply return values within the
    > parameters?
    >
    > Thanks,
    >
    > Nick

    Gert E.R. Drapers Guest

Similar Threads

  1. Trial Version of Acrobat 9 Pro Extended Installation Problems
    By Hardy_Sykes@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: September 8th, 02:22 AM
  2. Extended unit
    By Pailloncy Jean-Gerard in forum PostgreSQL / PGSQL
    Replies: 31
    Last Post: January 31st, 01:18 PM
  3. Extended Last Release 1.0
    By Matty in forum Linux / Unix Administration
    Replies: 1
    Last Post: May 24th, 01:10 AM
  4. 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