Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

File browse - granularity of maximum file size

Scott WesleyAug 3 2022

Hi,
If I set a limit on the maximum file size property of a file browse item to 1900000/1024, this translates to a property of
data-max-file-size="1855.46875"
There are numerous sizes reports for a particular file in windows, but this appears to validate my file size base on the 'Size' value when viewing file properties
image.pngimage.png1899008/1024 is 1854 and succeeds.
1902080/1024 is 1857 and fails.
However, the client side validation message the appears on the page rounds to 2mb, with a message of:

File is too large. Maximum file size is 2 MB.

image.pngIn our view this is significantly different to apparent size the user sees for the file.
Is there any way to give this message more granularity?
I suspect no, since this comes from displayFileSize() JS function in widget.fileBrowser.js, which would even round 1550 to 2mb.
This is in APEX 20.2
Scott

Comments

mariohik

I tried to follow the steps on this "https://docs.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping" page but couldn't generate sql because it can't convert string[] or IEnumerable<string> to the parameter.

Alex Keh-Oracle

The most straightforward way is to use FromSqlRaw to call the SQL directly.

mariohik

@alex-keh-oracle ,
.NET 7.0 allow us to use string.Join (C# code) on our query.
Will Oracle convert string.Joing (C# code) to LISTAGG (PL/SQL code)?

Alex Keh-Oracle

I'm not sure I understand the question. The .NET String class does not have an implementation that ODP.NET can override unless you are asking about ODP.NET OracleString class.

1 - 4

Post Details

Added on Aug 3 2022
#apex, #apex-discussions, #apex20-2
1 comment
758 views