Re: Using output variables

From: Jonathan Chong (jonathan_at_3exp.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 11:37:10 +0800

That's my point. The problem lies in the Web page that calling
'GetPermissions'.

Try this in your Query Analyzer to proof that your SP has not problem:

DECLARE @PID int, @UserID int
DECLARE @permission int
SET @PID =1
SET @UserID =1
EXEC GetPermissions @PID,@UserID,@permission OUTPUT
SELECT @permission

"GeorgeP" <anonymous@discussions.microsoft.com> wrote in message
news:072c01c4a118$f1b38e60$a301280a@phx.gbl...
> I have the Page calling the stored proc and the proc
> should be returning the paramter. If returned permission
> code is correct the page goes to the admin page.
>
> The problem is that the SP does not work. The question
> is... Why is the procedure looking for the output variable
> to be entered as an input variable? the output variable
> is loaded in the select statement of the proc.
>
> Thanks,
> GP

Relevant Pages

  • Re: Questions and observations about CAS and the StrongNameIdentityPermssionAttribute.
    ... Fully trusted code can bypass CAS entirely by calling into unmanaged code ... This works fine as long as I do not fully trust ... Code running with an unrestricted permission grant always ...
    (microsoft.public.dotnet.security)
  • Re: Passing a named function instead of a code block?
    ... grab a method as an object without calling it, ... :square1 is an atomic unit representing the symbol whose ... we call square1 and cast the result of that using '&'. ... '&square2' is fine as square2 is just a variable referring to a proc. ...
    (comp.lang.ruby)
  • Re: Print function name of calling function?
    ... print the name of the function calling f3which could either be f1 ... In gdb it is possible to get a call trace, how can gdb get the call ... You still might not have permission to access it in any case. ... No, you can't depend on having dynamic-linked libraries, ...
    (comp.lang.c)
  • SQL Task Error in proc not detected?
    ... I have a package calling a stored proc PROC1, ... proc PROC2, ...
    (microsoft.public.sqlserver.dts)
  • Re: Permissions Question?
    ... Calling an illegal alien an "undocumented worker" is like calling a ... drug dealer an "unlicensed pharmacist" ... telling me that I don't have permission to run that file. ...
    (microsoft.public.windowsxp.help_and_support)