I 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.
I 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 .
is there any method in placing a stacked canvas inside a tabbed canvas ?
View 8 Replies View RelatedI have Table that save a color (specific color) , i want to change this color for all forms included windows and canvases at Runtime (by Code) .
My problem is : i can't move from canvas to canvas to change its color ( name of canvas ) - no next canvas code - like next block?
Can we place tab canvas in content canvas?i have created one header section based on content canvas.next line level i need to display tab.how can i do this?
View 1 Replies View RelatedI have tried enough to put Tab canvas on content canvas so that they can appear in the same window. I have tried on internet and unluckily find only
[URL].....
I didn't understand how to do it.
We have placed Stack canvas on tab canvas. The Stack canvas will be visible/Invisible based on some condition dynamically. The Issue is When you show the stack canvas by using Hide_View('Canvas') , the stack canvas is shown on all tab canvas instead of displaying in the first tab canvas.
How to over come this issue and can we place stack canvas on tab canvas?
i 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 RelatedI have a tabbed canvas within Oracle Forms 5. On one tab I have several frames and text items. (Only they arent called items, but are called graphics which lie underneath the canvas.)
I have tried using the ...
SET_ITEM_PROPERTY(item_name, property, value)
...statement to hide the graphics, but it doesn't work.
What function would I have to use in order to hide graphics?
I have a stored procedure that updates a series of columns (set at varchar(500) just to ensure there is ample space for whatever data is inserted into it) .Once it has updated though I've wanted to trim the column width down to the maximum size of the column value. I determine the max size of the column length and use that in a pl/sql command to ensure the width isn't smaller than the largest data entry.
When I try to do this I get the following message:
ORA-01441: cannot decrease column length because some value is too big
Now after hunting this down it seems as though you cannot decrease the size of a column once data has been inserted into it.
Any success in reducing the column width of a table that has data in it?
Why do I need to do this? I am exporting this table from Oracle into a propriety application and I am trying to reduce teh size of the export table by removing any unecessary space the unused spaces in the column. This will benefit the local app in addition to reducing the impact on the filesystem storage.
I'm using Oracle 10gR2 (10.2.0.4.0) 64 bits.
I got many times oracle ORA-00494 error and the database went down but since 29th of july the database have not been killed.
The error message is below :
ORA-00494: mise en file d'attente [CF] d�tenue pendant trop longtemps ( (more than 900 seconds)) par inst 1, osid 176484
ORA-00028: votre session a �t� ferm�e
My database is used for datawarehouse of many terabytes.
Initially the redo log size was 500Mbytes and I've set it to 3Gbytes. The maximum log switch is after 5 minutes. I want log to be switched every 20 minutes or every 30 minutes.
To obtain the size of redo logs I've executed this query :
SQL> select OPTIMAL_LOGFILE_SIZE from v$instance_recovery;
OPTIMAL_LOGFILE_SIZE
--------------------
54763
53,5 Gbytes is it not very big as redo log size? What's the maximum size of redo log? To set very big redo log size what are the requirements? Which precautions should I take before? What are the risks? Are any other ways to change the log switch frequency?
I've a 2 stacked canvases(canvas_live_appmnt, canvas_cancelled_appmnt) and Tab canvas(cc_main).Now I need to move the stacked canvas on the Tab canvas.I tried writing the When-tab-changed trigger as follows: In the below code I was trying for only one of the stacked canvases.
DECLARE
L_LOCAL_TP_NAME VARCHAR2(30);
BEGIN
L_LOCAL_tp_name := GET_CANVAS_PROPERTY('CC_MAIN',topmost_tab_page);
IF L_LOCAL_tp_name = 'LIVE_APPOINTMENTS' then
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_TRUE);
--SET_VIEW_PROPERTY (FIND_VIEW ('CANVAS_LIVE_APPMNT'), DISPLAY_POSITION, 0 , 325);
ELSE
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_FALSE);
END IF;
END;
I want to create a tabular type form on a tab canvas.. but my fields are often out of the form range. i want to create a stack canvas on tab canvas but it say that stack canvas and tab canvas must be created within content canvas.
how can i manage it what can i do now. i also attached pic of my tab canvas. i show some fields on tab canvas and 3 more fields i inserted on this canvas. And i can't reduced the width of my fields.
I have a tree region, surrounded by <div>, the height of which is set on page load by a dynamic action so that it is 200px smaller than the window.innerHeight. I have set overflow:auto in the style so that the full free can still be viewed. I now want a dynamic action which fires when the window is resized, which automatically adjusts the size of the region accordingly, so that the region always remains 200px smaller than the innerHeight of the window. I can get the dynamic action to fire by setting the event to resize, however it does not change the size of the region.
View 1 Replies View RelatedI have a form with 2 content canvas. each canvas has its own windows.
canvas A is for inquiry person name
canvas B is people detail returned from first canvas.
now my problem is only A is showing when form instance
question: after open form, how to make both of canvas showing out. A active and B show behind
I want to call another canvas in same window.using this code /it not work show_view('canvasname');
View 1 Replies View RelatedI have an form with a few canvases already in it. The problem is that I want to see a particular canvas which shows the toolbar at the top of the window but it dosent show up on the form. I checked the property palette and the canvas is visible. There is also an other canvas right at the top of the form. How do I move the other canvas down if this is covering the toolbar canvas. How do i move the canvas down as it dosent show any X position in its property palette.
View 1 Replies View RelatedHow to call the canvas from the menu module on which the form linked to the menu items.
The canvas lies in the same form where menu is attached.
I have a tab canvas with 4 tab pages.I want to set scroll bars for each tab page. I draw 4 stack canvas on 4 tab page but it doesn't transferred fields in each tab pages.
View 4 Replies View RelatedI use forms10g in windows xp, i create a tap and toolbar canvases in content canvas but at runtime i can see only toolbar canvas.
View 1 Replies View RelatedI'd like to hide my stacked canvas. This is my scenario, i have my content and stacked canvas on the same window. When i click a button on the content canvas it will display the stacked canvas, this is the code that i used:
SHOW_VIEW('CV_STACKED');
And on my stacked canvas, i put a button close and fired a when-button-pressed trigger,
HIDE_VIEW('CV_STACKED')
supposedly, it should hide the stacked canvas, but it doesn't hide. i tried SET_VIEW_PROPERTY('CV_STACKED', VISIBLE, PROPERTY_FALSE)
How to call the canvas from FORM A to FORM B . Form A contains canvas 'can_test'
Form B contains canvas 'can_sub'
I want to call 'can_test' from 'can_sub'
How to achieve this one?
is that datablock should have related to show the stacked which is hidden in content canvas
i have attached the stack.fmb
I have a problem while changing in a form canvas color
i make some modification in a form. The layout color of the canvas is blue. i want to change the layout color of it to default (<unspecified>) (which is the default color).
when i change in the property pallet the background color to <unspecified>. it give me that error FRM-12305 color by this name doesn't exist and i want it the default color.
how can i do it without recreating the form from the beginning.
I am using Forms 6i in Oracle Applications, In the button click event i used set_canvas_proeprty() twice. First time it executes these two statements, second time it does not. If i use any message() statement before these two statements, it executes.
Do we have wait() statement in Forms ?in apps we have app_item_property.set_property(), can we use same command to set canvas property also.
i need to position my canvas at run time.
View 3 Replies View RelatedI have 3 canvases ---> X ( Content), Y ( Stack) and Z ( Stack) which has 3 blocks BX, BY, BZ resp.
WHEN-NEW-BLOCK-INSTANCE trigger of BX :
execute_query;
show_view('Y') ;
Now X and Y both canvases are displayed.
[code]....
Now only X is displayed. Canvas Y is vanished after a single blink. But I require both canvases as in initial stage.
I need to display my alert prompt right after I detect the discrepancy on amount. I place my code on POST-BLOCK. The problem is, after the query, the alert pops out right before the new canvas where the block with POST-BLOCK trigger shows.
I need to display first the canvas before the alert but seems like the process of displaying canvas is the last job oracle does. So even if I place my code on post-record or any other trigger it will be the same.
i am trying to use read_image_file property , and it worked ,but unfortunately , the image is not adjusted with the canvas,
i changed the sizing style property to (adjust) , but also vainly , it is not adjusted with the canvas
I have a form that contains a tab canvas. On the second canvas page I have two data blocks with a master detail relationship.The first block (master) is driven by a table (table_one) with the following fields:
sf_id (PK)
sf_code - VARCHAR2(40)
sf_desc - VARCHAR2(250)
The second block (detail) is a repeating block driven by a table (table_two) with the following fields:
error_code - VARCHAR2(40
error_code_desc - VARCHAR2(250)
is_major_error - VARCHAR2(1)
error_type - VARCHAR2(1)
error_is_active - VARCHAR2(1)
update_date - DATE
sf_id (FK - table_one.sf_id)
The second block only shows error_code and error_code_desc. The point of this canvas page is to add/remove master records and associate detail records with a master. I never want to actually insert or remove records from table two; merely updating the sf_id column in table two.What I am trying to achieve is the following:
1. Create a master record with detail records at the same time.
2. Delete a master record
3. Add and remove detail records
An insert into the detail block is nothing more than associating a master record with a detail record by updating the sf_id column in table two. A delete from the detail block is nothing more than setting the sf_id column to null in table two. I am not actually adding or removing records in table_two.
I have tried overriding the commit on the second block to perform updates instead of Oracle actually trying to insert NEW records into table_two.
