Re: calling graphics from forms

In <319206B0.394E_at_bpainc.com> James Carroll <james.carroll_at_bpainc.com> writes:

} I've embedded a graphic in a form and want to use
} the OG.INTERPRET command to execute procedure in graphics
} from forms.
 

} OG.INTERPRET(chart_file, 'secs_chart', 'set_run_number(15);');
} OG.INTERPRET(chart_file, 'secs_chart',
} 'set_query_parameter(fc5_actual);');
} OG.INTERPRET(chart_file, 'secs_chart', 'set_query;');
}
} The first and last one work ok, but the middle one gives me
} a PL/SQL error (in graphics).

It's not clear from the code sample you gave what you're trying to do. If you want to pas the literal string "fc5_actual" as the parameter, you'd want to do:

   OG.INTERPRET(chart_file, 'secs_chart',

                'set_query_parameter(''fc5_actual'');');

If fc5_actual is a local PL/SQL variable, and you want to pass the value of that parameter, you'd want to do:

   OG.INTERPRET(chart_file, 'secs_chart',

                'set_query_parameter('|| fc5_actual ||');');

Remember: the third argument to og.interpret() is a character string which gets interpreted by Graphics, as if you had typed that literal string into a trigger within Graphics.

Paul Zola                                                 Technical Specialist
World-Wide Technical Support                                 Development Tools
==============================================================================
Computers possess the truly profound stupidity of the inanimate. - B. Sterling
Disclaimer: 	Opinions and statements are mine, and do not necessarily
		reflect the opinions of Oracle Corporation.