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.

Error handling while loading the data in Oracle Apex 22.1.4

Annamalai VOct 20 2022

I am using Oracle Apex 22.1.4 version. My requirement is to capture the error records and store them somewhere else while loading the data from xlsx/csv file.
If it's stored in some error log tables/ somewhere else internally, I can create a report on top of that table and display them to the users.
I saw one of the blogs from Oracle and I came to know that it was a very simple and easy method of capturing error records and storing them in Error tables in Oracle Apex 19.1
https://blogs.oracle.com/apex/post/quick-and-easy-data-loading-with-apex-191 Is there any similar way of capturing error data and storing them in Oracle Apex 22.1?
If yes, please give me suggestions.

Thanks,
Annamalai V.

This post has been answered by jariola on Oct 21 2022
Jump to Answer

Comments

Rahul,

Always mention your JDev version.

Your usecase is not clear to me. If you want to split the array and display the strings in the output text, check out if you could use af:forEach / af:iterator (with an output text inside it).

-Arun

user8696578

Hi Arun,

Yes you are correct I am using af:foreach.

Can you tell me what would the value of the outputtext point to(since it is a String). As the iterator is pointing to a list of items. and it also has a var property as items.

Jdeveloper 11.1.1.7.0

Regards,

Rahul

Rahul,

Here is a simple ex:

JSPX :

<af:panelBox id="pb1">
<af:forEach var="items" items="#{viewScope.MyBean.stringList}">
<af:outputText id="ot1" value="#{items}"/>
</af:forEach>
</af:panelBox>

Bean :

public class MyBean {

private List<String> stringList;

    public void setStringList(List<String> stringList) {
        this.stringList = stringList;
    }

    public List<String> getStringList() {
        return stringList;
    }

    public MyBean() {
        super();
        stringList = new ArrayList<String>();
        stringList.add("One");
        stringList.add("Two");
        stringList.add("Three");
        stringList.add("Four");
        stringList.add("Five");

}

}

-Arun

B

user8696578

Thanks Arun. It Worked

1 - 4

Post Details

Added on Oct 20 2022
4 comments
115 views