How can I determine version of oracle database from APEX. Is there any built in table or view is available in APEX? Is it possible from Shared Component?
View 5 RepliesI downloaded Oracle Database 11g Express Edition R2 to test Apex (I've never used). I want to know how to change the language of the version of Apex (integrated with Oracle Database 11g XE)? I would apex in French.
View 7 Replies View RelatedI have created two regions in one page. I created some items but would like to share the items for both regions. When you create the item, you have to select which region it belongs to. Those items are supposed to be used by both regions, so I wonder if it is possible to share the items instead of creating the same items for region 2. I know I can create application item, but how to share items among different regions in the same page.
View 6 Replies View RelatedThere is a section that is called Data Loading in Shared components in every application that says: A Data Load Table is an existing table in your schema that has been selected for use in the data loading process, to upload data. Use Data Load Tables to define tables for use in the Data Loading create page wizard. The question is: How ca i select a table in my schema for use in the data loading process to upload data using the wizard? There is a packaged application that is called Sample Data loading. That sample is use for specific tables right? I tried to change those tables for the ones that I want to use but I could not because I could not add the tables that I want to use....
View 4 Replies View RelatedWe use Apex 4.0.1 and (to simplify) say we have 2 environments: DEV and PROD (both with same workspace ID.)Application 10 is in production, and currently being modified in DEV as part of an improvement project.However a bug is found in PROD and needs to be fixed as soon as possible. The steps we take are:
- Get the version currently in PROD from CVS
- Import it under a different application ID in the DEV environment, say application 11.
- Fix the bug
Now the problem starts. We always deploy whole applications to other environments (rather than individual components) and we want to keep the same application ID when we deploy this fix to PROD. But we only have the run-time environment in PROD, so it is not possible to override the application ID during deployment. So what we do is:
- Export DEV application 10 (the one being modified)
- Export DEV application 11 (the one with the bug fix)
- Import DEV application 11 over application 10
- Export DEV application 10 (the one with the bug fix)
- Import DEV applicaton 10 back (the one being modified)
- Deploy DEV application 10 to PROD (the one with the bug fix)
Is there a way to improve this (other than manually modifying the application ID in the export file)?
Another problem we have is that, once application 10 is imported into application 11, all the internal IDs change (hence the title of this post. :) ) This makes comparing versions in CVS a nightmare. Any way to prevent it? The only way seems to be import the application from PROD into the same application number in DEV, but this has an impact in the development process as no new development can be done until the bug is fixed.
I notice that version 4.3.0 of AnyGantt was released in Aug/Sep 2012.
Will this version be included in Apex 4.2? If not, would I still be licenced to use AnyGantt 4.3.0 with my Apex apps? If so where can I download it from?
Using Apex 3.2 version , Need to Upload .CSV Files to the Table (T_UPLOAD),
View 11 Replies View RelatedI have installed Oracle 11g XE with Apex 4.2 and I want to upgrade it to the apex 4.2.2. However, I do not have access to My Oracle connect. How do I uninstall apex 4.2 and install apex 4.2.2 full version from OTN?
View 1 Replies View RelatedI created a "Select List" in the Shared Components area as follows:
My goal is to create a shared select list that can be used on any form for a particular Field.
IF :P10_FK_RSTA_CODE is NULL THEN
RETURN
'select col_description, col_code_pk
from CODE_TABLE
where col_active_ind = ''Y''';
[code].....
Which works great, but how can I make the select list work for the same column on a different form? Because :P10_FK_RSTA_CODE is hard-coded in the function, I can't reuse this Function from a different form. (I could rename the Field on every form to the same name, but I'm hoping there is a better way.)
Is there a way I can pass in a variable from the Field Item to make this dynamic where I can use it on any form?
if on an interactive report, you try and filter on a date column, then the "=" operator disappears.You get other (not so useful) operators like "in the next", "not in the next" ">", ">=" etc. - but no "=" to be found.
View 6 Replies View RelatedI am experimenting with the 4.2 version of Apex at URL.....
I have created a tabular form (based on a view with an instead of trigger) and have restricted this form to "Update only" mode. Whenever I modify a field value and submit the change I get the error "Current version of data in database has changed since user initiated update process".
Grid Version : 11.2
OS : Unix, Unix-like
For one of our Java applications, the Oracle Client installed in the apps server was 10.2 . One of the SCAN LISTENERs were down in the cluster. When DNS resolves the scan name to that particular SCAN IP where the listener is down, the connection will fail. But , after they upgraded the oracle client to 11.2 , the issue seems to be resolved. It seems that the client is skipping the faulty SCAN IP which doesn't have scan listener running. Are 11.2 and higher Oracle clients intelligent enough to check this ?
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies View RelatedI'm trying to determine which procedures (in or out of packages), triggers or functions insert to or update particular tables in Oracle 10.2.0.4.I've got a far as looking at user_dependencies, and have written the following sql based on that:
CODEselect o.name, decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
8, 'FUNCTION', 9, 'PACKAGE', 10, 'NON-EXISTENT',
11, 'PACKAGE BODY', 12, 'TRIGGER',
13, 'TYPE', 14, 'TYPE BODY', 22, 'LIBRARY',
[code]....
This isn't how I'd write the code for production, it's just research code at the moment.
This tells me most of what I need to know, but it doesn't allow me to remove those procedures etc that just select from the table I'm interested in. The vast majority of the dependencies are just selects. In a previous role I used SQL Server 2000 and I could get this information from sysdepends, filtering on the resultobj column to remove the select only dependencies - so I'll be a little surprised if Oracle doesn't have this facility.
We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,
Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.
I am trying to apply 11.2.0.2.5 psu on a 2-node cluster running on RHEL 5.5 vms. Followed ORACLE-BASE examples when installed this laptop RAC. I am not using any ACFS and none of GI and DB homes are shared. But, on node 2, cluvfy THINKS database home is shared.
[oracle@rac1 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle/product/11.2.0.2/db_1 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle/product/11.2.0.2/db_1" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac1 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle_grid/product/11.2.0.2 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle_grid/product/11.2.0.2" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac1 trace]$ hostname
rac1
[oracle@rac1 trace]$ echo $ORACLE_HOSTNAME
rac1
[oracle@rac1 trace]$
##################################################################################
[oracle@rac2 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle/product/11.2.0.2/db_1 -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle/product/11.2.0.2/db_1" is shared
Shared storage check was successful on nodes "rac2,rac1"
Verification of shared storage accessibility was successful.
NODE_STATUS::rac2:SUCC
NODE_STATUS::rac1:SUCC
OVERALL_STATUS::SUCC
[oracle@rac2 trace]$ /oracle_grid/product/11.2.0.2/bin/cluvfy comp ssa -t software -s /oracle_grid/product/11.2.0.2/ -n rac1,rac2 -display_status
Verifying shared storage accessibility
Checking shared storage accessibility...
"/oracle_grid/product/11.2.0.2/" is not shared
Shared storage check failed on nodes "rac2,rac1"
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::rac2:VFAIL
NODE_STATUS::rac1:VFAIL
OVERALL_STATUS::VFAIL
[oracle@rac2 trace]$ hostname
rac2
[oracle@rac2 trace]$ echo $ORACLE_HOSTNAME
rac2
[oracle@rac2 trace]$
I can not determine any reasons and do not know how to fix.
I'm getting above error when I run following code
BEGIN
OPEN c_report_data;
FOR rec in c_report_data
LOOP
IF
rec.ESR_SALESMAN <> lv_rep_num THEN
ln_ttl_rep_cnt := ln_ttl_rep_count + 1 ;
ELSE
ln_ttl_rep_cnt := ln_ttl_rep_cnt;
END IF;
We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.
if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.
Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.
Get following output using user_source(or other) view?
Package_nameProcedure_nameline_startline_end
ABCXYZ1022
In procedure_name column it could be any procedure, function name or any object name exist in package body.
I am trying to create a report and seem to be struggling when trying to declare the columns 'DISK_READS' and 'CPU_TIME' within the statement.
Statement:
set serveroutput on
declare
cursor sqltext_cur is
select sql_id,child_number,sql_text, elapsed_time
from (select sql_id,child_number,sql_text,elapsed_time, cpu_time,
disk_reads,
RANK () OVER (ORDER BY elapsed_time DESC) AS elapsed_rank
[code]....
Error:
ERROR at line 18:
ORA-06550: line 18, column 51:
PLS-00302: component 'CPU_TIME' must be declared
ORA-06550: line 18, column 3:
PL/SQL: Statement ignored
ORA-06550: line 19, column 53:
PLS-00302: component 'DISK_READS' must be declared
ORA-06550: line 19, column 3:
PL/SQL: Statement ignored
I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies View Relatedwe are doing database upgradation to 11.2 from 10.2,i have found two invalid components but i couldn't find any invalid objects for those related components. find the output ...
SQL> set pagesize 500
SQL> set linesize 100
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 10.2.0.3.0
[code]...
17 rows selected.
SQL> select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from
dba_objects where status='INVALID' order by owner,object_type; 2
no rows selected
SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by
owner,object_type order by owner,object_type ; 2
no rows selected
This time i am downloading the Oracle 11g and then the Oracle APEX...(they are not in one package...right ? i mean they both have to download separately)i really new in oracle / PL/SQL. I'm not a programmer but i interest about database programming.For now i still use Ms. Access to develop an aplication and i really suprised i found this Oracle APEX because it an RAD tool too same as Access but more powerfull i think.
View 2 Replies View RelatedGetting error when using record type as in parameter.
PLS-00306: wrong number or types of arguments in call to 'SAL_UPDATE_PROC'
PLS-00302: component 'ENAME' must be declared
PLS-00302: component 'SAL' must be declared
CREATE OR REPLACE PACKAGE emp_details_proc
[code]....
I am not getting any error.
i prepare database server and when i import my dump file from old database it import normal but before it end it give me these errors and these errors it seems that it in loop
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 12:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Some shops run Oracle RAC using "conventional" storage, like emc, netapp, etc. Some shops run Oracle RAC using JBOD, just bunch of disks, all redundancy is managed by ASM.
How would you distinct these two approaches? JBOD approach sounds cheaper, so why serious enterprises are still using traditional conventional storage, like netapp and emc?
Way to share or manage the TNSNAMES.ORA file for all oracle clients in same place?I already have a TNSNAMES.ORA configured and running in the machines (locally).The problem is that any change done( ip, port etc), imply in update all files in all the Oracle clients
View 1 Replies View RelatedMy environment is Windows XP PC
Ram - 1 GB
Oracle version 8.1.7.0.0
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Even i start the Oracle service through the services.msc there are no new entries seen in alert log file of the database.I even changed the init DBNAME. ora file but that file is not being read. what is the normal procedure used by oracle 8i while starting the DB ? Which file should be edited if i come across shared realm memory error.
I wish to install 11g r1 RAC on my laptop having linux 4 as platform (on vmware) , for that i prepare 4 partition for that (on node1)
/dev/sdb1 - for ocr
/dev/sdb2 - for voting disk
/dev/sdb3 - for asmdisk group
/dev/sda5 - fro asmdisk group
by assuming external redundancy for ocr and voting disk i kept only one disk
and i configured following in /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/sdb1 -- ocr
/dev/raw/raw2 /dev/sdb2 -- voting disk
/dev/raw/raw3 /dev/sdb3 -- asmdisk group
/dev/raw/raw4 /dev/sdb5 -- asmdisk group
and my question is how node2 can understat these raw device as shared storage?
I am trying to use the APEX (as a substitute for my PHP forms base application) for a new client. Can I use the APEX and Oracle XE in production, without spending any money for a license from Oracle - i.e. for listener, Web server, etc,?
I already have setup the APEX that works fine on my laptop, able to see and work with the form on the browser, so can I take the same to a server as a production?