1 reply to this topic

[John Robson]

Is it possible for ProIV to receive a return value from a PL/SQL function or procedure?

I am trying to call a PL/SQL procedure from a ProIV function and want to use a value returned from it.

Cheers

[Dan Shannon]

It does work - sometimes - but it's not supported.

You can do it using a file definition and appropriate SQL:

File def: AK RESULT_VARIABLE ALPHA 250

SQL
SELECT my_plsql_function(parameter1, parameter2 ... parametern)
FROM dual
ENDSQL

Then it's a case of reading the file in lookup mode.

Cheers

Dan Shannon