span8
span4
span8
span4
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 afunction,not aprocedure.
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,ERRMSGfrom table(schema.get_new_id(@Value(obj_id),'@Value(table_name)'))
Oracle stored function return value2 Answers
SQLExecutor,Geometry and Oracle Database5 Answers
Why can't I update an Oracle Date field using SqlExecutor5 Answers
How to call an Oracle DB function on Insert1 Answer
How to properly retrieve multiple-tables results of a sqlserver stored procedure ?0 Answers
© 2019 亚搏在线Safe Software Inc |Legal