ti3r wrote:What are the data types of start_merge_code and end_merge_code columns??
In my APEX application, have a textfield on a page in which user enters a code in the format 111-000-461. The textfield item is called p1_searchmergecode
My query in a report region is this
select * from t3_mail_piece
where :P1_searchmergecode BETWEEN start_merge_code and end_merge_code
ti3r wrote:When you run the page via the apex builder you can click on the "Session" link down in the developer toolbar and see the value that was submitted to the page?
Yes it maintains session state per session.
Now when I run it instead of getting no data like yesterday I get this error: "an into clause is expected in this select statement"Make sure that your report region type is still set to "SQL Query" and not "SQL Query (PL/SQL function body returning SQL query)"