Hi, I am struggling with a test case. I have a procedure which if provided with a transfer id returns the details of the transfer in a ref cursor.
I defined the cursor as follows within the “Changed by program” properties as a query.
SELECT schedule_id, schedule_end_date, schedule_frequency_name,
from_account_number, from_company_number, from_hogan_product_cd,
to_account_number, to_company_number, to_hogan_product_cd,
transfer_date, transfer_reference_date, transfer_status_name,
create_date, create_by_ecn, create_channel_name, create_by_banker,
modify_channel_date, modify_by_ecn, modify_channel_name,
I changed the operator to “#=”.
I changed the expected results to “Integer” and under “Single Value or Expression” I entered 1.
When I try to run, I get a compile error which reads “The properties of Changed by Program or Expected Results (whichever is a cursor variable) must specify a valid SELECT statement, which Quest Code Tester will use to determine the list of elements in the SELECT list of the cursor variable. You cannot use an expression for this purpose.”
What am I doing wrong?