Adding a button to a page which initiates PL/SQL logic

Advertisement
November 30

Hi,
I would like to add a button onto an apex page which runs some pl/sql logic.
Such as:
Start PL/SQL   <--- This is the button
Which does the following pl/sql (this is just an example):
DECLARE
v_tmp INTEGER;
BEGIN
SELECT 1 INTO v_tmp FROM DUAL;
END;I have tried a couple of suggestions found within this forum, they did not work (no errors, just a "button" did not appear). I have also tried the suggestion in the APEX 2.2 Developers Guide, in section 6-10, titled "Add a Process". Again, this did not work, no errors, just no button either.
We have rdbms 10.2.0.1.0, and 2.2.0 apex.
Thanks! --Kate                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               

Advertisement

Replay

Wow, can't get anymore complete than a hollywood movie to demonstrate functionality. Thanks John and Tom, I think you were both saying the same thing, John just put it in a nice and easy wrapper!
It worked great, I have never used this tool before (heard lots about it) and was literally given the request a mere few hours ago to create a page that does X when a button is pressed. Thanks to you, it's done. --Kate                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

View 5 Replies

Adding interactive buttons in Acrobat X Standard disables the Commenting and markup tools

October 11

Why does adding interactive buttons to PDFs in Acrobat X Standard disable the Commenting and markup tools in the PDFs, but only when they are viewed in the Reader, not when opened in Acrobat?  When the buttons are removed, the Commenting and markup t

View All Replies

Get started now button to this page, your thoughts?

November 30

Hi, I was thinking about adding a very large "get started now" button to this page Custom Website Design, what do you think? Thanks, Stefan Web Designer / Developer Website Search Engine Optimization Expert Blue Barn Graphics www.bluebarngraphic

View All Replies

How to use a back button in action pages?

October 11

Hi all, I have created a user login page,home page and user profile page. If the user provide correct username and password in the login page he will be taken to home page. In the home page he will be having his username and a link to view his profil

View All Replies

Why is it showing "go" button in the page of R12?

November 30

Who encount the situation that sometimes page shows a "go" button behind some item which has fireAction in the EBS R12. how can I close the function. I think whether it is about profile? Thanks;Yes....you have to set a profile option for that...

View All Replies

• I am an experienced user and CC member.  My request is that I be allowed to download the InDesign CC app please., even though I previously mistakenly downloaded InDesign CC (2014) TODAY-and later had to un-install it.  PLEASE DIRECT ME TO A PAGE WHICH H

November 30

• I am an experienced user and CC member.  My request is that I be allowed to download the InDesign CC app please., even though I previously mistakenly downloaded InDesign CC (2014) TODAY-and later had to un-install it.  PLEASE DIRECT ME TO A PAGE WH

View All Replies

I can't get to the Firefox Start Page which has menu items such as Bookmarks, toll , etc

November 30

I can't get to the Firefox Start Page which has menu items such as Bookmarks,Tools , etc.Also there is no back arrow. == This happened == Every time Firefox opened'''''"menu items such as Bookmarks,Tools , etc"''''': That's the Menu Bar; see bel

View All Replies

How to get the values retained on clicking the back button in jsp page

October 11

Hi All, I had two jsp's search and results. In the search page when i enter some values in the text fields, the rsults will be displayed for that search criteria. I had a back button in the results page. When i click on this back button i will get ba

View All Replies

Add a custom button on notification page and open a oaf page after button

October 11

Hi All, My Requirement is add a custom button on notification page and after button click with take some parameter from notification page like supplier_id and org_id then open a new oaf page and show supplier credit and debit balance but problem is t

View All Replies

How to make the common control button for all pages in TABCONTROL​?

October 11

Dear all,            I'm using TABCONTROL for my application. I'm having STOP and SAVE control. I have to show this button to all pages  in TABCONTROL.. How do i make it? Kindly help me?.. Regards, Srinivasan.P Solved! Go to Solution.Hi srinivasan, I

View All Replies

I am new at Captivate 8 and I have created a learning project using an existing power point presentation.  I have added a button that will allow my students to view a video on the subject.  When I run the project in Preview the button works but when I pub

November 30

I am new at Captivate 8 and I have created a learning project using an existing power point presentation.  I have added a button that will allow my students to view a video on the subject.  When I run the project in Preview the button works but when

View All Replies

Cannot copy buttons from one page to another

November 30

Cannot copy buttons from one page to another 95% of attempts. 5% of attempts button copies, but only once. 2nd paste attempt 100% failure.Acrobat X Pro. Microsoft support managed the OS to ensure perfect compliance as I ran the Repair and Update meth

View All Replies

How can i print only pages which have been highlighted, from a multi page file?

October 11

How can i print only pages which have been highlighted, in a multi page file.Ah, I see want you mean. This might not be practical for you, but if you select one instance of the highlighted text and add a [space] to the little sticky note, all of the

View All Replies

HTTPS Lock Icon missing on pages which also have a Reader View

November 30

I navigated to a page which is protected by https (as verified using Firefox), and which also has a Reader View.  On Safari, the Reader View icon (the 4 or so lines) appears on that page, but the Lock icon is not visible at all. Is this a known issue

View All Replies

Build a blank/other type of page which can show links to other pages

November 30

Can someone please tell me how to build a blank/other type of page which can show links to other pages? I mainly want a page to show 3 links, once someone clicks on it, then it will go to a specified page. I tried using URL, but that did not work. An

View All Replies

I upgraded my Firefox and my home page (which I love) is GONE. Not sure how to get it back. I still have my bookmarks though. Thanks in advance for helping me.

October 11

I upgraded my Firefox and my home page (which I love) is GONE. Not sure how to get it back. I still have my bookmarks though. Thanks in advance for helping me.If that didn't help then see this article for more suggestions: * [[Firefox has just update

View All Replies

Why my notebook sometimes blacks out, in Windows 7, when I watch video online or just browse some web pages which contains quite a lot pictures?

November 30

Why my notebook sometimes blacks out, in windows 7,  when I watch video online or just browse some web pages which contains quite a lot pictures? 1. I am not sure whether it is the problem of the graphic hardware, relevant softwares or the system its

View All Replies

How to call jsf page which is in a seperate project

November 30

hi, I am using JDEV 11.1.2.2.0 verrsion. how can i call jsf page which is inside the seperate project.Hi, How is the jsf page deployed? As a separate application or as part of the same application? If it is separate app, you can use the goLink method

View All Replies

My MAC is running slowly and I am having to continually remove unwanted pop ups and leave unwanted pages which appear including MACkeeper. If I am on a sports website, betting pages appear - any ideas?

November 30

My MAC is running slowly and I am having to continually remove unwanted pop ups and leave unwanted pages which appear including MACkeeper. If I am on a sports website, betting pages appear - any ideas?Click here and follow the instructions, or if the

View All Replies

When i open pdf file it open all the pages but some pages give error massage (there was error processing a page,there was a problem reading this document 110) but if i open this page which give me error with google chrome it's work ? if you can help me th

October 11

when i open pdf file it open all the pages but some pages give error massage (there was error processing a page,there was a problem reading this document 110) but if i open this page which give me error with google chrome it's work ? if you can help

View All Replies

Tags:

  1. reset dw fabrica iphone modelo a1418?
  2. iphone 4 does not regonizes sim card
  3. sap sq02
  4. Bbm channels how to add on 9300
  5. how to enable mosh in Cisco routers
  6. Fair photoshop cs4 action
  7. logic 9 for windows 7 200mbs
  8. Neha jpx pothos
  9. FCAREGUL
  10. MacBook 5,4 windows
Copyrights 2017 Fcffair BigData Resource, All rights reserved