Parameter in Query manager running stored procedure

[Former Member]

Hi Experts!

I have a stored procedure, which is waiting a parameter.

I would like to write a query in sap with parameter using sap language:

exec sp_leltar [%0]

The parameter is numeric, but when running the query above, it is giving an error:"Userdefined errors".

Any idea?Thats not a way to write the parameter value on editor field.

[Former Member]

Try this one:

/*select * from dbo.omaleltfej t0*/

declare @leltid numeric OUTPUT

/* where*/

set @leltid = /* t0._leltfejid */ [%0\]

exec omaleltareredmeny2 @leltid

[Former Member]

Sorry, but doesnt work:

Error message:"Service contracts'(CSHS)

I think it cannot be solved due to sap limitation, can it?

[Former Member]

Based on that thread, someone got it running before. So this could be done. You have to make sure your SP and parameter are set up correctly. What is your SQL Server version?

[Former Member]

Hi

I think you are missing a quotation in the parameter

try using

exec ....'[%0]'

Hope this helps

Bishal

[Former Member]

I have tried this query writing a parameter, it works:

/select from dbo.omaleltfej t0/

declare @leltid numeric

/* where*/

set @leltid = /* t0._leltfejid */ 10

exec omaleltareredmeny2 @leltid

But when changing for [%0],then no.

[Former Member]

Have you added OUTPUT ?

[former_member204969]

To enter parameter for an SBO query you should use a table known by the system. It may be a system or a user defined table. Your table is not an SBO table.

You could use any SBO table to get the numeric value and use it in the procedure call

(Try the parameter cachig first in a simple query, using

. . .

Select @leltid

[Former Member]

I have tried to run the following:

select from dbo.omaleltfej t0/

declare @leltid numeric OUTPUT

/* where*/

set @leltid = /* t0._leltfejid */ [%0]

exec omaleltareredmeny2 @leltid

Error message:"...Can not use the output option in declare or create function statement..."

I gave up to solve it, because this is not an SAP table, it is not possibble to do.

Thank you for your effort.

[Former Member]

HI

Take a look at this thread

This might be of help

Thank you

Bishal

[Former Member]

Hi!

I have used the example, writing this:

/*select * from dbo.omaleltfej t0*/

declare @leltid numeric

/* where*/

set @leltid = /* t0._leltfejid */ [%0]

exec omaleltareredmeny2 @leltid

Error message:"Incorrect syntax near '0'.

Any idea?

[Former Member]

I am afraid you have to use predefined parameter for SP, not [%0\] after the EXEC SP. You may declare the parameter first.

Thanks,

Gordon