Problem Calling MaxDB stored procedure with output from MII Query template

[Former Member]

Hi,

I am using Max DB Database studio to write stored procedure, I am calling stored procedure from MII Query using CALL statement.

Can anyone guide me how to pass output values of stored procedure.

Examlpe::

call ProcName('[Param.1]','[Param.2]','[Param.3]','[Param.4]','[Param.5]', :isSuccess, :Trace)

In the above line of code I am not able to get the output values of stored procedure that is isSuccess and Trace values in Query template when executed. But same thing I get when executed in Database studio.

How do I call with outputs for any stored procedure in MII.

Any help would be appriciated.

Thanks,

Padma

[Former Member]

Hi Padma,

In your query inside of MII, what Mode are you using? Have you tried "FixedQueryWithOutput" mode?

Kind Regards,

Diana Hoppe

[Former Member]

Hi Diana,

yes I am using Fixed Query with output Mode.

Regards,

Padma

[Former Member]

Sorry Padma, that mode is for Oracle stored procedures. I'm not sure if this will be helpful, but take a look at this link, which is for MSSQL, but may shed some insight for MaxDB as well.

[]

- Diana

[Former Member]

Rao,

I've been doing some experimenting with calling a MaxDB stored procedure with output from MII - what error are you getting in FixedQuery mode? Please let me know.

Thanks,

Diana

[Former Member]

My call statement is like this

call RESULTDATA_INSERT('[Param.1]','[Param.2]','[Param.3]', :isSuccess, :Trace)

I am able to insert record in DB, But I am not getting output values in Query template.I have done this in Fixed Query, when I execute it throws me "Fatal error as Loaded content empty".

I tried giving select below call but it dont work.

Regards,

Rao

[Former Member]

Hi Rao,

I am having similar issues to you, I'm not sure if it is related to the driver or with MII - I work in the MII component, and I am consulting with colleagues to resolve the issue. I'll let you know when I get more information.

Kind Regards,

Diana Hoppe

[Former Member]

I am having the same issue in 12.1, did you by any chance solve this?

[Former Member]

Hi Simon,

I was never able to find a resolution for this issue. I advise that you create a ticket in the SAP Support system. I could call the stored procedure from Database Studio and return a result set, but I could not do it from MII, using FixedQuery or FixedQueryWithOutput modes. I'm thinking it may be an issue with the driver.

Kind Regards,

Diana Hoppe

Edited by: Diana Hoppe on May 27, 2011 11:09 AM