Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
After upgrade to 22.1

user13413951
Member Posts: 12 Blue Ribbon
Previous to 22.1, I have date columns in report which had format mask set to an item.
So the format might be &P1_DATE_FORMAT. P1_DATE_FORMAT could be set to MM/DD/YYYY or DD-MON-YYYY...whatever it might be, it functioned properly.
In version through 20.1 this would render and export CSV without issue.
In 22.1 this works fine when rendering the report. If the value of the item changes the format of the date column in the report is updated to the correct format.
However, when exporting to CSV, apex returns error about not being able to convert datatype 3 to varchar2.
Only after I remove the &P1_DATE_FORMAT. from the format mask will it export to CSV.
Is this a bug in 22.1 or a purposeful change in functionality.