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!

Oracle Apex Hierarchical Data View

4164142Jan 6 2020 — edited Jan 6 2020

I am creating a pretty basic CRUD application with Oracle Apex. I simply want to create a hierarchy based on some logic that spans 4 tables all on one page. In our current application which we are trying to convert to Oracle Apex we have a list of nodes that when we click on them we can display their children tables in the main view.

Lets say we have 4 tables, each with Primary Keys that relate to one another. How do I display certain values from these tables on the page all at the same time? I have tried some of the wizards that Apex provides but with no success. I think it will have to be custom PL/SQL logic. The data has to be in a certain order as well.

1

2

3

4

How can I create a view similar to this?

pastedImage_0.png

pastedImage_3.png

Comments

Kalpataru

Try this

crlf varchar2(2) := chr(10)||chr(13);

it will work.

HamidHelal

What is your database version ?

Did you give privilege SYS UTL_ENCODE,UTL_SMTP and UTL_TCP to the user ? Are you assign the Mail serve port ?

Hamid

Hmusman

i user oracle 10 g and tell me way how to assign privileges to user

Kalpataru

Hi Hmusman,

Which privilege you are talking about.

If you want to give privilege to user connect to sys as sysdba give grant.

grant execute on FSC.SEND_MAIL to scott; <--scott is the username i have taken scott. You change according to your's username.

grant execute on UTL_ENCODE to scott;

grant execute on UTL_SMTP to scott;

grant execute on UTL_TCP to scott;

Hmusman

i use oracle express edition so i cant i find

.SEND_MAIL , UTL_ENCODE, UTL_SMTP, UTL_TCP

HamidHelal 
Hmusman wrote:




i use oracle express edition so i cant i find


.SEND_MAIL , UTL_ENCODE, UTL_SMTP, UTL_TCP

This are the content of SYS. I don't remember Oracle XE has this.

Just connect SYS as SYSDBA and

issue

grant execute on UTL_ENCODE to <user_name>;

grant execute on UTL_SMTP to <user_name>;

grant execute on UTL_TCP to <user_name>;


Hope this helps


Hamid

1 person found this helpful
1 - 6

Post Details

Added on Jan 6 2020
#apex-discussions, #tree, #xml
1 comment
1,268 views