I have an ADF table on my page and it has 2 LOV columns. My table is based on XML payload and not VO. But the 2 LOV columns are coming from a same VO. The problem i have is when i add a new to the table, the VO still holds the data instead of getting refreshed.How can i make VO not to default the old values?
In oracle, do we have "drop table xx cascade all if existed" or "create or replace table xxx" ? what is correct syntax ?
I use ADF table component and the code as following,<af:table value="..." var="row" rowBandingInterval="0" id="t1" rows="5"inlineStyle="height:200.0pt;">.....</af:table>but the pagination do not work, please tell me what is the problem.Thank youEdited by: Yitao Li on Oct 13, 2009 1:36 AM
I'm using Jdeveloper 11.1.1.4. I'm trying to get the following feature to work. I have an adf table that initially should not be shown. There is a commandLink on the page that when clicked on, should show the adf table. The text on the commandLink should also change when clicked on (e.g. from "Show Table" to "Hide Table"). Clicking the commandLink again if the adf table is visible should hide the table and change the commandLink text back to "Show Table". I tried the following:<af:commandLink text="#{backingBeanTable.showTable ? 'Hide Table' : 'Show Table'}" id="showHideLink
Any ideas on where I should look for this one? Basically, I have an ADF table inside a facet within a switcher, and it will not refresh once I enter a query and press enter. That is the table is not restricting by my criteria.Now please note, that when the table IS NOT in the switcher this works as intended. I'm wondering whether this is a bug or whether I need to modify some attributes somewhere.Thanks in advance for any suggestions.Simo
We are constructing a page where we need to display a adf table, we provide check boxes against each row to allow multiple selections. Checkboxes are transient attributes on VO with updatable property set. A strange issue is noticed, checkbox model for the very first row of adf-table is not updated.Tested this scenario in 11gR2 also, and seems to be a bug.https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B9C7sgjVyCnoZTlmN2Y5MDItYTJhNy00MzA3LWE0ZTctOGRhNjZiMmYzNzZm&hl=en_USPlease help us.
I had something odd occur today. I created a adf table as normal, but when I run the page all the rows are blue. Until now, every table I've created has had a white background.I don't see anything in the settings, can anyone give me an idea where to look?
My Scenario is like this:I have used adf table with columnStretching to last column of table. And the table is placed at second facet of panelSplitter. On load it covers full area of second facet which is pretty good. When try to collapse panelSplitter, arround 2 pixel of horizontal scrollbar appears at bottom. Even on uncollapse the panelSplitter to original orientation, the extra space remains there which makes horizontal scrollbar with 2 pixel gap for movement at bottom of table. Is Anyone facing this kind of issue? And how can I solve the issue? Thank you for your help and responses in adv
I have an ADF table on my page. when i load the page, it loads with some lines based on teh data. I have a button on this table which adds or removes a line from this table.My requirement is: i should not be able to edit/remove the first defaulted lines that came in while loading the page.I should be able to add new rows or remove rows to the table.can someone point me teh right direction.
I've been have serious issues to resolve this functional requirements with ADF.Basically I have two tables let say employee and department.A need a read only adf table to show the employees values but I don't want the users to see the department id, instead I want them to see the department name and all this in the same read only adf table. I created a view object based on such a query below:select employeelastname, employeefirstname, departmentname from employee, department where employee.departmentid = department.departmentid Note the outer join here because some employees don't have departm
I have a popup page which has a view object bound to an ADF table. On page load I run ExecuteWithParams to pass in a parameter and run the query in the view object.So here is the problem. Let's say I had 10 rows displayed on the page. We have another application that can insert data in the table for which the view object is created. So if someone inserts data and then I open the page, the new data entered shows up but only 10 rows are displayed again. One of the rows doesn't get displayed. Seems like the table will always display only the number of rows it brought back the first time I loaded
JDeveloper 11.1.1.5 / WLS 10.3.5.0Model : BC4JI have a Create/Edit 'Header' page, when first visited to this page, I create some default 'Lines' rows which are displayed in an ADF table in the page.After saving, when the 'Header' is visited again, it is opened in Edit mode.The Lines Table is enabled with the FiltersWhen the page is in create mode, I am creating and inserting rows in the ViewObject.These rows are still in Cache because it is upto the user to decide if he wants to Save or Cancel, so I do not Commit after inserting rows.The Lines show up in the table. So far so good.But, If we tr
I am working on adf:table and trying to get the selected row of the table. I always get rowindex as 0.I am using the following code in my Bean:UIXTable searchTable = getEmpTable();FacesCtrlHierNodeBinding rowdata =(FacesCtrlHierNodeBinding) searchTable.getRowData(searchTable.getRowIndex());jsff code:- <af:table value="#{bindings.EmpTRVO.collectionModel}"var="row"rows="#{bindings.EmpTRVO.rangeSize}"emptyText="#{bindings.EmpTRVO.viewable ? 'No data to display.' : 'Access Denied.'}"fetchSize="#{bindings.EmpTRVO.rangeSize}"rowBandingInterval="0" id="t2"contentDelivery="immediate"autoHeightRows=
In my UI page ,i am doing DB Operations.I have 'Create' Operation ,which is dragged n Dropped from DataControl,<af:commandButton actionListener="#{bindings.Create1.execute}"text="Create" partialSubmit="true"id="cb5" partialTriggers="t2"/>At Runtime once i click the 'Create' Button it wont create Newrow, no error message in log file also. If i click any other Button or if i navigate to any other tab n comes back it will populatethe created new Row.i have partialTriggers code in ADF table still am facing same issue.<af:table value="#{bindings.OeDcompRuleActionsView1.collectionModel}"var
I have a partition table on which composite Indexes are created in a tablespace.I drop tables older than 30 days to freeup table space.but table space is not getting freed.Is table space for Index is freed when a table is dropped with cascade constraints?Pls help..
I was looking the POJO pagination sample "037. How-to build pagination into ADF POJO Data Control".where you create a facade class with two methods. One for get Size and other that has and index and fetch size, adding in DataControl.dcx file a property using DataControlHandler="oracle.adf.model.adapter.bean.DataFilterHandler".I have implemented this example calling a webservice inside the facade class , and its working great, facade method is called with correct arguments.But i need to build a table with a filter header and sorting options , pass the values filled by the user to the facade and
I am trying to create a table programatically...And i implemented like below:RichTable phoneTable = new RichTable(); phoneTable.setEmptyText("No Phone Details yet"); getContactPhone(contactObj.getPhone()); phoneTable.setValue(contactObj.getPhone()); // contactObj.getPhone() is a ArrayList<TelephoneBOD> in pojo Object... // Which is taken from a Object returned from DataControl Method (Captured in pageFlowScope) phoneTable.setVar("row"); // Add Columns RichColumn column = new RichColumn(); column.setHeaderText("Type"); column.setId("
I'm using JDeveloper 10.1.3.5 with ADF Faces and Business Components. (I hope someone will remember the older version and still be able to help me - we only have Oracle Application Servers and no WebLogic servers which is why I am still on the older version)I have one table where when I push the next link, it is not going to the next set of record but is staying on the first page. All of my other tables are working just fine.This particular page is the home page and has a table that shows the list of items for that user (were either created by the user or the user was selected on one of four d
I have a report where I looku the values using a number of LOVs. I'd like to enable sorting on those columns in the report whihc works BUT the report get's sorted on the numric looku pvalue instead of the description for example COUNTRY_ID instead of COUNTRY_DESC.I have played around with the function APEX_ITEM.ITEM_TET_FROM_LOV in my SQL query:select ID, NAME,APEX_ITEM.TEXT_FROM_LOV(COUNTRY_ID, 'COUNTRY_LOOKUP') COUNTRY,from VARBut I get the following error:report error:ORA-06550: line 1, column 13:PLS-00103: Encountered the symbol "COLLECT" when expecting one of the following::= . ( @ % ;ORA
In af:table range navigation once I click the next the row is not selected by default, user has to select the row again after user click the next .Is there way by default the record set to first row?
If I have a report with a column where the displayed value is based on a lookup into a "satellite" table and I use the built-in sort functions the sorting acts on the Key value and not on the displayed value. Any ideas if this can be solved so that the sorting acts on the displayed value and not on the key?
I want to create a table for our new application which contains a table used to represent the data in a chart format or matrix format, and each cell of the table should be filled with a colour out of three colors, based on the value belongs to which range eg:(1-8 ->green, 9-20 - yellow etc), I dont know how to implement this. Please help...Ranjith
Please consider the following scenario:1) A WebCenter project;2) Drag&Drop a DataControl method as a button;3) Drag&Drop a DataControl method output as a ReadOnly Table;4) Added PartialTriggers to the Table;5) Created a ManagedBean - Home1PageBean - with 2 boolean properties - refreshData and sortData - set to false in the variable declaration;6) Added the following RefreshCondition to the table: #{home1PageBean.refreshData or home1PageBean.sortData};7) Created a bean property (getParameters) that returns the required input parameters (always return a not null value) for the binding cr
I have a strange issue while inserting a new row to the table. The values i selected earlier are defaulting to new row instead of inserting a blank row. Can somebody help me?I have a table on my page and is deaulted to 2 lines.I added soem information in these 2 lines. I want to add a 3rd line.So i clicked on "createinsert" button and a new line was added.But the values are defaulted from previous row. why is this happening?
I have created a java bean which has a method which returns List<MyObject>.This bean is used to create new data control which is used in af:table.On context menu click, I have written a method which looks like below:RichTable rt = myTable;//my table is a table component. CollectionModel model =(CollectionModel) rt.getValue();RowKeySet rks = rt.getSelectedRowKeys();Iterator selectedRowsIterator = rks.iterator();List currentRowKey = (List) rt.getRowKey();while(selectedRowsIterator.hasNext()){List<Key> rowKey = (List<Key>) selectedRowsIterator.next(); rt.setRowKey(rowKey);System
I have a web application that, for some of the adf tables displayed, shows all the rows highlighted as if they were selected. Not all of the tables in the application do this, but the ones that have this trait do it every time.I can see no difference between the declaration for the tables that do appear this way and the ones that don't.I am using 11.1.2.1 on Windows 7.Can anyone point me in the correct direction? The rowSelection property is set to single, and aside from that I have no idea where to start looking.
In DB2 is there any equivalent for Oralce Drop table xyz CASCADE CONSTRAINTS PURGE
I have an ADF table that I use to show rows from a database table. One of the columns is a date column called CHANGED_DATE. Because of the exact match issue on filtering date columns, I've created a calculated attribute called DATE_TRUNC, a String attribute with the value "to_char(changed_date,'DD-MM-YYYY')". I have filters on several columns, inkluding the DateTrunc column.Two of the rows in the table currently have the same value in the DateTrunc column, 17-05-2011. If I write "17-05" or "17-05-" in the column filter, only the two expected rows are shown. But if I write "17-05-2011" in the f
The Control Type Radio Group not getting displayed while using Dynamic Table, is it a known bug? Scenario:1. Create a Employee, Department EO and VO2. Create a VA and LOV on DepartmentId of EmployeeView with DepartmentView as VA.3. set the control hint on Department Id as "Radio Group"4. Add EmployeeView to an AM.5. Drop EmployeeView as Dynamic table(you need to Add ADF Dynamic Faces Tag library to Vie Controller project) on to a jspx, and run it. Nothing is getting displayed in place of Department Id.Also if i set an Attribute as "Checkbox" nothing is displayed, instead if i make attribute Ty
I keep getting the following error when I try to crete a table.I did:DROP TABLE [TABLENAME] CASCADE CONSTRAINTS;Before creating, but still I get:SQL> @c:\a\create.sqlTable created.CREATE TABLE ITEMMAST (*ERROR at line 1:ORA-00955: name is already used by an existing objectWhat object?
The best strategy I find to compress a table's extent is to: 1) export the table 2) drop the table 3) import the table.However, this is proving to be very problematic. When you export a table with constraints=y, it does not include the foreign key constraints on children tables. But, if you drop the table with "cascade constraints" option, all foreign key constraints on these children tables are dropped. There is no way to re-create them when the table is imported.My export parameters are indexes=y constraints=y grants=y. And, the import parameters are rows=y constraints=y indexes=y grants=yI
I need some help. I don't understand how to do an alter table statement.I had a lab last week that used it and I couldn't get mine to work.DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; DROP TABLE TERM CASCADE CONSTRAINTS PURGE; DROP TABLE STUDENT CASCADE CONSTRAINTS PURGE;DROP TABLE FACULTY CASCADE CONSTRAINTS PURGE; DROP TABLE LOCATION CASCADE CONSTRAINTS PURGE;CREATE TABLE LOCATION(Locid NUMBER(5) CONSTRAINT LOCATION_Locid_pk PRIMARY KEY,Bldg_Code VARCHAR2(10) NOT NULL,Room VARCHAR2(6) NOT NU
can anyone tell me how I can provide the following functionality....I have a list of values source table...LOV_ID,LOV_DESCRIPTIONCURRENT_FLAG ...values 'Y' or 'N'I have an application table that includes an LOV_ID column.An application form region has a list of values field based on the source table defined above. If the current flag is set to 'Y' I want to include in the list, if 'N' then exclude.This is fine when I am entering new records but this comes undone when I view historic records that have a value in the list that is now marked current='N'.How can I separate the population of a fiel
(I realized this related to ADF, but since there is ORA-12519 I post it here..)I create a data entry using ADF Table, multi Row Insert. When user press "Create" button, I will create 75 blank rows, then user input values and press submit.For the first transaction , it works perfectly.But when user input second transaction, still with 75 rows, when user press submit, I get a lot of JDBC Errors... (attached below ..)What could cause these errors ?Is that because JDBC time out ? because it takes 10 minutes for user to input 75 rows..Thank you very much for your help,xtantoBelow is the error :Erro
While dropping a table with "cascade constraints" option, I find that no. of objects in the user_objects table does not decrease. Only "Object_Name" is updated to a value like "BIN$K+97YWCIcRTgRAASeZWmDQ==$0"..Can you please help me to find out the reason.Thanks in advance..Rgds,Anjan
// I use Application Express 3.0.0.00.20I have a 'Select List with Redirect' item, based on a named LOV.Some of the returned values contain characters like # or " (quotes).When I select a value whose return value contains one of those characters:The item value in the session state window does not include the # or what comes after it.The displayed value of the LOV turns to null's display value.Here's an example:create table lov_tab(d varchar2, r varchar2);insert into lov_tab('aaa #1','aaa #1');insert into lov_tab('bbb "23','bbb "23');insert into lov_tab('ccc','ccc');My LOV:select d d, r rfrom l
Any way to pass information from Oracle Maps JavaScript API to ADF?For instance if I want to pass FOI's ID that I got clicking on it (mouse_click event) to ADF so I could change adf table showing informations about that specific FOI how to do that?
When we drop a table with "drop table table_name cascade constraints;" does this drop the indexes and synonyms for the particular table?
my data ---- drop table proDetail cascade constraints;drop table ProCmty cascade constraints;drop table frmsppt cascade constraints;drop table lnchpdDetail cascade constraints;drop table dstrLct cascade constraints;drop table rlsdVrsn cascade constraints;drop table mnyspprt cascade constraints;drop table proDetail cascade constraints; select * from tab/create table proDetail(proname varchar2(15),proid number(6),ProVersion varchar2(10),DateReleased date,ProLocate varchar2(20),constraints pk_pd PRIMARY KEY(proid))/create table ProCmty(DevName varchar2(50),DonateName varchar2(50),MotuName varchar
I have a form that displays a list of values for a field. For the next field I would like to filter the list of values based on the choice given in the first LOV. Real new at ap ex, any help would be appreciated. LOV 1 - The choice is either Debit or Credit. The LOV is dynamic and is based on a tableLOV 2 - Choices are Debit or Credit types, it Office expense or Rental Income. The LOV is also dynamic and is based on a table.
I am trying to implement auditlog to my database schema. It is working fine.I run script in cmd by providing schema name and table name. Now this script should run from my metadata table(all table names will be in this table) when my audit_column is 'y' in the corresponding table. can any one help me in this. iam providing the script plz change accordingly, thanks in advance.Metadata_Table:Pkey_id,Table_Name,Remarks,Pkcol_name,Audit(Y/N)1 s_area_hdr table area_id Y2 s_lov_hdr table lov_id N //First created package in schema//CREATE OR REPLACE PACKAGE tsh_audit ASPROCEDURE insert_log (p_userid
Friends,OS: RHEL AS 3DB: 9iR2I have exported one table from production because i added a new column with data in that table.Now i want to import that table in the test. But, this table is already exists in the test.for that i will drop the table with cascade option.1. what should i do before dropping the table. i mean what i have check for the dependents and constraints and how?2. after importing what should i do for enabling dependents and constraints?
I have created 2 search fields (State, Area) in report page. Both of them are LOVs based. User select first field value, next field's LOV return values based on the first field( AJAX call). First field is states like 'VIC', 'NSW', 'SA' etc..., next field is 'Area'. when I select state other than 'NSW' in state field then next field is populated successfully. But when I select state as 'NSW' then next field is blank. 'NSW' state has records more than 100 in the table(LOV based on), but all other states have even less than 10 records. when I remove (more than 50) records of 'NSW' in the table th
I am trying to do a procedure to input information for one order and another for 2 orders.The information I have so far is as follows:Drop table Orders cascade constraints;Drop type item_type;Drop type Item_nested;Create or Replace Type item_type AS Object (Cat_code Varchar2(6),Amount_ord Number(3),Cost Number(5,2) );/Create or Replace Type item_nested as table of item_type;/Create Table Orders (Order_no Varchar2(8) constraint pkorder primary key,Customer_name Varchar2(30),AddressLine1 Varchar2(20),AddressLine2 Varchar2(20),AddressLine3 Varchar2(20),Town Varchar2(20),Postcode Varchar2(10),Coun
I am trying to do a procedure to input information for one order and another for 2 orders.The information I have so far is as follows:Drop table Orders cascade constraints;Drop type item_type;Drop type Item_nested;Create or Replace Type item_type AS Object (Cat_code Varchar2(6),Amount_ord Number(3),Cost Number(5,2) );/Create or Replace Type item_nested as table of item_type;/Create Table Orders (Order_no Varchar2(8) constraint pkorder primary key,Customer_name Varchar2(30),AddressLine1 Varchar2(20),AddressLine2 Varchar2(20),AddressLine3 Varchar2(20),Town Varchar2(20),Postcode Varchar2(10),Coun
I'm trying to create a report and create a filter for columns and the value of these column, it's something like that:P52_C1 (select list) return the name of the columns of the table.LOV:select column_name display_value, column_name return_value from all_tab_columns where table_name = 'table_name'order by 1P52_C2 (select list)LOV:select :P52_C1 display_value, :P52_C1 return_value from table_nameorder by 1In the item P52_C1 the query is working fine, but in the second item (P52_C2) query dont return the expected result, is returning the name of column a lot of times.Anyone have any idea.
I'm currently tring to drop a table using a process trigered by a button clickIcreated my button and also a "PL/SQL process" and I put ----DROP TABLE &P0_TABLE_NAME. CASCADE CONSTRAINTS;----inside field "source" with ticking the checkbox "Do not validate PL/SQL code (parse PL/SQL code at runtime only)." But when a click on the button I have the following error ----ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "DROP" when expecting one of the following: begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <
questions from a newbie on how to drop tables:1. How can I drop a table in cascade manner so that it's dropping its constraints?I did:drop table [table name] cascadebut it complains that it missing a keyword.2. What is the easiest command to drop all table without deleting a schema?3. Is it possible to delete a schema through sql command line in XE?regards,ValerieEdited by: Valerie Debonair on Aug 23, 2009 8:26 PM
SQL> exec dbms_stats.delete_table_stats(ownname=>'user_name',tabname=>'table_name',cascade_indexes=>true);PL/SQL procedure successfully completed.SQL> exec dbms_stats.gather_table_stats(ownname=>'user_name',tabname=>'table_name',cascade=>true,method_opt=>'for all columns size skewonly'); I'm running the above to gather statistic for a particular table (size 3G). It is running from past 3hrs. Is it normal?Can we check the status of that process, like its going on fine, or its active or not?Please update soon, its urgent.
Oracle 9iHow can i design a procedure to fetch data from a table and the output should be in XML in the calling environment. create table emp(empno number PRIMARY KEY, ename varchar2(40), sal number)insert into table emp values(1, 'Dave',1000);insert into table emp values(2, 'Den',2000);insert into table emp values(3, 'Ben',1000);insert into table emp values(4, 'Bel',1000);Is this idea correctCreate Package pack istype reft is REF CURSOR return SYS.XMLTYPE;end pack;create procedure proc(eid in number, cs out pack.reft)isbeginopen cs for select ename, salfrom empwhere empno=eid;end;calling envi