Oracle Application Express (MOSC)

MOSC Banner

Why am I getting "no data found" when uploading an Excel file to Application Express (APEX)?

We are using Apex version 21.2.0.

We have an application which uploads an Excel spreadsheet and displays it in a preview region. The file is parsed using the following statement:

select p.line_number,
p.col001, p.col002, p.col003, p.col004, p.col005, p.col006, p.col007, p.col008, p.col009, p.col010, p.col011, p.col012, p.col013
-- add more columns (col011 to col300) here.
from apex_application_temp_files f,
table( apex_data_parser.parse(
p_content => f.blob_content,
p_file_name => f.filename,
p_xlsx_sheet_name => case when :P4002_XLSX_WORKSHEET is not null then :P4002_XLSX_WORKSHEET end,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center