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!

Function returns SQL query in CLOB. How can I have Apex run this?

562051Jun 7 2007 — edited Jun 8 2007

Hi there, guys.

I have a PL/SQL function in my database which dyamically creates a SQL query which is then returned as a CLOB.

What I would like to do is have Apex call this function, retrieve the SQL query from the CLOB, execute it and display the results on screen.

My ApEx knowledge is very poor but I do occasionally have to field these tasks in the workplace. I would be extremely grateful if someone could provide advice on how to do this in Apex. I have a page with a report region at the moment.

Thanks in advance for any advice you can offer.

S>

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2007

Added on Jun 7 2007

#apex-discussions

3 comments

1,348 views