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 I have problems with calling procedure directly from webbrowser. I have a procedure test in test_pkg package. I granted execute on it to anonymous , added it to wwv_flow_epg_include_mod_local function and still have error 404.searched this forum and found this: Does listener use wwv_flow_epg_include_mod_local
So I granted to apex_public_user and created synonym for him to my package. And it starts working. But then I wanted to add next proceudre to my package the same way, and change my test procedure and it stop working again. Now I have 404 error again.
I have a stored procedure that returns pdf as a blob.
Is there any way that this can be streamed to the browser without saving it?
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 RelatedI 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.
APEX 4.2 Theme 25 Oracle DB 11gr2 - I need to conditionally display Html5/Flash chart regions depending on browser compatibility, how to achieve this.
View 8 Replies View RelatedSo 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.
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 RelatedI 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 RelatedHow 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 RelatedMy question is, if I define an object type (create type ... as object ...) is it possible to hold a variable of this type as the session level? For example, if I am creating an order using multiple web pages, it would be much easier (and intuitive) to create and manipulate an order object than to hold the data in generic collections.
If that is not possible, is there some way to make a generic Apex collection appear more application specific? By this I mean some way to map the columns C001, C002, ... to more intuitive names such as CUST_NO and ORDER_DATE. I had considered possibly creating a view of the APEX_COLLECTIONS view which would rename the columns but then I would also have to create a bunch of instead of triggers if I wanted to update it as well.
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.
I having some weird trouble with my cursor results. My cursor query returns some rows in which one of the called CUT_TEXT2 returns some text msg as per my decode statement. With the result of that value I am sending some emails.when I execute the cursor in toad it is fetching exact values what I wanted. But When I registered the same program in Oracle EBS R12 as a concurrent program it is giving wrong results.
For ex :
ASSIGNMENT_ID EMPLOYEE_NUMBER PERSON_ID DATE_PROBATION_END 3_WEEKS INI_TEXT 3_WEEKS_3_3 CUT_TEXT2 SUPERVISOR_ID
12847 0370 18906 5/23/2013 5/2/2013 NO_ALERT 5/7/2013 CUT_TEXT2 19275
16671 0636 25163 5/28/2013 5/7/2013 INI_TEXT 5/12/2013 NO_ALERT 17202
For ex : PERSON_ID = 18906 has CUT_TEXT2 (col) = CUT_TEXT2 value. In application the same person id has (18906) CUT_TEXT2 = NO_ALERT .. which is failing my program.
CREATE OR REPLACE PACKAGE BODY apps.xx_hr_probation_alert_new
IS
PROCEDURE alert_probation_f_new (
errbuf OUT NOCOPY VARCHAR2,
errcode OUT NOCOPY NUMBER,
notification_type VARCHAR2
[code].....
I am trying this below in oracle 10g express. how I can select data from the table?
CREATE TYPE Worker AS OBJECT (name VARCHAR2(25), dept VARCHAR2(15));
CREATE TABLE teams (team_no NUMBER, team_member Worker);
insert into teams
values ( 5 , team_member ( worker('a' , '2')))
DECLARE
[code]...
ORA-00933: SQL command not properly ended
SNRCTL> stat LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date 19-JAN-2013 00:50:10
Uptime 0 days 0 hr. 29 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
[code]....
In every oracle documentation for e.g:11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1] we found the local listener status showing both local-ip and vip. Why is not showing in our case?
I want to create a store procedure to copy data from a source tables(which may not have any constraints defined) to a table which has primary key, foreign key and unique key constraints.
Any records which are rejected due to these constraints not being satisfied need to go another table.
Once the initial data load is done, these procedures need to be automated(through cron) to do the future incremental uploads in the same manner.
While practicing with Triggers, the following error was encountered. An Object Type and an object Table are created.
create or replace
type typPerson is object
(id number,
firstname varchar2(30),
lastname varchar2(30)
[code].........
I executed the below insert statement, and I got the following error.
SQL> insert into person_obj_tab values (10,'Object1','From Trigger');
insert into person_obj_tab values (10,'Object1','From Trigger')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4153
Session ID: 136 Serial number: 305
[code]......
SQL> insert into person_obj_tab values (10,'Object','Original');
1 row created.Question:
1) Trigger of version 1 did not report any error during compilation, but during DML execution, hangs for sometime and gives the above error.
2) Whether direct assignment of Objects of greater size is possible inside triggers built on object Tables?
3) Suppose an object contain multiple attributes (say more than 20), then how to assign them inside a trigger?
I have a problem with executing oracleCommand.ExecuteReader() method. Whatever I try it always returns null and it won't create OracleData reader object. I'm using ODAC 1120320_x64 for .net 4.0 and timesten112241.win64. Don't sure what to do. Debugger is showing strange thing in OracleConnection object : ConnectionState = Closed, but output of ttStatus shows connection to TimesTen data store and ExecuteNonQuery() command works just fine with or without (in or out) parameters. But when I try to execute some query with multile output such as select *, I can't get any result.
I also have a strange problem with connection.Open() When I execute Open() i throws AccessViolationException that can be handled with [Handle ProcessCorruptedStateExceptions] attribute, but connection is established after that and my application works fine until I try to instance OracleDataReader object.
Here is the code:
OracleCommand select = null;
OracleDataReader reader = null;
select = new OracleCommand(selectStmt, connection);
select.CommandType = CommandType.Text;
try
{
reader = select.ExecuteReader(); // this line throws NullReferenceException
if (reader.HasRows)
{
[code]....
Just to mention, I tried it with different queries (pl/sql, plane sql, stored procedure) and all of them works fine in SQL Developer, but not in app.
Is there any query to find the dependent object details for any object. Like if mview is built on a table, then i should be able to find the table name with out checking code of the mview. similar way for view and functions or procedures etc...
View 5 Replies View RelatedI have an Type-object typeObj1 that consists another Type-object typeObj2. this def has another Type-object typeObj3. how to access variable declared inside typeObj3. I have syntax below for each Type.
CREATE OR REPLACE TYPE typeObj1
AS OBJECT
(
SYSTEM_IDENTIFER VARCHAR2(50),
PROCESS_TYPE VARCHAR2(50),
abc typeObj2
)
/
[Code]...
/I have tried to access the type-object in where clause in following way
FROM TABLE(CAST(I_typeObj1 AS typeObj1)) ITTPRC,
......
Where
.......
AND (ADDKEY.ADDTN_INFO_KEY_TYP_NM IN (SELECT ADDTN_INFO_KEY_TYP_NM FROM TABLE(ITTPRC.abc)))
AND (ADTINF.ADDTN_RQST_TYP_VAL_DT IN (SELECT ADDTN_RQST_VAL_DT FROM TABLE( ITTPRC.def)) OR ITTPRC.def IS NULL )
AND (ADTINF.ADDTN_RQST_TYP_VAL_NUM IN (SELECT ADDTN_RQST_VAL_NUM FROM TABLE( ITTPRC.def)) OR ITTPRC.def IS NULL )
AND (ADTINF.ADDTN_RQST_TYP_VALUE IN (SELECT ADDTN_RQST_VALUE FROM TABLE( ITTPRC.def)) OR ITTPRC.def IS NULL )
In this way i am able to access the variable inside typeObj3. But problem is i am getting error "ORA-01427 single-row subquery returns more than one row" when i pass more that one typeObj2.
I passed the values like this in proc execution.
T_T_A_I_V := typeObj3('asdasd',NULL,NULL),
typeObj3('String654',NULL,NULL),
typeObj3('abcdef',NULL,NULL));
T_T_A_I_I := typeObj2('CampusCode',T_T_A_I_V),
typeObj2('PlanNumber',T_T_A_I_V);
What i have done is removed typeObj3 from typeObj2, variables defined in typeObj3 are added in typeObj2 then i got ride of above error. is it correct
which is the best browser for oracle 10g forms ?
View 3 Replies View RelatedI need to define the type of user's web-browser (Opera, Ie, chrome, firefox), under which launched forms.
View 3 Replies View RelatedI captured the process id of the browser. I wanted to know whether the process id of the browser is dead or not after we close the browser. How can I check the condition for the process id in oracle forms?
View 1 Replies View RelatedDatabase 11g Enterprise Edition.
Probably if I give the installation procedure I went through and specified Error messages,. Installation Option: - Create and configure database was selectedSystem Class: -Sever Class was selected Install Product:-Oracle Database Installation= Succeeded· Prepare= Succeeded· Copy files= Succeeded· Setup files= SucceededOracle database configuration= Succeeded· Oracle Net Configuration Assistant=Succeeded· Oracle database configuration Assistant=Ignored· Oracle configuration Manager Configuration (optional)=Succeeded In the process of the Install Product the following Error messages
[code]....
If a table and several columns are listed in dba_tab_histograms does this mean that the table 100% certain has a histogram or more?
select * from dba_tab_histogramsAND table_name='tab1';
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_ACTUAL_VALUE
---------- ------------------------------ ------------------------- --------------- -------------- --------------------------------------------------
USR TAB1 COL1 0 3.0002E+
USR TAB1 COL1 0 5.0661E+35
USR TAB1 COL1 0 200062635
USR TAB1 COL1 0 2456436.95
USR TAB1 COL1 1 1.1002E+10
USR TAB1 COL1 1 2.3720E+35
USR TAB1 COL1 1 230082138
USR TAB1 COL1 1 1236436.95
In Toad I can't see any historgram on TAB1 in the schema browser.. Running Oracle 11.2 on Linux.. Question:If a table with columns are "in" dba_tab_historgarms does this actually mean that there are a histogram on the tables/column?
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience."
Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
Currently i am using IE 6 for running my forms 10g, I like to know upto which IE Versions i can update so it must not affect my Oracle forms 10g running.
i like to update to IE 8, but it must not affect my forms runtime functionality!
Is there a way to start a new browser session from a call in an existing 11g form. I have a situation where in the client / server world I open a form in a new window .
View 1 Replies View RelatedI have a list box that is populated from a record group using a WHEN-NEW-FORM trigger. When I run the form this displays fine when the list box is set as Poplist or Tlist, but when I change this to combo box and run the form it doesn't load properly in the browser (a blank screen followed by the background a a toolbar that says window).
View 3 Replies View RelatedWhy Other Browser cannot run oracle forms without IE.
i want to use other browser for oracle form like firefox,google chrome etc not IE.