Home » Developer & Programmer » Forms » Forms 4.5 vs. 10g
Forms 4.5 vs. 10g [message #128581] Tue, 19 July 2005 10:04 Go to next message
mariaschreiber
Messages: 11
Registered: June 2005
Junior Member
Hy List,
simple question has ever one off you seen an Forms 4.5 Application
Runing against Oracle 10g is there some thing special to Configure
NET 8 / SQL NET

Thanx Maria
Re: Forms 4.5 vs. 10g [message #128621 is a reply to message #128581] Tue, 19 July 2005 18:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
We will be running a Forms 4.5 against Oracle 10g BUT as the Forms 4.5 is on a 32-bit machine and the 10g is on a 64-bit machine we will be using DBLINK from a Oracle 7 database on the 32-bit machine through to the Oracle 10g database.

David
Re: Forms 4.5 vs. 10g [message #128987 is a reply to message #128621] Thu, 21 July 2005 08:03 Go to previous messageGo to next message
mariaschreiber
Messages: 11
Registered: June 2005
Junior Member
HY David,
Tanks for the
answer

Maria
Re: Forms 4.5 vs. 10g [message #331464 is a reply to message #128581] Thu, 03 July 2008 08:34 Go to previous messageGo to next message
rysiekmus
Messages: 3
Registered: May 2007
Location: UK Manchester
Junior Member
Hello All,

I have a similar problem, but due to hardware limitations I would like to run my Forms45 binaries in a 64-bit AIX environment. We are planning to upgrade the applications for the web based Forms, but we need a grace period to install Oracle10g on all servers, so we will switch the AIX from 32bit mode to 64bit mode.
Will forms45 run on a 64bit machine?

Thanks in advance.
Richard
Re: Forms 4.5 vs. 10g [message #338162 is a reply to message #331464] Mon, 04 August 2008 00:52 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No.

David
icon4.gif  Re: Forms 4.5 vs. 10g [message #508484 is a reply to message #338162] Sun, 22 May 2011 01:38 Go to previous messageGo to next message
mzakhan
Messages: 1
Registered: December 2009
Location: SAUDI ARABIA
Junior Member
We recently migrated our database from 9i to 10g. We are using forms 4.5. On oracle 9i all forms of 4.5 was compiling successfully. but after migrating to 10 g all our forms giving error of non declare function & procedure. i.e, forms are not recognizing function and procedure store on 10g. Please advice.
Re: Forms 4.5 vs. 10g [message #508494 is a reply to message #508484] Sun, 22 May 2011 02:40 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
So where exactly are these functions and procedures declared? In the DB? a pll?
Re: Forms 4.5 vs. 10g [message #508495 is a reply to message #508484] Sun, 22 May 2011 02:41 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I hope that your problems are raised in test environment (and not production one).

I suppose that you should have migrated application from Forms 4.5 to 6i first (which shouldn't be a problem - simple COMPILE would do the job) (migration to Forms 10g seems to be a more complicated task, if you ever plan to do it). Anyway, how come you didn't consider upgrading your application along with the database? Now you have a HUGE step between.

As these procedures are stored procedures, check whether all required privileges are granted to a user that is compiling those forms. Furthermore, while Googling around, I found a note where someone said that there was a problem with a stored procedures' length (meaning "number of lines"); 5000 was a limit, and none of the "longer" procedures was recognized by Forms 4.5. Their workaround was to create another stored procedure that only called that "lengthy" procedure, and make changes in Forms calling those "new" procedures first. Something like this:
-- a new stored procedure
create or replace procedure new_prc_employee is
begin
  prc_employee;  -- this is existing, loooong procedure
end;

-- Forms trigger
<some_code_here>
-- prc_employee;   -- comment this line, as it calls a long procedure
new_prc_employee;  -- and call a new procedure instead
Previous Topic: Retrive Total Number in Details Block
Next Topic: Please provide the materiel for Forms
Goto Forum:
  


Current Time: Fri Dec 09 05:35:52 CST 2016

Total time taken to generate the page: 0.06415 seconds