Call Oracle stored procedure from the Data Mapper
I am trying to call a stored procedure in a Oracle database that returns a number. Inputs are varchar, date, and numbers. Not all inputs are required.
I tried something like the following, but get an error.
DBQuery {'EXEC Find_ID 'ABC', '100A', 100, 'DEF', 32, '', 'Y', '', 'N', '', '' ', $db_conn, false }
Error: XSL in invalid - Error message: The reference to entity "apos" must end with the ';' delimiter.
Then I found the thread http://support.adeptia.com/entries/21270703-How-to-call-Oracle-Stored-Procedure-from-Mapper but this doesn't explain the parameters to java:ExecuteOracleProcedureForUpdate.execute.
This was my next attempt - Created variable findIDQry -> call FindIDOnly(' '877', 'A', 'A', 'ABC', 100, '', '100A', '', 'AG', 'SMITH', 32, 'M', 'NB', 'C', 'L', 'NY', 'U', '', 'Y', '', '', '', '' ')
java:ExecuteOracleProcedureForUpdate.execute( $_identifier, $db_conn, $_subject, findIDQry)
New Error: Error message: Extra illegal tokens:
Can you please explain the proper way to call an Oracle procedure? Do I need $apos - what is this for and when to use?
Please sign in to leave a comment.
Comments
0 comments