display chart based on csv-file or blob with forms 1

[hudo]

Hello,

I'd like to display with Forms 10g a chart, which is based at the moment on a (bfile-object) csv-file. The structure of the csv-file is:

Time,Torque,Angle,...

0,0.04,0.1
0.01,0.04,0.2
0.02,-0.24,0.5

How can this be done ?

For security reasons the bfile-object will be replaced by an object which is saved in the database itself, perhaps a blob.

Please show/give me detailed instructions. I looked at the Forms Online-Help Graphics-Builder Tour but it did not work, some og. commands were not found...

Is there a difference in using or displaying charts with Forms 6i and Forms 10g ??

 

[HimanB]

Hudo,
Indeed you will not be able to find OG commands as Oracle Graphics is dropped in 9iAS v2 and BI chart beans are available for charting.

There is no migration from Graphics 6i to the charting engine in Reports 9i. However, for backward compatibility, Reports 9i is able to use the 6i Graphics engine - but 9iAS 1.0.2 must be installed on the SAME machine (in a different Oracle_Home).

For more details, please refer to Note:197889.1 on Metalink.

HTH
Regards
Himanshu

 

[HimanB]

Hi,
Some more info for you.

For Forms 9i to display the chart, it is necessary to call Graphics 6i executables. Graphics 6i must be installed in the same machine where Oracle 9iDS / 9iAS is installed, but in a separate Oracle Home.

A environment variable ORACLE_GRAPHICS6I_HOME must be created in registry (for windows) where you find the environment variables for Forms 9i or better should be set in the default.env file from forms90.

ORACLE_GRAPHICS6I_HOME must be set to the directory of Oracle Home of Graphics 6i For example, if Graphics is installed in e:\graphics6i, then ORACLE_GRAPHICS6I_HOME should be set to e:\graphics6i
You have to set GRAPHICS60_PATH to find your chartfiles also.

HTH
Regards
Himanshu