How can I use ?,&,= symbols in Oracle ORDS 18.2 URI Template?
Can I use ?,&, = symbols in Oracle APEX ORDS 18.2 version services URLs? The system shows me.URI Template may contain only alphabetic, numeric, underscore, dash, period, and forward slash characters, or may contain a single trailing asterisk. I can I use custom URL type?
Solution
The direct answer is you can't use them to define a URI template. The query string does not need to be defined all params are auto converted to binds.
For example: Calling /hr/employees/?ename=SMITH the uri template doesn't need the '?name='. That is auto added to being a bind. In the sql/plsql the code can just reference :ename
Here's a screen shot of the example >>
- Display user friendly error message while logging SQL error into debugger
- Report Queries in data dictionary APEX
- plsql select with conditional stateful colors
- Oracle Apex - How to prevent escape HTML in e-mail templates?
- Oracle Apex: ORA-24344 Success with compilation error
- How to select today date and time in date picker field by default
- Oracle Apex passing item results from a Select list to another Select list on the same page
- How can I prevent add duplicate items to APEX_COLLECTION
- Oracle Apex Server-side Code do not set item
- How to Show the History Details of Oracle Apex Application Changes?
- Conditionally Formatting background color for Interactive Report Cells of type link
- Custom Event not triggered on Modal Dialog Page
- Exporting Combined Data from Multiple SQL Queries into a Single CSV Report in Oracle APEX
- setting a datetime into global application item
- Why I got error Ajax call returned server error ORA-01422: exact fetch returns more than requested number of rows for ajax_dispatch_request.?
- Populating Form Items with Values from an Uploaded CSV File in Oracle APEX
- Oracle Apex Change date picker format
- Select a row in a IG when dialog closed
- Set page item with value from interactive grid column when clicking on the grid region
- Can't disable session state protection on Oracle APEX 18.1.0.00.45 for Dynamic Actions updating Page Items
- Authentication scheme subscription gets lost on deployment of Apex applications
- Is there a way to modify the Rich Text Editor toolbar in an apex application when the editor is in a column inside an interactive grid?
- Oracle APEX - What is source of "Request" in "Request is contained in Value"
- Custom user attributes in Oracle Apex / User-specific filtering based on attributes
- Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-00302: component 'GET_EMP_INFO' must be declared"
- Maximizing a region using jQuery
- How to Handle Large REST API Responses in Oracle APEX Exceeding Page Item Character Limits
- Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field
- Oracle Apex page process calling stored procedure not working
- How can I keep anonymous user account perpetually open on Apex 19.2 running on Oracle DB 21c XE?