RE: parameter name problem
From: Stephen Giles (Giles_at_discussions.microsoft.com)
Date: 10/08/04
- Next message: Savas Ates: "Type Mismatch Error(numeric values)"
- Previous message: David Gugick: "Re: Transpose / flatten / rows to columns"
- In reply to: Amish Manubhai Shah: "parameter name problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 08:33:07 -0700
Hi.
Although is it not an elegant solution, you can pass parameters into a
stored procedure positionally.
For example, if you have a proc with two parameters you can call it as:
exec MyProc @parm1 = "x', @parm2 = 'y'
or you can simply call
exec MyProc 'x', 'y' .
If you choose this method you must supply a value for all parameters (or the
NULL operator if you don't have a value) in the same order as you parameters.
I can't remember of PL/SQL will also allow for positional value calls of its
stored procedures.
I hope this helps.
Steve
"Amish Manubhai Shah" wrote:
> I am developing crystal report on both database oracle and sql server
> When I migrate my report from oracle to sql server
> My problem is that in store proc we have to add @ before parameter name in
> sql server and in oracle it is a simple string , so how can I define
> parameter without @.
>
> This is helpful to me because i have to redefine all parameter in
> crystal report after migrating from oracle to sql server
>
>
>
> --
> Thanks And Reagrds
> Amish Manubhai Shah (Intra Action Software)
>
>
>
- Next message: Savas Ates: "Type Mismatch Error(numeric values)"
- Previous message: David Gugick: "Re: Transpose / flatten / rows to columns"
- In reply to: Amish Manubhai Shah: "parameter name problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
