Reg. using Forms builder in Unix

[rbala_sub]

Hi friends,

Can i have a small help from you. I need to convert a CUI form into GUI mode. Is there any possiblity of opening forms designer in Unix system. Can i have some info. on f60desm/f60runm executables.. What are the variables i need to set for this..

At the same time, as part of this converstion process, we can't create pure client server applications like having the application lying on every user's desktop as there will be many changes done everyday in the application .So we need to use the existing application server(HP-UX) and we have to convert to GUI.

I was advised to use Motif mode of operations.If there are any other ways of doing this please let me know.Do you have any idea on Motif mode of operations.. I was asked to change DISPLAY and LD_LIBRARY_PATH environmental variables in unix to make use of motif mode of operations.


Also i need infor. on calling an excel sheet from PL/SQL stored procedure. Is there any possiblity of the same ???

[bmycroft]

Hi there,
last I heard there was no GUI support for Forms Designer on UNIX (developer 6i) so you may be about to have some fun.

What version of forms are you using?

As for calling excel from forms. Do you just want to launch excel, or are you going to be manipulating the spreadsheet programatically. If the latter then use HOST('excel.exe'), iuf the latter then you need to look at the OLE2 package in forms and the excel object model (in excel......)



-Bob

[rbala_sub]

Originally posted by bmycroft
Hi there,
last I heard there was no GUI support for Forms Designer on UNIX (developer 6i) so you may be about to have some fun.

What version of forms are you using?

As for calling excel from forms. Do you just want to launch excel, or are you going to be manipulating the spreadsheet programatically. If the latter then use HOST('excel.exe'), iuf the latter then you need to look at the OLE2 package in forms and the excel object model (in excel......)



-Bob



Hi Bob,

I am using forms 6.0 version. I have got a unix version of forms gui (f60desm).

I am calling a excel sheet from PL/SQL Stored procedures. not from forms. I need to manipulate the excel sheet while loading. Manipulating the excel sheet i can do with using Oracle OLE object inside a macros. but calling the excel from oracle stored procedure is doubtful..

Bala

[JChiappa]

Bala, surely you will NOT find any facility built-in inside the database (i.e., in stored procedures, database triggers, etc) to read/write Excell data, so your choices will be :

a) call from your procedure an external executable program/routine to run Excell, or at least execute a program capable of read Excell data. To do it, you will use Java (if your db version is 8i), call an external routine (if version 8), or use dbms_pipes (if version 7). Find in the old messages of the forum more examples.

OR

b) using Excell, save the data in ASCII text-format, and use the facilities built-in in the database to read the text data.

[]s
Chiappa

[rbala_sub]

Hi chiappa,

thanks for the info.. I will try with java.

regards
bala

Originally posted by JChiappa
Bala, surely you will NOT find any facility built-in inside the database (i.e., in stored procedures, database triggers, etc) to read/write Excell data, so your choices will be :

a) call from your procedure an external executable program/routine to run Excell, or at least execute a program capable of read Excell data. To do it, you will use Java (if your db version is 8i), call an external routine (if version 8), or use dbms_pipes (if version 7). Find in the old messages of the forum more examples.

OR

b) using Excell, save the data in ASCII text-format, and use the facilities built-in in the database to read the text data.

[]s
Chiappa