Application Express :: How To Call Function Behind The Button And Update Only Specific Record

Oct 3, 2012

1 - i want to ask few things as i m new to apex, i am using apex 4.1, and created 3 select list and a button in selecting of parameter,

1 select list : select area
2 select list: select product
3- select list - size of the product

i want to generate Ids for the following. for that i created query for INSERTING RECORD FROM ONE TABLE TO ANOTHER , generation the ids when button pressed "Generate" after selecting parameters,

Now where i call that QUERY on button ? because when i create button its gives me option to submit, defined dynamic action, etc, where i call the function name id_generation when button pressed?

2- second thing i created tabular " select user_id, product_name, product_type from product".

By default check box list are create delete submit button are created, first when i insert record it saves that was fine, e.g i entered 50 records and afterward i want to update only one record, e.g there is a record product name = box, if i change it to box small and click submit then it saves all the page means all 50 records,

I want to submit only that record that i changed, for that i use the logic that only those records should be updated which are checked but the user. how will i do this ?

View 4 Replies


ADVERTISEMENT

Application Express :: 4.2 Upgrade - Update Record Button Apply Changes Disappeared

Aug 27, 2012

I got a bug related to update information in APEX.

the situation occurs when I go to update a record the button Apply changes disappeared, it shows me only the button create, so when the user click on it, it creates a duplicate.. so how can i have the button "apply changes" back?

View 7 Replies View Related

Application Express :: Replacing Insert And Update Button Processes

Jan 31, 2013

Getting starting with diving deeper into APEX and reading the developers guide all 800 pages of it! Thing is I'd like to get started with some of the more interesting stuff.

I have created a form page based on the "Form on a Table with Report". The report part looks fine. What I'd like to do now is use an API I've built to change how the insert and update works. So when the submit button is pressed it rather performs an API call to the procedure/function.

1. Should the API be a function or procedure. In my playing around I saw that a procedure might work better or easier to implement
2. How would I go about creating a call for the button to use instead of the current processes?

----------------------------
Apex 4.2
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Linux version 2.6.32-279.19.1.el6.i686
----------------------------

View 4 Replies View Related

Forms :: Open Form On Specific Record After Click On List Button

Dec 31, 2010

I have a list box from which the user can select a client's name, I want them to be able to press a button next to the box which will then open another form and display all the client's details. How do I attach a button to a list box? and how can I call another form to open on a specific record?

View 3 Replies View Related

Application Express :: Dynamic Actions Call A Javascript Function On All Text Items

Feb 21, 2013

On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)

in these boxes I want to make them numbers only and max length 2

currently I have in the ELEMENT ATTRIBUTES for each column

OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";

( I have a function called numbers only in page 0 )

what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column

and put it in 2 dynamic actions how would I go about this ?

I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .

View 5 Replies View Related

Application Express :: Update Record In Another Row When Date Changed

Oct 10, 2013

As all of you know, In the Apex,  when you create a form with report in the page, you are able to insert and edit data. But when you edit the data, the data will be modified in the same row. In other word, you loose the old data.

What I need to do is: I have revised_num field and production_date field. I want to create a form with report and insert and edit data as is in the apex and insert 0 to the revised num until production date is null. But when  production date is not null, then from that point, I want to insert data to another row and modify revised num to 1. and I want the revised num be incremented by 1 each time the user modifies the data after the production date is not null.I don't know where I should start.

View 12 Replies View Related

Application Express :: Send Link To Update Some Record

Mar 8, 2013

Is there some simple solution how to send email to user with link ('I don't want to receive emails from you in the future') ?

The link should contain some key information for each user.

If user click the link - update of the table should be done. (some IDC updates from 'Y' to 'N').

Specs: APEX 4.1.1
Listener 1.1.3
DB 11G
Apache Tomcat 6.0

View 1 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 :: Go To A Specific Page

Nov 13, 2013

I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe ,  there is any APEX API functions for pages navigating..

View 2 Replies View Related

Application Express :: Scroll To A Specific Position Within A Page?

Jan 30, 2013

To branch & scroll to a specific position within a page (upon initial page load), is using a named anchor still the recommended/modern way to do this or is there some jQuery plugin goodness that does a better job?

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 :: 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 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 :: Allow Only Specific APEX App Through Oracle Http Server

Aug 1, 2012

I'm having some difficulty securing my Oracle APEX + Oracle HTTP Server environment.

There are currently around 20 Applications running on the APEX Server, and I'd like to publish 2 of them Externally for users.

I have added a certificate to Oracle Wallet Manager to secure the OHS, but I can access all the Applications on the APEX Server by just changing the Application ID suffix.

How can allow only two applications to be accessible via the internet?

View 11 Replies View Related

Application Express :: Clear Page Cache - All Except Specific Items?

Feb 21, 2013

APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.

View 2 Replies View Related

Application Express :: How To Call EDQ Web Service

Oct 2, 2012

I am trying to figure out a way to call EDQ (enterprise Data Quality) web service from APEX ?

View 6 Replies View Related

Application Express :: Call Javabean From 4.2

Apr 3, 2013

How can i call a java bean from apex 4.2 ?. Actually i call my javabean from oracle forms 10.2.0, but i will like to call it from apex. i am using windows OS.

View 3 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

Application Express :: Button Process With DBMS_SCHEDULER.run_job

Jul 17, 2012

I need to execute the DBMS_SCHEDULER.run_job on click of a button .I tried creating a process (On submit) with DBMS_SCHEDULER.run_job('JOBNAME')

when i tried executing directly in db there is no problem, but when i create the process in apex i am running into the following error

ORA-06550: line 2, column 19: PLS-00222: no function with name 'RUN_JOB' exists in this scope ORA-06550: line 2, column 1: PL/SQL: Statement ignored.

View 2 Replies View Related

Application Express :: IR Report Page With Download (specific) Column Security?

Apr 24, 2013

i have IR report page and download column as blob,how can security applied in specific column wise?e.g. Report page have more rows, and applied query in condition.

Select ID,dbms_lob.getlength(Blob_file) Download  from Document_master
where Created_by=UPPER(:APP_USER)
OR
  (exists (select ''   from   apex_workspace_group_users awgu
where  awgu.user_name =:app_user  AND awgu.GROUP_NAME='EMPLOYEE_GROUP'
)
)

Now all the rows with Download column to see EMPLOYEE_GROUP users,but i need control the download column only except Created_by=UPPER(:APP_USER) ,this case how can do the security.

View 5 Replies View Related

Application Express :: How To Call Apex From Forms Without SSO

Feb 6, 2013

We'll soon start an upgrade of our Forms / Reports 6i Application to 11g. I was wondering, maybe, it would be nice to add some value for the upgrade process as a whole, using some of Apex new features like web mobile interface or maybe an integration between Forms an Apex, for example to provide users with the powerful features of Interactive Reports, just to name one.

I have found this interesting link: URL.... (not a 100% clear for me, but at least it is a start).Obviously, to make it attractive, one would expect automatic login between the two Apps. As far as i know, this could be done like this:

1) Using SSO. With that a Portal / Forms / Reports/ Discoverer/ version would be mandatory (too expensive for some clients).

2) Oracle Access Manager? Not sure, can Oracle Forms connect to Access Manager? or LDAP? How about the licensing costs?. Not a clue.

3) Make all Apex pages public? Not feasible.

4) Now this one: in our forms application, every user authenticates within the application and we internally map that application user to an actual database user. At all times we hold metadata info about the current user (app, and DB), as well as application context. So this is my question:

It is possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting?

View 0 Replies View Related

Application Express :: Call A Process On Logout URL In 4.2?

Jan 3, 2013

I m using apex4.2 with wls10.3 and database 11g

I m trying to call a process on log out URLIn apex4.1 in authentication scheme we have logout url were we change the page were we need to redirect on logout click

But In apex4.2 under authentication scheme Post-Logout URL

I have given url here like this apex_authentication. logoutp_session _id=&SESSION. &p_app_id=&APP_ID.:117 on this page i have the two process but i m getting error System Unavailable.

View 2 Replies View Related







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