Question

Excel Migration with Procedure


Badge +4

Hi guys..

How to get ‘OUT’ value from procedure in Migration Job Excel Migration?


This topic has been closed for comments

4 replies

Userlevel 5
Badge +6

Hi @rendywinata_,

 

You can define the return-value from the function as a OUT-parameter in the source column section.

Please refer the following.

 

Calling Functions from Method List

We may now also invoke functions from the Method List. They will be handled in Method List Attributes in the same manner as procedures.

  1. The return-value from the function is defined as OUT-parameter FUNCTION_RESULT.
  2.  The IN-parameter is defined in same manner as parameters for procedures.

    TipsAn28.jpg
  3.  The result of the function may be used in following methods.

    TipsAn29.jpg

 

Cheers,

Thilini

Badge +4

Hi @Thilini Aluthweediya 

 

thank you for your answered.

true to return a function value like that.
but how do you return the value of a procedure that has the IN OUT flag?

Userlevel 5
Badge +6

Hi @rendywinata_,

Check below attached  example which has uses a procedure with IN OUT parameter.

I have not try out this but you may refer and see.

 

Cheers,

Thilini

 

 

Badge +4

thank you for helping me @Thilini Aluthweediya 

in the document it still doesn't explain how to use it.