Professional Web Applications Themes

Error when executing UDF - Microsoft SQL / MS SQL Server

I've defined a UDF that takes 1 DATETIME param & returns an INT. This UDF is used in 2 SPROCS (and works fine). This morning I changed the UDF to accept 2 DATETIME parameters. I immedediately changed the SPROCS to pass in the 2 required params. Now, when I run the SPROCS I get error 313 (insufficient params). If I run the UDF all by itself in Query yser with the identical params, it works fine. I tried sp_Recompile SPROC(s) to no avail. Am I missing any steps here? -Bill...

Sponsored Links
  1. #1

    Default Error when executing UDF

    I've defined a UDF that takes 1 DATETIME param & returns
    an INT. This UDF is used in 2 SPROCS (and works fine).

    This morning I changed the UDF to accept 2 DATETIME
    parameters. I immedediately changed the SPROCS to pass in
    the 2 required params.

    Now, when I run the SPROCS I get error 313 (insufficient
    params). If I run the UDF all by itself in Query yser
    with the identical params, it works fine.

    I tried sp_Recompile SPROC(s) to no avail.

    Am I missing any steps here?

    -Bill

    Sponsored Links
    Bill Guest

  2. #2

    Default Re: Error when executing UDF

    Are you sure you changed all the sp's and on the correct server?

    --

    Andrew J. Kelly
    SQL Server MVP


    "Bill" <net> wrote in message
    news:07f201c35de7$aae46830$gbl... 


    Andrew Guest

  3. #3

    Default Re: Error when executing UDF

    That was the problem.

    Thanks,

    -Bill

    Bill Guest

Similar Threads

  1. Error Executing Database
    By coreygrimm in forum Coldfusion Server Administration
    Replies: 2
    Last Post: August 12th, 12:23 PM
  2. Error Executing Database Query.
    By emailmatchgirl in forum Coldfusion Database Access
    Replies: 37
    Last Post: November 4th, 05:01 PM
  3. Error Executing Database ....
    By the-african in forum Coldfusion Database Access
    Replies: 16
    Last Post: October 15th, 11:58 PM
  4. Error executing child request for error.aspx
    By Shridhar in forum ASP.NET Building Controls
    Replies: 2
    Last Post: April 19th, 09:30 AM

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