Hi,

 

 

does schema.get_new_id() have any return values? This is necessary. You cannot have return values in the anonymous block in your SQLExecutor (not supported by Oracle), so the function get_new_id() must RETURN the values ID and STATUS to you. Declaring the results as OUT isn't enough here, they must be explicitely returned, i.e. get_new_id() must be a function, not a procedure.

 

 

If you can modify the declaration of get_new_id() to RETURN the results, or eventually create a PL/SQL wrapper function around it to do it, you can then do something like this in your SQLExecutor:

 

 

select ID, STATUS, ERRMSG

 

from table(schema.get_new_id(@Value(obj_id),'@Value(table_name)'))

 

 

You can then expose the resulting ID, STATUS and ERRMSG as feature attributes in the SQLExecutor, as usual.

 

 

See also the example here (http://stackoverflow.com/a/9484311/370301).

 

 

David

 

 

---

Hi,

 

 

does schema.get_new_id() have any return values? This is necessary. You cannot have return values in the anonymous block in your SQLExecutor (not supported by Oracle), so the function get_new_id() must RETURN the values ID and STATUS to you. Declaring the results as OUT isn't enough here, they must be explicitely returned, i.e. get_new_id() must be a function, not a procedure.

 

 

If you can modify the declaration of get_new_id() to RETURN the results, or eventually create a PL/SQL wrapper function around it to do it, you can then do something like this in your SQLExecutor:

 

 

select ID, STATUS, ERRMSG
from table(schema.get_new_id(@Value(obj_id),'@Value(table_name)'))

 

You can then expose the resulting ID, STATUS and ERRMSG as feature attributes in the SQLExecutor, as usual.

 

 

See also the example here http://stackoverflow.com/a/9484311/370301

 

 

David

 

---

David - thanks for your response!  I don't have it solved yet, but this is helpful.

 

---