Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Shared Component - List of Values - slow to load on Oracle Cloud

Jon BarwellDec 10 2020

We are getting really slow performance from an APEX environment on the Oracle Cloud when defining List of Values as shared components.
When we try to open a list of values that uses a SQL statement it is taking 30-40 seconds to open the page, if it's a static list then opens right away.
Is this a known issue?

This post has been answered by AceSobe on Dec 11 2020
Jump to Answer

Comments

EdStevens

In that undelimited string of input data, what is the 'id', what is the 'sid', and what is the 'date'?

Frank Kulash

Hi, @user-iap38
Whenever you have a problem, please post a complete test script that the people who want to help you can run to re-create the problem and test their ideas. In this case, include a CREATE TABLE statement and a complete data file, including any special cases you may need to handle, and as much of the control file as you can write. Always give your full Oracle version (e.g. 18.4.0.0.0).
in SQL loaded that csv file contains the data as below format
1111320220124
1121420220124
Is this really a csv file? There aren't any commas. Are you saying the csv file looks like this
A,1111320220124,1.6
B,1121420220124,.9
and the second column (always exactly 13 digits) needs to be broken into three columns (a three-digit NUMBER, a 2-digit NUMBER and a DATE)?

BluShadow

CSV = Character Separated Values
Your data = No characters separating anything.
Regardless, you can use position format in your SQL*Loader control file to specify the exact positions and sizes of each "field" in the data.
SQL*Loader Field List Reference (0 Bytes)

selvi m

i have updated with actual code and details
Thanks

BluShadow

So, now you've updated it (which makes our answers look out of place, so don't do that, just add comments with further information if you must)... what's not working with the control file you've created?

Frank Kulash
Answer

Hi, User_IAP38
You can use this control file:

-- SQLLOADER CTL FILE
LOAD DATA
REPLACE
INTO TABLE tmp_order
DATE FORMAT "YYYYMMDD"
TRAILING NULLCOLS
(
ID       POSITION(1:3)  INTEGER EXTERNAL(3),
SID      POSITION(4:5)  INTEGER EXTERNAL(2),
EXP_DATE POSITION(6:13) DATE    EXTERNAL(8)
)

Make sure POSITION is spelled correctly

Marked as Answer by selvi m · Jan 25 2022
1 - 6

Post Details

Added on Dec 10 2020
21 comments
809 views