HI @mmmaria - I don't expect it needs to load the whole table, only the records that are in the export. If you can share the export query generated in the logfile we could take a look, or perhaps speak with SAS Tech Support for a deep dive into what is happening.
As a test you have you tried exporting to a table that has that column as a character type and don use the Calculated Item - just to be sure that its the calculated item causing the problem ?
To answer you're original question, with CI Studio there is no way to use Oracle Functions directly. You could perhaps create a view in the database that does this conversion, and then use that view in CI Studio.
Regards James
... View more