Skip to Content
avatar image
Former Member

Getting o/p from Oracle procedure in MII 14

Dear Experts,

I have written procedure in oracle with 2 input param and 1 output param.

Tried with CALL USP_UPD_NOTIFICATION('[Param.1]','[Param.2]') but giving error "wrong number of parameter"

Can anyone please let me know syntax for calling procedure from SAP MII so that i can get o/p?

Thanks in advance

Regards,

Neha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 02, 2015 at 07:34 AM

    Hi Neha, Did you check how many params you created in Stored Procedure definition? There may be mismatch in passing Params and receiving params at SP side. Thanks, Ayush

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 07:36 AM

    Also Try with EXEC Procdure_Name Validate if you have selected proper data server and Mode in Query Template

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Swaroop Anasane

      Thank you Swaroop for response.

      I have tried with both above syntax and Param.1 and Param.2 as input parameter.

      I want to access output variable of procedure.If execute procedure with above syntax and two input parameter then it gives following error:

      SQL error has occurred on query ORA-00900: invalid SQL statement

      Can you please help me for accessing o/p variable of procedure?

  • Nov 02, 2015 at 09:54 AM

    Neha,

    I am using fixed query with output as below in the fixed query text box:

    declare

    indOn MyActivityInsert.ACT_CURSOR;

    begin

    ActualTrans(:indOn,[Param.1],'[Param.2]');

    commit;

    end;

    ActualTrans is the procedure and indOn is the cursor which is returning the value as document.UpdCall.getValue(1,1) in JavaScript function where UpdCall is iCommand object

    <APPLET  style="visibility:hidden" NAME="UpdCall" CODEBASE="/XMII/Classes" CODE="iCommand" ARCHIVE="illum8.zip" WIDTH="1" HEIGHT="1" MAYSCRIPT>

    <PARAM NAME="QueryTemplate" VALUE="MyProj/CallQuery">

    </APPLET>

    Thanks,

    Raman N

    Add comment
    10|10000 characters needed characters exceeded