Multiple choice technology databases

Which one is correct for the following example shows how a stored procedure would be used with output parameters?

  1. <procedure id="swapEmailAddresses" parameterName="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  2. <procedure id="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  3. <procedure name="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>

  4. <procedure propertyName="swapEmailAddresses" parameterMap="swapParameters" > {call swap_email_address (?, ?)} </procedure>
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In iBATIS stored procedures, the correct attribute for parameter mapping is 'parameterMap'. The 'parameterName' attribute doesn't exist in the iBATIS DTD. The procedure uses the parameterMap named 'swapParameters' to map output parameters correctly.

Keep practicing — related questions