@weili liu ....I had one requirement....can you help me ? I need to accept only CSV-UTF 8 file format only . How can I give that validation in Oracle Apex while uploading the file. I mean only CSV-UTF 8 format files need to be accepted not any other file formats(including CSV)
@@Equality4477 Sorry to respond you late. My recommended way is you can prompt user to specify the charset set when you upload the file on the page. Oracle APEX or PL/SQL can't get the charset of uploaded file because the file type is blob so far.
@@weililiu2119 thank you so much for taking time to work this issue. Thank you so much for remembering and texting back. As far as now , I am using this method(message for users). Thanks alot once again.👍🏻
learning very impressive things from you. Thank you for breaking down such a complex topic in such an understandable way.
Yes, it is somewhat difficult, otherwise the issue would have been discussed a lot. I thank❤ you for your humility
@weili liu ....I had one requirement....can you help me ?
I need to accept only CSV-UTF 8 file format only . How can I give that validation in Oracle Apex while uploading the file. I mean only CSV-UTF 8 format files need to be accepted not any other file formats(including CSV)
I will consider it if I am available. Thank you for your interest.
@@weililiu2119 Thank you for responding. ❤️
@@Equality4477 Sorry to respond you late. My recommended way is you can prompt user to specify the charset set when you upload the file on the page. Oracle APEX or PL/SQL can't get the charset of uploaded file because the file type is blob so far.
@@weililiu2119 thank you so much for taking time to work this issue. Thank you so much for remembering and texting back. As far as now , I am using this method(message for users). Thanks alot once again.👍🏻
❤ well done
Getting error ora-01722 invalid line number while uploading csv file. Please help
I will check it
I guess that your source file format cause this error.
How do I retrieve the page count of a PDF document into a column during insert? I would like to see this
❤
Good question! I will
Please make a video on validation of form in Apex
I will. Thanks.
No one addressed that at Apex