Forms :: Builder 10G Software
Mar 21, 2011The Link for free download of Oracle Form builder 10g software ?
View 7 Replies
ADVERTISEMENT
Reports & Discoverer :: Use Graphic Builder To Make Chart In Report Builder?
Aug 10, 2010i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf
View 6 Replies View RelatedForms Builder-exe Application?
Mar 8, 2010if i can run an exe application ('Hello World!')from forms builder,is there a specific command?
View 1 Replies View RelatedForms :: Oracle Graphics Builder 6i
Apr 22, 2011I am using Oracle Form Builder and Graphics Builder 6i. In Graphics Builder I create a graph from this query view but in result my result is reverse which i want..
==============================================================
Create or Replace View V_Mnth_Attn as
select
emp_id, max(nm) name, max(cid) cmp_id, max(dpt) dpt_id,
min(case when to_char(dt_attend,'dd') = '01' then abrr end) "D_1",
min(case when to_char(dt_attend,'dd') = '02' then abrr end) "D_2",
min(case when to_char(dt_attend,'dd') = '03' then abrr end) "D-3",
min(case when to_char(dt_attend,'dd') = '04' then abrr end) "D-4",
[code].....)
because i want values in graph of all columns but i got only employee id on values and on get all values on x axis .
Forms :: Oracle Translation Builder
Nov 7, 2005Trying to translate FMB (Base Language-English Translation language-French) . Have followed all the steps as given in a metalink Note:70117.1
Create a project and module and add a version and add a translation and then export the strings to same fmb
As per the note I should see the french labels etc when I set the NLS_LANG as FRENCH_FRANCE.WE8ISO8859P1 and run the form But I still see the English labels.
What am I missing ,
-- The note points out to install French Fonts but I don't know which fonts to install and how to install them from ?
-- Also Do I need to select a french font and script using Edit > Change Translation Font in the Translation Editor before exporting the strings ?
Forms :: Builder Debugger Dialog Box Server Name
May 31, 2012I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.
View 7 Replies View RelatedForms :: Creation Of Master Details Using Builder 6i
Oct 11, 20101.steps to create master-detail form using form builder 6i ,db oracle 9i.
2.Using dept and emp(database table)
3.one more thing difference between cascading/isolated while creating relation b/w dept and emp using join method
Forms :: Oracle Translation Builder Not Working?
Feb 9, 2013i want to use oracle translation builder to translate forms and reports from English into Arabic i run run the script SQLBLD and create new db connection an finally create a new project when am trying to import module i got the error NX-00201
View 3 Replies View RelatedForms :: Builder 6i - Layout Editor Crashes?
Sep 19, 2011I installed forms builder 6i as I am making a change to a custom form which was created in 6i. When I attempt to use the layout editor, it crashes immediately. The dll module that it seems to get stuck on is uiw60.dll. I have this file on my machine. I added the directory location to the FORMS60_PATH in the registry as it was missing but I am still crashing. The version of 6i I have is 6.0.8.11.3.
View 1 Replies View RelatedForms :: Unable To Open FMB File In Builder?
Jan 30, 2012I am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.
Forms :: Use Trunc Function In Form Builder
Aug 6, 2011i have problem when use trunc function in form builder i have two cloumn first column inserted data is 15.55 and i want the secound cloumn the will be too 15.55
i used this code but nothing happened
select sum(trunc(item_name,2)
into column2
from table_name
always the result be 16 i want it 15.55 without any round to this value
Forms :: Builder 9.0.4.0.33 - Call Report From Form
Nov 11, 2011I used Report Builder 9.0.4.0.33, and i want to call 1 report name is "DOCK_RECEIPT.rdf" from Form when click into button name is "Print". I write code in When-button-press follow: This is code call report from Form.
Declare
pl_id paramlist;
Begin
pl_id := get_parameter_list('tmpdata');
[code]....
On report "DOCK_RECEIPT" has parameter same parameter on Form. But when i click button "Print" then can't call report,while form and report that together folder.Now, i want to question, how must configure report builder for call report from form that? example: about directories,path, etc
Forms :: Oracle Builder Object Navigator Reports
Nov 16, 2011I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:
- Forms - MODULE - Reports
I want to know what is the purpose of REPORT section in the Forms Builder.
Forms :: Oracle Builder 10g Crashes When Trying To Go To Layout Editor
Apr 4, 2012I am using Oracle forms builder 10g version. Since last week, I can't open layout editor of any of the forms using my builder tool. I tried rebooting, restoring, creating new form etc. Some times it works, but after a couple of hours the issue returns.
View 13 Replies View RelatedForms :: Connection String In Form Builder 6i To SYS User
Jun 9, 2013i want to create a form like a console with form builder 6i for databases monitoring. I have to connect to more than 10 databases and monitoring them at same time.
My question is, how can i create connection string for each one in form builder? after connect to per database i want to select some quires, for example
:
"select STATUS from v$instance;"
Attention: i don't want use db-link
Forms :: Error Appears In Builder 11g And Weblogic Server
Jan 5, 2011i'm facing a problem when i run form om forms 11g
that error appears :
frm-10142 HTTP listener not running on weblogic on port 80
and when i ran it on weblogic server after compiling it on internet explorer a blank window appear and written DONE
Forms :: How To Pull Off Report From Builder 6i Within Specific Date(s)
Sep 9, 2011SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3
With regards to the above version description here is my query. I have a form which calls report it accepts various parameters like date between, appeal and so on . I want the report to be restricted to the date parameter as passed by the user.Here is my coding which runs report
Declare
Pl_id ParamList;
where_cond varchar2(2500);
Begin
------------Appeal------------------
if
upper(ltrim(rtrim(:appeal)))<> 'ALL' then
where_cond:= where_cond ||'and tbl_donation.appeal_code='||ltrim(rtrim(:blk_ihelp.appeal_code));
else
where_cond:= where_cond||' and tbl_donation.appeal_code is not null';
end if;
-------------Date Option----------------
if
:date_option is not null then
if
:date_option = 'BETWEEN'then
where_cond:=' and tbl_donation.donation_date between '''||ltrim(rtrim(:fdate))||''' and ''' ||ltrim(rtrim(:tdate))||'''';
else
where_cond:=' and tbl_donation.donation_date '||:date_option||''''||ltrim(rtrim(:fdate))||'''';
end if;
end if;
--------------Country-------------------
if
upper (ltrim(rtrim(:country))) <> 'ALL'then
where_cond:= where_cond||'and tbl_donation.country_code='||ltrim(rtrim(:blk_ihelp.country_code));
else
where_cond:= where_cond||'and tbl_donation.country_code is not null';
end if;
-------------Contact Code---------------
if
:contact_code is not null then
if
:contact_code = 'BETWEEN'then
[Code]....
Forms :: Calling Report Designer 5.0u (MRD) From Oracle Builder 6i
Dec 2, 2010i tried to call Report Designer 5.0u Editor (MRD) it is not supported Oracle tools products from form builder Ver6i i try to use RUN_PRODUCT built-in but is not work, how i can call products not supported by oracle like Crystal Reports XI , Report Designer. I located my file in my local PC C: empVD.mrd
View 10 Replies View RelatedForms :: Retrieving Dynamic Values In Builder 10gr2
Jun 30, 2011How can i use this below example in forms builder 10gr2
var oput_cur refcursor
var tabname varchar2(30)
exec :tab_name := 'dual';
begin
open :oput_cur for 'select * from ' || :tabname;
end;
/
print oput_cur
how can i get the values from oput_cur into forms grids(containing text items).
Forms :: How To Create Browse Button In Oracle Form Builder
Mar 19, 2010I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?
View 1 Replies View RelatedForms :: How To Built Form (oracle 6i) That Connect With Report Builder
Feb 16, 2013How i can to built form (oracle 6i) that connect with report builder ?
View 2 Replies View RelatedForms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop
May 20, 2010We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.
My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:
Failed to load the following objects: APPSTAND, etc etc.
Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?
Forms :: On-Update Trigger To Replace Default Form Builder Processing For Updated Records
Mar 8, 2007I'm using an 'On-Update trigger' to replace the default Form Builder processing for updated records. When I try to change a column in the form I get: ORA- 01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
The on-update doesn't fire. How do I get around this. The block is based on a view.
How To Connect Oracle DB With C Builder 5.0 Application
Jul 27, 2010i want to know how can i connect c builder application with oracle 10g express ? which components i have to use?
View 1 Replies View RelatedGraphics Builder Canvas Resizing
Aug 8, 2011I have designed a chart in graphics builder(v 6.0.5.0.8). I would like to call this chart in Oracle Developer Forms (v 6.0.5.0.2).
I use run_product command which works well and the chart is opened in a big canvas. There are too much blank spaces in the canvas out of the chart area. What I would like to do is I just would like to see chart area and make this flexible depending to the data presented on it.
SQL & PL/SQL :: Customized Query Builder Architecture
Feb 5, 2013I got a task to send some alters based on the user query data .As user is not a SQL expert, so we have to provide him a query builder. Now to store user query, I decided to build a data model and keeping in mind the reusability of previously made queries (so that we can use them directly in further queries).Like a user made two queries:
1. Find patient id, name, sugar_level, pulse_rate, weight for those patients whose diabitic level is greater than 'X'
2. Find patient id, pulse_rate for all those patients whose diabitic level is greater than 'X' and weight > 90
So first query can be directly used in second query. (Just a very simple example)But I am pretty much confused with the decision of columns for each table to store query and how to relate them.
Tables I am able to identify is :
1. Table to store query level details, i.e. query_id, who created, query_short_name, query_description, operator used (SET, GROUP BY, HAVING, etc), distinct indicator, etc.
2. select clause table or columns selected table
3. From clause table
4. table to store group by clause
5. table to store having clause
I am trying to store seprate parts of the query into seprate tables, but not getting which columns to have in each table, how to relate them... and after that, for a given query_id, procedure to construct a whole query, and then validate/parse and execute it using dbms_sql and scheduler.
After Conversion 11G Very Slow - Power Builder Application?
Dec 19, 2011We converted our Power builder application from Oracle 10g to Oracle 11g. We are getting very slow to retrieveing data from the server.Basically we have noticed the following system internal sqls taking more time during our sql calls.
My schema Name : CMATISPROD
Oracle Version : 11.2.0.2.0
Indexes are moved separte table space.how to resolve this problem.
SELECT index_name, uniqueness
FROM SYS.all_indexes
WHERE table_owner = 'CMATISPROD' AND table_name = 'EXPRESSIONS';
* Formatted on 2011/12/15 14:19 (Formatter Plus v4.8.0) */
[code]...
Reports & Discoverer :: WITH Clause In Report Builder
Jun 12, 2013I'm trying to have RB use the following query:
WITH MY_DATASET
AS (SELECT /*+ materialize */
DISTINCT
N.NAME_ID NID,
NVL (TO_CHAR (RN.CONFIRMATION_NO), 'ACCOMPAGNATORE') CONF,
RN.RESV_NAME_ID,
MEV.TAX1_NO PARTITA_IVA,
[code]....
But although perfectly working in SQLDeveloper, RB returns an ORA-942 table does not exist error, pointing at MY_DATASET as the offending name.
Reports & Discoverer :: Any Way To Pass Delimiter In Builder
Dec 15, 2010I need to produce Excel spreadsheet from report builder.currently I am getting a format like,
ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;
This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,
ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,
This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.
Oracle Warehouse Builder 11.2 - Deploy To New Repository?
Feb 24, 2012 I have a big probleme with owb 11.2.
1. I have export MDL file from owb 10.2
2. I created owb repoisitory on server where I have installed my database 11gr2.
3. I have installed OWB 11gr2 on another machine.
4. Imported MDL file to new repository.
How I deploy to my new repository?