Application Express :: Copy Team Development From Database To Another Database?
Feb 11, 2013How can I copy Team Development from database to another database
View 3 Replies
ADVERTISEMENT
Application Express :: Attachment In Team Development Missing In 4.2?
Mar 14, 2013I was waiting for the attachment in Teamdevelopment as stated in APEX 4.2 new Features:
Support for attachments within Team Development 1007 EA2 Allow file attachments for bugs, todo, and features.but I can not find the functionality?
Application Express :: Team Development Remove Name From List Of Assignees?
Aug 14, 2013I'd like to remove a name from the list of assignees within the team development area. I've already re-assigned everything to a different person but can't find an option to remove the old one from the list.
View 3 Replies View RelatedApplication Express :: Trigger To Update Team State Which Have Same Match ID Of Another Team
Jun 11, 2012I have a table which contain match ID , team and the state of the team Each match ID can contain only two teams and I did trigger for that, what I want to do is when the user update the table and add the state after the match is played,, the other team state is changed to the opposite ,, except for the draw which both of them should have the same state..For example when team 1 state is set to win, team 2 which have same team 1 ID, should be updated to lose....
I want to create a trigger to do that,,I tried to do a trigger but not working
create or replace TRIGGER "UPDATE_STATE"
AFTER UPDATE ON "SPORT_MATCH"
FOR EACH ROW
BEGIN
if (:new.state = 'Wins') then
UPDATE SPORT_MATCH SET STATE = 'LOSES' WHERE SPORT_MATCH.MAtchID = :NEW.MATCH_ID and Team != :New.Team;
END IF;
END;I got this error
•ORA-04091: table MATCH is mutating, trigger/function may not see
Application Express :: Install A Development-environment / No Connection From Client
Feb 28, 2013i'm trying to install a development-environment. The production- and testing-environmens are working, but i have problems with the development.
I installed Oracle 10g XE 10.2.0.1.0 and Apex 4.1.1.00.23 on my Oracle VM Virtual Box (Windows 7 Professional 64 bit).
127.0.0.1:8080/apex works from the Virtual Box.
192.168.11.42:8080/apex (the IP in my network) and 192.168.11.42:8080 work either from the Virtual Box.
But it doesn't work from other clients in my network. So far i tried exec dbms_xdb.setlistenerlocalaccess(false).
Application Express :: Database Authentication Via Database Link?
Jun 26, 2013Is it possible to use Database authentication in APEX through database link, and how?Also is it posible to read roles from users through database link?
View 3 Replies View RelatedHow To Embed PL/SQL Queries In HTML In Database App Development VM
Nov 20, 2012I'm reading "Learning Oracle PL/SQL" and this book tells me that if I can install apache httpd and modplsql I can embed queries in HTML. How do I do this in Database App Development VM? Do I already have apache httpd installed? Is it already started? If not, how do I start it?
What am I getting when I point my firefox browser to
[URL].......
I'm getting a nice web page that is prompting for username and password. What username and password do I use? oracle/oracle did not work! What does this web site do? Administer the database server?
I already tried to use "yum install emacs" as I mentioned in Re: How to Install emacs, openssh and start oracle database and get a connect? and it appears that the repository for "yum" is not correct.
"yum install httpd" does not work either.
When I tried "sudo yum install httpd" it says
"Sorry, user oracle is not allowed to execute '/usr/bin/yum install httpd' as root on localhost.localdomain."
I get the same message for "sudo yum isntall emacs".
Application Express :: Copy One Row To Another In Report
Jun 6, 2013I am using APEX 4.2, DB 11.2
I have a Classic Report with Link item and Copy item and the other columns from the table. Copy item should appear in each record like the edit item link. When copy item is clicked the current row should be copied and a new duplicate row should be visible in the report.
The PL/SQL process written for this Copy item works fine (when executed alone).... but when Copy item is clicked, the PL/SQL process is not getting triggered.
PL/SQL process in not conditional.
Application Express :: 4.0 And 4.1 - Migrate / Copy A Tab
Jun 28, 2012Apex 4.0 and 4.1
I have 2 apps App1 and App2.I create a tab "TAB1" with 4 pages (1,2,3,4) in App1.I want to import it to App2 but its has already its own pages(1,2,3,4)
Will the import handle this issue?
Application Express :: Copy Cells In Report
Sep 27, 2012It's possible to copy cells in report like excel sheet , like this example ? URL....
View 0 Replies View RelatedApplication Express :: Can't Copy Record That Contains # Using Branching
Aug 15, 2012I'm using APEX 4.1 and have implemented a "Copy Record" button that copies selected fields from the record back to the same page to create a new record. This is done using branching and setting the items (e.g., P2_NAME,P2_ADDRESS1,P2_ADDRESS2, etc...) with these values (e.g.,&P2_NAME.,&P2_ADDRESS1.,&P2_ADDRESS2., etc...)
It has worked perfectly in other APEX applications -- up until now. The issue is that the new database contains several fields that contain the "#" character. When the "#" character is encountered during the copying process, any data after the # are not copied (but all of the data before the # are copied OK).
Removing the "#" characters is not an option, as it is part of numerous manufacturer part numbers that we track.
Application Express :: Capture Contents Of Page - Copy To Clipboard
Jan 31, 2013I just need to run javascript to capture the contents of the page( form) like labels and values in the fields using a COPY button to capture all the information available on the page or form to copy that to system clipboard so that information can be used into another system.
View 2 Replies View RelatedApplication Express :: How To Connect Second Database From Another One
Apr 5, 2013 how can I connect a second database from another one?
Ex.My APEX application in a database instance DEVELOPER and I want to connect with tables in DEVELOPER_B instance.
Application Express :: Upgrade Failed In Database From 10g To 11g
Jul 30, 2012When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.
What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.
Application Express :: Installation On Oracle11gXE Database
Aug 27, 2012I tried installing application express on oracle11gxe database.I running the scripts apexins and I got an error message SP2-0024: Nothing to change.
View 1 Replies View RelatedApplication Express :: Adding Users To A Database?
Nov 7, 2013I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g.
View 10 Replies View RelatedApplication Express :: Creating Procedure Using Database Package
Oct 23, 2012I have created a procedure within a database package, but when I want to create a form based on procedure but I can't call it. I think that I have to use prefix, I am a beginner in database and I don't know how to do this.
View 4 Replies View RelatedApplication Express :: Database Monitor Module Missing In 4.2.2?
Jul 4, 2013When login as a administrator, am unable to find the above in SQL Workshop / Utilities. it's not drop from 4.2.2 , very useful functions.
View 2 Replies View RelatedApplication Express :: How To Retrieve Item Help Text From Database
May 23, 2013I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?
View 4 Replies View RelatedApplication Express :: Importing CSV Files To Database Backend
Dec 15, 2012There is a report that is generated everyday in the .csv file format that i would want to load into the database. I want to completely automate this process. I don't want to use the load function available in APEX. I use APEX 3.2 Version.
What i mean by automation is that i will create the CSV file and automatically move to a location from which APEX can access the data. I would then write a procedure to fetch the content directly from CSV file and write to the database. What i need is the location from which APEX can access data directly ?
Application Express :: 4.2 New Database Sessions Per Report Region?
Nov 22, 2012Does version 4.2 create a new db session for each report run on a page?
The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.
I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live
Application Express :: Validate Database Column Using Validations Tab?
Sep 11, 2012I'm trying to validate a database column using the validations tab in APEX, the data entered will always be in 'A0000' format but i cannot work out how to set up the validation correctly
View 2 Replies View RelatedApplication Express :: Conditional Read Only That Saves To Database?
Nov 27, 2012I have an item that does not save to the database.it is conditional read only based on the value in another column, when it is not read only it displays as a Select list.. then whatever is chosen triggers a dynamic action that sets other items.so setting it as a display only is not an option.
after upgrading from 4.0 to apex 4.2 this gives error: Session state protection violation: This may be caused by manual alteration of protected page...
the only workaround I have found is to set the Read Only to none, then create a dynamic action that conditionally sets the field to disabled..This works, but my problem with it is that it looks different than the read only..read only was Black Text and no textbox..disabled is a text box with greyed out text that is hard to read for some of the users..
RECOVER / Copy A DATABASE?
Jul 13, 2010While trying to copy a database, i used the command: RECOVER DATABASE USING BACKUP CONTROLFILE until cancel; it gave:
ORA-00279: change 7866782806751 generated at 07/12/2010 19:39:23 needed for thread 1
ORA-00289: suggestion : /moteurs/oracle/r11110/R11110/archivelog/2010_07_13/o1_mf_1_1158_%u_.arc
ORA-00280: change 7866782806751 for thread 1 is in sequence #1158
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data01/oracle/r11110/data/SYSTEM01.dbf'
ORA-01112: media recovery not started what can i do in this case of issue?
Can Copy RMAN To Use Different Database With Different ID
Feb 23, 2011Can I copy rman to use a different database with a different ID
View 6 Replies View RelatedApplication Express :: Login User With Database Credential - Seen As APEX_PUBLIC_USER
Mar 29, 2013I'm using Application Express 4.2.1.00.08
In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.
For instance, I'm login as SCOTT
Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.
How to create a connection with another "real" username ?
Application Express :: Database Link Slows Down The Response Time
Jul 11, 2013I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from
sql*plus or pl/sql developer.
It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!
Application Express :: Using A Variable Database Link For Interactive Report
Nov 5, 2013I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?
View 8 Replies View RelatedApplication Express :: PDF File To Be Stored Directly In Database Using Jasper?
Jul 16, 2012I am using jasper integration package ..from www.opal-consulting.de using apex 4 and i Am currently able to generate pdf invoice..using jasper and store in a database.. table.
I need to generate the pdf invoice in the background ..without displaying in my screen..Without downloading on my machine..And store directly into the database table..
Below is my existing part of code..
DECLARE
l_blob BLOB;
l_mime_type VARCHAR2 (100);
l_blob2 BLOB;
l_mime_type2 VARCHAR2 (100);
mport varchar2(200);
[code]....
Application Express :: Upgrade Within Oracle XE Database Installation On Windows 7
Aug 28, 2012O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============
Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.
It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.