OraFAQ Forum: Forms » Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows

Home » Developer & Programmer » Forms » Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows (Forms Builder Version 9.0.4.0.19 on the Solaris-8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630582]

Tue, 30 December 2014 12:21

doddiv
Messages: 11
Registered: May 2006

Junior Member

Hi All,

I am in an unusual situation associated with an application that has needed upgrade but delaying due to unavoidable circumstances.

My desktop with Windows-7 is my development environment. It has Forms Builder with version 10.1.2.0.2 which I can only access in Windows-XP mode. We have an application running on Solaris-8 (hosted on top of Solaris-10) developed in Forms version 9.0.4.0.19.

Now I need to increase a field length on one of the screens. If I modify the file on version 10.1.2.0.2, the compiler on the host (with version 9.0.4.0.19) is throwing an error FRM-30085: Unable to adjust form for output. So, I thought of modifying the file by invoking the Forms Builder on the host itself which has in version 9.0.4.0.19. But could not able to find the executable. Could someone please help me by giving the correct file name and if possible how to invoke it by using the Reflection X-Windows.

For info I have a different application on Solaris-10 with Forms 11g and successfully invoking the Forms Builder through the Reflection X-Windows by executing frmbld.sh which is in the /u01/Oracle/Middleware/asinst_1/bin directory. I am looking for similar executable in the version 9.0.4.0.19? Appreciate for any help!

Report message to a moderator

Re: Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630583 is a reply to message #630582]

Tue, 30 December 2014 15:43

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use X-Windows so I can't suggest anything.

However, regarding "FRM-30085: Unable to adjust form for output": my 9.0.4 raises it probably every time I adjust field lengths (so that's either bug or expected behavior, can't tell). What I do (and what almost always helps) is to acknowledge that message and compile all (Ctrl + Shift + K). No FRM-30085 any more.

So, if you didn't try that yet, do it now. Any improvement?

Report message to a moderator

Re: Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630584 is a reply to message #630582]

Tue, 30 December 2014 16:09

doddiv
Messages: 11
Registered: May 2006

Junior Member

Hi Littlefoot, many thanks for the reply!

But, I believe you didn't completly understood my problem. I am not getting the mentioned FRM error on the Windows where the builder version is 10.1.2.0.2. So, from fmb to fmx is OK on the Windows desktop. But I have to deploy the modified fmb file (not the fmx file) from windows to the host which is Solaris-8, with Oracle app server version 9.0.4.0.19. There on the host the compilation is giving the FRM error. Why I am getting error on the host? Because the modified fmb is from the higher version and the compiler on the host is in lower version.

Instead of deploying the modified fmb (10.1.2.0.2) file, I would like to take the archived fmb (version 9.0.4.0.19) on the host, then open it on the Forms Builder invoked on the host, modify and compile there itself on the host. This way I can eliminate the FRM error. To do this I need to know what is the builder file name on the host which is with 9.0.4.0.19?
Hope you followed my point?

Report message to a moderator

Re: Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630585 is a reply to message #630584]

Tue, 30 December 2014 17:08

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sorry, I should have read your message carefully. Anyway, as I said, I don't use Solaris and I have no idea what would be 9.0.4's executable name over there. Hopefully, someone else will respond.

Report message to a moderator

Re: Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630951 is a reply to message #630585]

Tue, 06 January 2015 11:43

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

You can run Oracle Forms on UNIX using the frmbld.sh, but you will have to search for it on your UNIX server. Unfortunately, I don't have Forms 9i or 10g installed any longer so I can't tell you for sure where the Forms Builder shell script is located. I can tell you that I have successfully ran Forms Builder 10g on Solaris so it is possible. You will need to make sure your environment is configured correctly (eg: ORACLE_HOME, DISPLAY, etc) so Forms Builder can find everything it needs in order to run.

Craig...

Report message to a moderator

Re: Invoke Forms Builder (Version 9.0.4.0.19) on the (Solaris-8) command using Reflection X-Windows [message #630953 is a reply to message #630582]

Tue, 06 January 2015 14:01

doddiv
Messages: 11
Registered: May 2006

Junior Member

Hi Craig,

Many thanks for the info.
I got a reply from Oracle support web site. They mentioned the executable name as f90desm.sh. The executable that you mentioned is on the next higher version onwards.

To work on this, now I have to get oracle OS account access and have to set DISPLAY, etc.,

On Unix Platforms:
Forms Version Executable/Script Name
6.0.x f60desm
9.0.x f90desm.sh
10.1.2.x frmbld.sh
11.1.x frmbld.sh

Report message to a moderator

Previous Topic:	Pre Insert In Oracle Form
Next Topic:	How to filter/display particular file using text parameter while Browsing In D2K6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 08 21:10:51 CDT 2025