Application Express :: Showing A Message From A Button?

May 22, 2013

I have a button with an dynamic action , with sql:

declare
errors varchar2(100);
begin
apex_application.g_print_success_message := 'test message';
errors:=package.function_some_process_returning_varchar100_with_errors_or_sucess;
HTP.p ('<script language="JavaScript"> alert('''||errors||'''); </script>');
end;

The first "test message" is not shown.and after the function (it is executed fine) i get the next error:

Error:Parsererror - SysntaxError: Unexpected token <

i i only leve the first line (g_print_sucess) nothing occurs clicking the button.

I only want to show on a popup the result from the function, but g_print_sucess seems not to work for some reason.

View 1 Replies


ADVERTISEMENT

Application Express :: Tree View On Application Builder Not Showing

Jul 16, 2012

I have some applications on Apex public workspace (apex.oracle.com), and suddenly the Tree View, on Application Builder stopped showing any content. If I select "Component View", I see the page components, but if I switch to tree view, it shows me only some empty frames.

View 2 Replies View Related

Forms :: Showing Message When Canvas Changing?

Jan 6, 2012

I am facing one confusion with canvas changing and message displaying issue i have one login page. in that there are three fields username,password and department in the department i having 5 departments including salesandmarketing

the requirement once i entered every credentials correctly and i am logging in as salesandmarketing. When the salesandmarketing canvas opens a message should display saying "you are successfully entered into sales and marketing".

i have my home page as content canvas and sales and marketing as tab canvasi need to do the same message when i am entering into 5 departments with corresponding department name in the message end instead of salesandmarketing
is it possible to do with when_new_canvas

View 1 Replies View Related

Application Express :: 4.2 Developer Page Not Showing Up After Installing Over 10g

Dec 6, 2012

So as luck would have it my Win XP OS crashed. Yes, its the office laptop and I cannot upgrade the OS for now. Anyhow, I got the whole machine re-imaged and installed 10g which had version 2.1 and everything was okay. I was earlier running apex 4.1.1. I could not find that setup on the oracle site so I downloaded apex 4.2 and ran the installation as per page

[URL].........

Everything went through properly except for step

5. Log back into SQL*Plus (as above) and load images:

SQL> @apxldimg.sql APEX_HOME

[Note: APEX_HOME is the directory you specified when unzipping the file. For example, with Windows 'C:'.]

where it asked me to enter the directory and I entered C:

This is what happened

SQL> @apxldimg.sql

PL/SQL procedure successfully completed.

Enter value for 1: C:
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as 'C:/apex/images'

Directory created.

^C
C:apex>

I see a backslash and forward slash so I did a ctrl c . When I tried running the command again - @apxldimg.sql

it just would open the .sql file.

Not sure if this is the issue, but anyhow, after this, when I tried the "go to database page. It just shows a blank page. I was happy with 4.1.1. Is that available anywhere? Maybe I can remove XE and do a fresh install with that.

View 5 Replies View Related

Application Express :: SQL Workshop - Object Browser - Not Showing All Constraints

Apr 15, 2013

I have a table with about 15-20 constraints and when I look up the tables constraints in SQL workshop, I can only see 10 constraints. Not sure if its a bug or I need to configure something, somewhere to make it show alll my constraints. I can see all constraints by querying the user_constraints view.

View 1 Replies View Related

Application Express :: 4.2.2.0.11 Page Item Session State Not Showing?

Sep 20, 2013

I have searched for comment on this, but could'n find. So problem is ... not all of the page items are showing in SESSION STATE.

View 4 Replies View Related

Application Express :: Message Box With Report?

Nov 1, 2012

I created a report and in this report there is a likeable colummn and when its been cliked I need its show a message box containing a text that cames from field on a tables in my database.

View 1 Replies View Related

Application Express :: Showing Particular Row In A Color Depending On A Column In Classical Report

May 31, 2013

I have a classical report with a column as "Affirmation Status". This column can take three value as "Affirmed, Rejected or NA". My requirement is I have to show all row in one color like red wherever it has value affirmed, and all row in color like green wherever it is rejected.

View 4 Replies View Related

Application Express :: Showing New Rows Added To Tabular Form After Submit?

Jan 30, 2013

How i can show the new added rows to tabular form after submit? what I want is to show my customer new added rows that recently added. but according to how I sort the tabular form, the new added rows distributed in multi pagination in tabular form. I'm not good in English, excuse me for my mistakes. I use apex 4.2.0 On Oracle 11g r2 on windows Server 2008

View 2 Replies View Related

Application Express :: How To Make Error Message Red

May 20, 2013

A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,

I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?

View 2 Replies View Related

Application Express :: Button Placement On APEX Application Page?

Mar 6, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 3 Replies View Related

Application Express :: Image Stored In Table Is Not Showing In HTML Or Report Region

Aug 22, 2012

I am using apex 4.1 and database as oracle 11g. I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> (     "ID" NUMBER,
>>     "HR_ID" NUMBER NOT NULL ENABLE,
>>     "PHOTO_BLOB" BLOB,
>>     "MIME_TYPE" VARCHAR2(64),
>>     PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

[URL].......

[URL]........

But the image is not getting populated in the region, I tried with display_item with image i am able to view the image using this item.

View 19 Replies View Related

Application Express :: Message Display Before Submit To Record

Nov 5, 2012

I have created two page process with two buttons "APPROVE" AND "CANCEL" button. first page process running approve invoice procedure on approve button and second page process running cancel invoice procedure on cancel button. i want to display massage before approve invoice and cancel invoice (DO you want to approve invoice) on approve button and (Do you want to cancel invoice on ) cancel button.

Working with apex4.1.

View 4 Replies View Related

Application Express :: Delete Message Not Displaying When Upgrade To 4.1

Jul 31, 2012

I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.

<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action

redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');

now all I receive is a message from the webpage, instead of the message.

View 4 Replies View Related

Application Express :: 4.1.1 - Tabular Form Updated Row Message

Oct 31, 2012

In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:

16 rows updated, 0 rows inserted (the standard message).

I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.

Here are some info regarding my tabular form:

8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.

View 0 Replies View Related

Forms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message

Jan 15, 2013

I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".

I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.

View 2 Replies View Related

Application Express :: How To Show Alert Message In Home Page

Jun 11, 2012

I have leave application form based on the LEAVE table, it has the following columns,

leave_id(primary key)
emp_name
from_date
to_date
no_of_days

Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?

View 5 Replies View Related

Application Express :: Display Success Message Without Reloading Page

Feb 22, 2013

I have the following problem.

By clicking on a button on my page, I execute a Dynamic Action. That Dynamic Action consists of several True Actions, one of which is Execute PL/SQL code where I execute a procedure. I'm doing this without submitting the page, and that works fine.

However, I would like to display an error message on the top of the page, in case my procedure returns an error, and I would like to do that without submitting the page.

Is this possible?

View 6 Replies View Related

Application Express :: Display Custom Message For Report When Record Count Returned

Nov 8, 2012

Our application has a homepage that displays results of several SQL statements that are defined as reports. One report in particular should only display a custom message when Count of Invoices having a particular status > 0, and not the actual invoice count itself.

I have gotten the layout to not display the count but I need to be able to display a custom message that says "Problem Invoices exist. Please see Invoices Report for more information." I've looked over the Report Attributes definition page but I cannot find how to display this custom message.

View 2 Replies View Related

Application Express :: Default Submit Button

Jun 16, 2013

I am new in apex i create form with report when i create record it submit page to its report its ok but can i change page on condition base.

View 8 Replies View Related

Application Express :: Export To CSV Button On SQL Report?

Jul 24, 2012

am trying to Export an SQL report to a CSV using a button. I made the button request to 'CSV' but I am unable to generate, the same works for an IR report. I am using Oracle APEX 4.0 version.

View 1 Replies View Related

Application Express :: Center A Button Within Region?

Feb 28, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 1 Replies View Related

Application Express :: Region Button To Go To Back To Top Of Page

Oct 24, 2013

In Application Builder, when editing an item's properties there is a handy 'Up' arrow at the top right of each region which takes you back to the top of the page. Is there any way of adding something similar to an actual page region as this would be useful when creating particularly large pages (I know, we should design smaller pages but that's not always possible).

View 11 Replies View Related

Application Express :: Button Conditional On Existence Of Another App In Same Workspace

Aug 24, 2012

Is there a way to make a button conditional on the existence of another app in the same workspace. What I am trying to do is have a MAIN app and several other MODULE apps in the same workspace. Then a button on a form in the MAIN app that will redirect to a specific page in one of the MODULE apps. If the MODULE app does not exist, meaning not installed, then the button would be invisible.

View 1 Replies View Related

Application Express :: Adjusting Button Position On A Page

Feb 7, 2013

i am trying to adjust the position of a button as below but i realized it gets a bit uneasy as i thought ,
style="position: absolute; left: 100px; top: 100px; "

View 4 Replies View Related

Application Express :: Button With Pre-element Text Is Given A Container Div?

Aug 8, 2013

Just installed 4.2.2.00.09 and imported a workspace and an application. Worked fine.I noted a page display difference when compared to the exported application (4.1.0.00.32). I have (so far) found this:If I have a button with Pre Element Text set to <div class="dummy"> and Post Element Text set to </div>, Apex generates an extra div around it all.If my button was named P1_SUBMIT I end up with 

<div id="P1_SUBMIT_CONTAINER">
<div class="dummy"> <input type="button" value="Search" id="P1_SUBMIT" /></div>
</div> 

Is it possible for me to turn this extra div off?

View 0 Replies View Related

Application Express :: Insert A Row Into Table On A Button Click?

Oct 4, 2013

i have a table say 'temp' with 4 columns as seq, name, event, id and  i have a pg with 3 text fields as name, event, id now ma issue is,if  i enter values into those 3 text fields in that page and on a button click (say create), i wanted dose values to get inserted into  'temp' table andregarding ,  'seq' column i hav created a sequence for it. so

1. how to insert values into the table by entering values in the page    

2. wat shd b done for seq column.. (shd anyth b done from apex pages or wil it automatically get values for each row entered) 

View 4 Replies View Related

Application Express :: Open RTP Report By Pressing Button

Aug 27, 2012

Is this possible to open rtp report(oracle report), by pressing button in apex.

View 2 Replies View Related

Application Express :: Put A Download Button In Report Page

Jun 26, 2013

I have requirement like I have to put a download button in report page and clicking it will download only few of the columns only (specified one). I am using Apex 4.2.

View 7 Replies View Related

Application Express :: Action When Button Clicked - Redirect To URL

Feb 6, 2013

I have tested the following html page:

<html>
<body>
Click me
</html>

and is working fine when I click on the button on the created page.

However, using the same thing under the "Action When Button Clicked -- Redirect to URL" when create a new button, i.e:

javascript:window.open ('file:///c:/sample/','Documents');

will only open a new window, but blank in content!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved