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!

Question about Save Before Exit Plug-In for button with pop-up region

839839May 6 2014 — edited May 19 2014

Hi,

This Plug-In has been really useful, but i am trying to get it to work in the following scenario with no result.

On my page i have 3 buttons, Cancel, Details, Delete. The plug in works great on Cancel and Delete.

Details button(which is enabled when a row or multiple row has been selected) has a pop-up which allows me to enter some data lower in the hierarchy for a particular row. Here also i would like the plug in to work before it pops-up the data screen.

The steps i am following are - i change the job of empno - 7782 from MANAGER to CLERK. Then i click on cancel, the save before exit message is displayed.    - PERFECT

Now i check the check box for the same line (empno - 7782) and click on delete , it confirms if i want to delete and after i say yes, the save before exit message is displayed.    -PERFECT

Now leaving it checked(empno - 7782) i click on Details button, a pop-up region is displayed where i can enter some information ( it will have save and cancel button in this region). - I want the save before exit message to be displayed before this pop-up region is displayed  - HELP

I am using Apex 4.1 and i am relatively new to apex. I hope i have provided you with all the necessary information.

I have also created the scenario in

https://apex.oracle.com/pls/apex/f?p=32321:LOGIN_DESKTOP:111046025786433

user: stephania.menezes@gmail.com

password: Steff@123%

Thanks guys.

Comments

unknown-7404
Just trying to get my query results of a function into normal grid format in SQL Developer to start.

Then please mark the thread ANSWERED and repost it in the Sql Dev forum.

CarlosDLG
Answer

f53c6a20-e62f-4f52-bc99-1d04d284511c wrote:

Just trying to get my query results of a function into normal grid format in SQL Developer to start.

However, my output is stuffed into a single column when I run it from a select() from dual. Even though the output variables window shows output formatted just fine in grid format.

oneline.jpg

I’m running a function like this:

SELECT function_with_sql(sysdate) from dual;

The function has a cursor defined like this:

RETURN sys_refcursor
AS o_cursor SYS_REFCURSOR;
Begin
open o_cursor for

select……………
Return o_cursor;
End;
/

How do I get the output formatted in normal grid format?

Thanks!

Your function returns a ref cursor. You cannot do that with a ref cursor. Why would you want to do that?

You probably don't understand ref cursors. Here is a recommended read:

Marked as Answer by f53c6a20-e62f-4f52-bc99-1d04d284511c · Sep 27 2020
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 16 2014
Added on May 6 2014
3 comments
302 views