| Oracle Graphics Error ----Gurus please Help [message #84595] |
Thu, 01 April 2004 23:08 |
sridhar
Messages: 119
Registered: December 2001
|
Senior Member |
|
|
Hi,
Please Help if anyone has any insight into this. Please e-mail to Sridhar.Nallani@AREVA-TD.com & Nallani@Yahoo.com
Now, what happens when a graph comes up is that a little window(just like it does for reports) shows up that doesn't go away, so wanted to eliminate this little window and wrote a small piece of code to kill the window. This code freezes the screen and if comment this line out....it still freezes if we try to kill the window manually.
Look at the code
===========
-- kill the graphics background engine
OG.INTERPRET(v_GraphName, 'graphs.chart1', 'og_quit;');
===========
We get an error
---------------
'GLOBAT60.exe has generated errors and will be closed by windows. You will need to restart the program.
An Error log is being created.
---------------
Now a Database/Environment Could be totally unrelated, but just worth the mention....background here. This problem doesn't occur on a our schema's at AREVA where we have a Single Instance Database running. It happens at the customer site where they are using a RAC...clustered environment. As a further test though the DBA's here shutdown one instance, but still saw the problem happen.
Code behind the Graph button(WHEN-BUTTON-PRESSED Trigger)
=================================================
PROCEDURE call_graph IS
pl_id ParamList;
v_GraphName varchar2(100);
BEGIN
-- clear the chart
go_item('graphs.dummy');
do_key('clear_block');
pl_id := Get_Parameter_List('tmpdata');
if not Id_Null(pl_id) then
Destroy_Parameter_List( pl_id );
end if;
pl_id := Create_Parameter_List('tmpdata');
if :graph_control.zone <> -999 then
-- a zoneid is being passed
Add_Parameter(pl_id,'P_ZONEID',TEXT_PARAMETER,to_char(:graph_control.zone));
end if;
v_GraphName := 'schedule_changes.ogd';
Run_Product(GRAPHICS, v_GraphName, SYNCHRONOUS, batch, FILESYSTEM, pl_id, 'graphs.chart1');
destroy_parameter_list(pl_id);
-- kill the graphics background engine
OG.INTERPRET(v_GraphName, 'graphs.chart1', 'og_quit;');
END;
=================================================
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
