Re: Forms 3 and 9i
Nah, that's not neccessary. It's the same guy that took them from 7 to 8 and who will take them from 9 to 10 :-), namely our Jutland Department named Johannes. We had a meeting about iAS in the Danish user group the other day (OUGDK) titled Can you get by without iAS?, in other words is it possible to create solutions without iAS. The answer, except for Forms Reports, is of course yes, but you would then have to put a lot of stuff together yourself, and Oracle does a rather OK job on the Java front there. But that's another story. The interesting discussion quickly became what to do about Forms Reports. Everybody agreed there isn't much of a future for these products, but what would they use instead? A lot of Forms-folks noted that 1) Forms works very well these days and 2) Java code is so much bigger and more complicated. So although we all pretty much agreed that it's Java or .Net as development platforms in the coming years, people would still (especially in the large shops) continue using Forms. Mogens Smart Aleck DBA wrote: .. and be sure to document for the next poor slob that has to act as admin for this mess On Thu, 21 Aug 2003, Peter Gram wrote: Hi Yes it is posible to use Forms 3.x agenst a version 9.x database. My friend and coworker have implanted it at site on a sun box. The way to do this is to install Forms 3.x ( 7.2.x dist ?) in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH. Set the unix environment var. TWO_TASK to point to a IPC alias to the listener that can connect to the 9.x database. The hard part is to find the Forms 4 patch (xx) it is not possible to order it from Oracle support but I think it as distributed with the 7.3.x Oracle database kit ! Senthil Kumar wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db security, managed from application forms
List, after reading so much about managing the srcurity from the db users, roles and privileges, i have finally decided to do the same. I have figured out most of the things... 1. i have made a form interface to create role and grant privileges to roles. all the data goes to app tables, and then DB roles are created and grants given which matches the data entered. I have a routine which syncs the role/privs in the app tables to the db roles and privs. 2. another form provides interface to create users and grant roles to users. 3. then i have a MMB menu attached to a form which is executed. the user will login, and will be displayed a menu based on the role given to the user. this is where i'm not sure how would i handle it, something like... on-new-form-instance i would check the role name from the session_roles, and would have a table which would tell me which menu option has to be enabled with this role. am i going the right way ?? the forms will be run on the web, so i guess i cannot store them in the db, and cant use the menu roles facility. i have done a lot of work on this.. but cant figure out the role and form module to run...i dont want to go back to one app user accessing the db, and application managed seurity would appreciate any help. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db security, managed from application forms
Hi Rahul, I know this isn't a direct answer to your question but you may find useful a large number of papers about Oracle security that are available on my website, quite a few by me and links to papers by many others that I have collected together. My site is http;//www.petefinnigan.com - have a look at the white papers section. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db security, managed from application forms
thats not appropriate. go to metalink, there is a script to run to setup security to work with .mmbs. we used on a project i was on last year. I think it was pretty easy to use. it just creates views and checks existing roles. I 'think'. I cant remember exactly. I think you combine this with a database logon trigger. your reinventing the wheel. Also, if you want to grant roles on the fly, I dont recommend this in the application layer. You should put it into a package in the database. fatcity has an odtug dev2k forum where you will probably get a better response. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 30, 2003 10:59 AM List, after reading so much about managing the srcurity from the db users, roles and privileges, i have finally decided to do the same. I have figured out most of the things... 1. i have made a form interface to create role and grant privileges to roles. all the data goes to app tables, and then DB roles are created and grants given which matches the data entered. I have a routine which syncs the role/privs in the app tables to the db roles and privs. 2. another form provides interface to create users and grant roles to users. 3. then i have a MMB menu attached to a form which is executed. the user will login, and will be displayed a menu based on the role given to the user. this is where i'm not sure how would i handle it, something like... on-new-form-instance i would check the role name from the session_roles, and would have a table which would tell me which menu option has to be enabled with this role. am i going the right way ?? the forms will be run on the web, so i guess i cannot store them in the db, and cant use the menu roles facility. i have done a lot of work on this.. but cant figure out the role and form module to run...i dont want to go back to one app user accessing the db, and application managed seurity would appreciate any help. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms - as sysdba
Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the upgrade - certainly test it out on a test system first. Regarding the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -Original Message- Sent: Friday, 22 August 2003 4:49 PM Robo You can connect as ifrun60.EXE C:\...\..\logon2.fmx Regards Suhen -Original Message- Sent: Friday, 22 August 2003 4:39 PM I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situation as Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\form.fmx sys/[EMAIL PROTECTED] \/'as sysdba' =RP= -Original Message- Sent: Thursday, August 21, 2003 5:54 PM Rather, why do you want to connect as SYS ? If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that user and connect as that new user in Forms. -- and think about migrating the tables out of the SYS schema. If you are querying standard tables, OEM provides good views for most of what you need and the group here can provide better SQL scripts anyway. Hemant At 07:29 AM 21-08-03 -0800, you wrote: Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes) But why do you want to connect as sysdba anyway? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms - as sysdba
Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms - as sysdba
Title: RE: Forms - as sysdba What about granting sysdba priviledge to yourself? then you could do everything sys could do! my 0.02 Luis -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 6:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forms - as sysdba One thing to bear in mind for forms development is Oracle does not support connecting as "/" (OPS$). Suhen -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L Subject: Re: Forms - as sysdba As this is Forms 6i, which was around long before "connect '/ as sysdba'" was required, Forms does not know about the new syntax. Try checking on MetaLink for a patch. Jared On Thu, 2003-08-21 at 01:54, Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms - as sysdba
Hi Bruce, this is EXACTLY what I needed, great! Many thanks =RP= Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the upgrade - certainly test it out on a test system first. Regarding the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms - as sysdba
Title: Forms - as sysdba Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich
Forms 3 and 9i
Title: Message Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil.
Re: Forms - as sysdba
As this is Forms 6i, which was around long before connect '/ as sysdba' was required, Forms does not know about the new syntax. Try checking on MetaLink for a patch. Jared On Thu, 2003-08-21 at 01:54, Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms 3 and 9i
No. With 8 and 8i you could create an Oracle 7 home and use that OH to host the version 3 Forms and connect to the 8/8i database. Not too sure this will work with 9i. Jared On Thu, 2003-08-21 at 03:59, Senthil Kumar wrote: MessageHi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms 3 and 9i
Title: Message None, except forms 3 isn't supported for long time now, thus it probably doesn't work. And if it seems to work at first sight, you can't rely on it. You're on your own. Tanel. - Original Message - From: Senthil Kumar To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 1:59 PM Subject: Forms 3 and 9i Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil.
Re: Forms - as sysdba
Title: Forms - as sysdba Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes) But why do you want to connect as sysdba anyway? Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: Forms - as sysdba Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible?Thanks a lot Robert Pipich
Re: Forms - as sysdba
Rather, why do you want to connect as SYS ? If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that user and connect as that new user in Forms. -- and think about migrating the tables out of the SYS schema. If you are querying standard tables, OEM provides good views for most of what you need and the group here can provide better SQL scripts anyway. Hemant At 07:29 AM 21-08-03 -0800, you wrote: Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes) But why do you want to connect as sysdba anyway? Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: Forms - as sysdba Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms 3 and 9i
I was about to say wouldn't work But considering that Oracle Applications 10.7 Character-mode Forms 2.4 works with 8.1.7, yes, why not ? [although 2.4 might actually be a higher version than 3.0 as 2.4 was specifically built for Apps 10.7 and the Y2K upgrades while 3.0 predates Y2K]. Of course, you won't be supported. Hemant At 02:59 AM 21-08-03 -0800, you wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms 3 and 9i
Hi Yes it is posible to use Forms 3.x agenst a version 9.x database. My friend and coworker have implanted it at site on a sun box. The way to do this is to install Forms 3.x ( 7.2.x dist ?) in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH. Set the unix environment var. TWO_TASK to point to a IPC alias to the listener that can connect to the 9.x database. The hard part is to find the Forms 4 patch (xx) it is not possible to order it from Oracle support but I think it as distributed with the 7.3.x Oracle database kit ! Senthil Kumar wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Forms 3 and 9i
.. and be sure to document for the next poor slob that has to act as admin for this mess On Thu, 21 Aug 2003, Peter Gram wrote: Hi Yes it is posible to use Forms 3.x agenst a version 9.x database. My friend and coworker have implanted it at site on a sun box. The way to do this is to install Forms 3.x ( 7.2.x dist ?) in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH. Set the unix environment var. TWO_TASK to point to a IPC alias to the listener that can connect to the 9.x database. The hard part is to find the Forms 4 patch (xx) it is not possible to order it from Oracle support but I think it as distributed with the 7.3.x Oracle database kit ! Senthil Kumar wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smart Aleck DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms 3 and 9i
I think the real answer to the questions is - no, Forms 3 does not work with 9i. You must convert it to Forms 6i. Must put a stop to this stuff at some point. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 21, 2003 2:14 PM To: Multiple recipients of list ORACLE-L .. and be sure to document for the next poor slob that has to act as admin for this mess On Thu, 21 Aug 2003, Peter Gram wrote: Hi Yes it is posible to use Forms 3.x agenst a version 9.x database. My friend and coworker have implanted it at site on a sun box. The way to do this is to install Forms 3.x ( 7.2.x dist ?) in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH. Set the unix environment var. TWO_TASK to point to a IPC alias to the listener that can connect to the 9.x database. The hard part is to find the Forms 4 patch (xx) it is not possible to order it from Oracle support but I think it as distributed with the 7.3.x Oracle database kit ! Senthil Kumar wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smart Aleck DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms - as sysdba
Title: RE: Forms - as sysdba One thing to bear in mind for forms development is Oracle does not support connecting as / (OPS$). Suhen -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L Subject: Re: Forms - as sysdba As this is Forms 6i, which was around long before connect '/ as sysdba' was required, Forms does not know about the new syntax. Try checking on MetaLink for a patch. Jared On Thu, 2003-08-21 at 01:54, Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms - as sysdba
Title: Message I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situationas Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\form.fmx "sys/[EMAIL PROTECTED] "\/'as sysdba'" =RP= -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K ChitaleSent: Thursday, August 21, 2003 5:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Forms - as sysdbaRather, why do you want to connect as SYS ?If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that userand connect as that new user in Forms. -- and think about migrating the tablesout of the SYS schema.If you are querying standard tables, OEM provides good views for most of whatyou need and the group here can provide better SQL scripts anyway.HemantAt 07:29 AM 21-08-03 -0800, you wrote: Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes)But why do you want to connect as sysdba anyway?Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: Forms - as sysdba Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --* www.inMail.sk - Vasa emailova adresa na cely zivot ZDARMA* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32 (www.eset.sk)* www.SlovakNET.sk - profesionalny webhosting, domena .SK ZADARMO* Zoner Media Explorer 5 - stiahnite si pomocnika pre digitalnu fotografiu (zme.zoner.sk)
RE: Forms - as sysdba
Title: Message Robo You can connect as ifrun60.EXE "C:\...\..\logon2.fmx" Regards Suhen -Original Message-From: Robo [mailto:[EMAIL PROTECTED]Sent: Friday, 22 August 2003 4:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forms - as sysdba I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situationas Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\form.fmx "sys/[EMAIL PROTECTED] "\/'as sysdba'" =RP= -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K ChitaleSent: Thursday, August 21, 2003 5:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Forms - as sysdbaRather, why do you want to connect as SYS ?If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that userand connect as that new user in Forms. -- and think about migrating the tablesout of the SYS schema.If you are querying standard tables, OEM provides good views for most of whatyou need and the group here can provide better SQL scripts anyway.HemantAt 07:29 AM 21-08-03 -0800, you wrote: Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes)But why do you want to connect as sysdba anyway?Tanel. - Original Message - From: Robo To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Subject: Forms - as sysdba Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --* www.inMail.sk - Vasa emailova adresa na cely zivot ZDARMA* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32 (www.eset.sk)* www.SlovakNET.sk - profesionalny webhosting, domena .SK ZADARMO* Zoner Media Explorer 5 - stiahnite si pomocnika pre digitalnu fotografiu (zme.zoner.sk)
RE: Run Forms 9i
Thanks for the detailed mail. I am having problems for getting the OHS started. I have started the OracleOraHome HTTPS Server services for Windows. I am unable to find the dcmctl utility. http://ciscow40s0249.cisco-temp.com:1810 Page is displaying error also at port I can see proper server started information. Also, the forms listener is running, but the following link is giving an error, in spite of making changes http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet Once again, thanks in advance for taking so much time out to answer my query. With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Indy Johal Sent: Thursday, July 31, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Run Forms 9i Siddharth Is your Http server running and can check it with http://ciscow40s0249.cisco-temp.com: If you got an error in it then it mean you need to start the OHS by using dcmctl utility or thru OEM which can be invoked by running http://ciscow40s0249.cisco-temp.com:1810 Then check if the OC4J instance is running like the Default one is OC4J_BI_FORMS and the easy way is to use the below two link where First one is to check the Listener Servlet and the second one will check the Default forms and make sure that your ORACLE_HOME\forms90 contain test.fmx and ORACLE_HOME\forms90\server\default.env says FORMS90_PATH=ORACLE_HOME\forms90 http://ciscow40s0249.cisco-temp.com:/forms90/l90servlet http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet -- This will give the page as Forms are installed successfully by running the test.fmx If you got an error then it means your OC4J Instance is down and this again can be started by using dcmctl utility or OEM as in OHS If all is well above then Now you can make the following changes to run your application 1) create a directory named like ORACLE_HOME\forms90\SIDHARTH 2) put all of the your application .fmx and .plx file in the above directory 3) edit ORACLE_HOME\forms90\server\default.env file and make FORMS90_PATH=ORACLE_HOME\forms90\SIDHARTH 4) edit ORACLE_HOME\forms90\server\formsweb.cfg and make the following changes forms=MODULE1.fmx userid=SCOTT/[EMAIL PROTECTED] 5)http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet Hope this will give you some of the setup Idea and make it run or let me know Indy Johal Siddharth Haldankar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/03 04:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Run Forms 9i Hi, Do you have to do any setting to run forms9i, it does not have any forms runtime environment. It runs only in the web server. My forms are giving this link http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet?form=C:\Prog ram%20Files\Common%20Files\System\MAPI\1033\MODULE1.fmxuserid=SCOTT/TIG [EMAIL PROTECTED]buffer_records=NOdebug_messages=YESarray=YESquery_only=NOqu iet=NORENDER=YES but it gives page not displayed. Do we need to set any parameters? Please advice. Thanks in advance. - Siddharth Haldankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Siddharth Haldankar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Run Forms 9i
Hi, Do you have to do any setting to run forms9i, it does not have any forms runtime environment. It runs only in the web server. My forms are giving this link http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet?form=C:\Prog ram%20Files\Common%20Files\System\MAPI\1033\MODULE1.fmxuserid=SCOTT/TIG [EMAIL PROTECTED]buffer_records=NOdebug_messages=YESarray=YESquery_only=NOqu iet=NORENDER=YES but it gives page not displayed. Do we need to set any parameters? Please advice. Thanks in advance. - Siddharth Haldankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Siddharth Haldankar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Run Forms 9i
Siddharth Is your Http server running and can check it with http://ciscow40s0249.cisco-temp.com: If you got an error in it then it mean you need to start the OHS by using dcmctl utility or thru OEM which can be invoked by running http://ciscow40s0249.cisco-temp.com:1810 Then check if the OC4J instance is running like the Default one is OC4J_BI_FORMS and the easy way is to use the below two link where First one is to check the Listener Servlet and the second one will check the Default forms and make sure that your ORACLE_HOME\forms90 contain test.fmx and ORACLE_HOME\forms90\server\default.env says FORMS90_PATH=ORACLE_HOME\forms90 http://ciscow40s0249.cisco-temp.com:/forms90/l90servlet http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet -- This will give the page as Forms are installed successfully by running the test.fmx If you got an error then it means your OC4J Instance is down and this again can be started by using dcmctl utility or OEM as in OHS If all is well above then Now you can make the following changes to run your application 1) create a directory named like ORACLE_HOME\forms90\SIDHARTH 2) put all of the your application .fmx and .plx file in the above directory 3) edit ORACLE_HOME\forms90\server\default.env file and make FORMS90_PATH=ORACLE_HOME\forms90\SIDHARTH 4) edit ORACLE_HOME\forms90\server\formsweb.cfg and make the following changes forms=MODULE1.fmx userid=SCOTT/[EMAIL PROTECTED] 5)http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet Hope this will give you some of the setup Idea and make it run or let me know Indy Johal Siddharth Haldankar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/03 04:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Run Forms 9i Hi, Do you have to do any setting to run forms9i, it does not have any forms runtime environment. It runs only in the web server. My forms are giving this link http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet?form=C:\Prog ram%20Files\Common%20Files\System\MAPI\1033\MODULE1.fmxuserid=SCOTT/TIG [EMAIL PROTECTED]buffer_records=NOdebug_messages=YESarray=YESquery_only=NOqu iet=NORENDER=YES but it gives page not displayed. Do we need to set any parameters? Please advice. Thanks in advance. - Siddharth Haldankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Siddharth Haldankar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Jdeveloper Forms 9 : going to the 3-tier ....
I was reading the available papers ( old messages in the Forum, too) about this topic , and the following issues arise : Jdeveloper : the strong point in Forms always has been the RAD approach : without ** any ** PL/SQL or SQL knowledge, one person can build in minutes a real-working program capable of Insert, Update Delete information in a database table. And the best, automagically this generated program WILL use the best options for performance, like ARRAY PROCESSING , BINDING vars, (in multiline blocks), no REPARSE - the last two are FREE with PL/SQL. So, the questions : the JDev wizard to generate a program IS comparable in the current version of Jdev with the Forms one ? The generated program IS totally ready to use, or no ? And about the performance of the generated program, how smart is the wizard ? The main point here is , Java is a generic (non Oracle-centric) language, SO to receive the same beneficts above cited (array proc, binds, fewer parses) the program MUST be coded according some rules (only prepared statements, no missing open/close, no uppercase/lowercase diffs in SQLs, etc, etc), OR - better option - the Java program must call PL/SQLs packages. Are current JDev doing it ? And about the future, are Jdev people inside Oracle thinking about this practical issues ?? Forms 9: the main question in my haed about it comes from the mig paper, it says : No business logic is executed on the client; it is responsible for rendering the screen. All logic is processed on the application tier. See, commonly application tier intends another machine, so the network traffic between machines MUST increase by a large factor, IMO : in special I think about whn-validate-xx triggers - in C/S apps MANY user-enterable fields responds to/critiques user actions IMMEDIATLY after the user attempts to exit from the field, this behavior is normally DEMANDED by users, in my experience. In this situations, HOW Forms 9 will respond to it ? Forms have ANY kind of optimization to this kind of traffic ? And to current Forms 9 users : in the common-garden Ethernet-100 (no Gigabit) local network, HOW has been the experience ? Too much net perf problems ? Regards, Chiappa __ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: jchiappa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Accessing forms server through proxy server
Hi List, i have set up a oracle forms server on public network, if i am accesing the forms from a PC which on directly connected to internet , am able to open the forms. my problem is if i access the same forms from a PC which is behind the filrewall that time not able to open the forms ,error is 'FRM-29050 failed to connect to server' what can be problem. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
version control for pl/sql dev forms etc.
List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: version control for pl/sql dev forms etc.
Rahul, I believe you have just described Oracle Software Configuration Manager (SCM) for the Oracle Repository. It allows comparison of two forms or reports, also modules, tables, entities etc. It's versioning is at the object level and it's rigorous. Maggie Respectfully, Maggie Tompkins - DCII Integration Technology Services Organization - Kansas City Defense Finance and Accounting Service 816-926-1117 (DSN 465); [EMAIL PROTECTED] Back to the Beach! - ODTUG Conference Loews Miami Beach Hotel, June 22-27 Visit www.odtug.com for details. -Original Message- Sent: Monday, June 16, 2003 2:39 AM To: Multiple recipients of list ORACLE-L List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: TOMPKINS, MARGARET INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: version control for pl/sql dev forms etc.
Title: RE: version control for pl/sql dev forms etc. Oracle SCM 9i Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: rahul sharma [mailto:[EMAIL PROTECTED]] Sent: Monday, June 16, 2003 3:39 AM To: Multiple recipients of list ORACLE-L Subject: version control for pl/sql dev forms etc. List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: version control for pl/sql dev forms etc.
There is another product called EDBA(Enterprise DBA) by Platinum technology currently CA, which does the version control and comparison. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 16, 2003 7:13 AM Rahul, I believe you have just described Oracle Software Configuration Manager (SCM) for the Oracle Repository. It allows comparison of two forms or reports, also modules, tables, entities etc. It's versioning is at the object level and it's rigorous. Maggie Respectfully, Maggie Tompkins - DCII Integration Technology Services Organization - Kansas City Defense Finance and Accounting Service 816-926-1117 (DSN 465); [EMAIL PROTECTED] Back to the Beach! - ODTUG Conference Loews Miami Beach Hotel, June 22-27 Visit www.odtug.com for details. -Original Message- Sent: Monday, June 16, 2003 2:39 AM To: Multiple recipients of list ORACLE-L List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: TOMPKINS, MARGARET INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arun Annamalai INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LOV on Forms 6i to be populated with data from SQL Server 2000 ta
Hi Gurus I have a unusual request from one of new clients. I have an application that is 100% Oracle forms 6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know whether he can populate aLOV onOracle form with data from one of the columns of a table in SQL Server 2000. Is there a way to achieve this with something like database link, dynamic link, etc... Appreciate any help or lead or direction to documentation in regard Thanks in advance Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._ Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
RE: LOV on Forms 6i to be populated with data from SQL Server 200
Funny you should ask as we are in the process of implementing something very similar here. Selecting from SQL Server tables from within an Oracle database that is. It can be done relatively inexpensively (about $4k per cpu for the ODBC driver) You need to look into "Oracle Heterogeneous Services" and install them on theOracle DB Server This requires a 3rd party ODBC driver. We chose theSQL Server Wire Protocol ODBC driverfrom DataDirect. Once you have configured the Hetero Services and the ODBC driver all you do is create a database link! Then you can select form the SQL Server table as if it was a remote Oracle table. (with limits as SQL Server is not as powerful an engine as Oracle) Initial installation took about 1/2 day, including the trial software downloads. Pretty sweet solution for small tables! Kevin -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]Sent: Thursday, May 29, 2003 5:21 PMTo: Multiple recipients of list ORACLE-LSubject: LOV on Forms 6i to be populated with data from SQL Server 2000 ta Hi Gurus I have a unusual request from one of new clients. I have an application that is 100% Oracle forms 6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know whether he can populate aLOV onOracle form with data from one of the columns of a table in SQL Server 2000. Is there a way to achieve this with something like database link, dynamic link, etc... Appreciate any help or lead or direction to documentation in regard Thanks in advance Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._ Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
RE: LOV on Forms 6i to be populated with data from SQL Server 2000 ta
Title: Message use heterogeneous services + odbc/oledb and you could create a synonym for a sqlserver table. no need for any gateway product. -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 2:21 PMTo: Multiple recipients of list ORACLE-LSubject: LOV on Forms 6i to be populated with data from SQL Server 2000 ta Hi Gurus I have a unusual request from one of new clients. I have an application that is 100% Oracle forms 6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know whether he can populate aLOV onOracle form with data from one of the columns of a table in SQL Server 2000. Is there a way to achieve this with something like database link, dynamic link, etc... Appreciate any help or lead or direction to documentation in regard Thanks in advance Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._? Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
[Q] some questions relate to ORACLE 9i Forms !!
Currently we are use ORACLE developer 6i and plan to upgrade to IDS 9i. I heard ORACLE Forms/reports 9i take out client/server support and use Web browser. my question are: 1. On installation for user's PC does their has way ONLY install forms/report run time engine and OC4J? 2. We don't need browser access. The traditional Forms client/server access is OK. Does their has way to do it? 3. Is OC4J require? How much OC4J cost ? 4. IS ORACLE AS 9i require? (remember we don't need browser access) Thanks. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Forms and Reports Services
Does anyone use the Oracle Forms and Reports services to serve Forms and Reports apps through the web? We have a setup running here on a Solaris system and there are quirks (like starting the Reports service under a VNC session) and frequent crashes. I'm wondering whether there are preferred platform choices and configurations for these services which would provide better reliability. Do most site run these services on Windows? We are running the app server and Forms and Reports services on the same machine; could that be part of the problem? Glenn Stauffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Forms 6i - Does not Display
Hi Gurus, Just developed a form using Oracle Forms 6i but the form display very quickly in the Web Browser and disappears. The form however runs very well using Oracle Forms Run Time. I have set the RunTime environment and the HTTP Server is running. What could be the problem? Moses This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
Re: Oracle Forms 6i - Does not Display
If you've developed the form on a Windows client and are running the Forms Server [web forms] on a Unix server, try regenerating the .fmx on the Unix server using f60genm Hemant At 05:08 AM 12-03-03 -0800, you wrote: Hi Gurus, Just developed a form using Oracle Forms 6i but the form display very quickly in the Web Browser and disappears. The form however runs very well using Oracle Forms Run Time. I have set the RunTime environment and the HTTP Server is running. What could be the problem? Moses This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Forms 6i - Does not Display
If you've developed the form on a Windows client and are running the Forms Server [web forms] on a Unix server, try regenerating the .fmx on the Unix server using f60genm Hemant At 05:08 AM 12-03-03 -0800, you wrote: Hi Gurus, Just developed a form using Oracle Forms 6i but the form display very quickly in the Web Browser and disappears. The form however runs very well using Oracle Forms Run Time. I have set the RunTime environment and the HTTP Server is running. What could be the problem? Moses This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Forms Reports Help!
Hi, This could be a very simple question to many of you.. but I would really appreciate if you could help me. I created Forms which call each other. And a Report from the Form. Everything seems to be good. However I am calling the Form through call_form() where I am specifying the entire path of the called form. Is there any way to specify an absolute path (just the name of the called form)?? Similarly... I am running the report with run_product() even here I am specifying the entire path of the Report. Which I don't want to... can I? One more question... How can I automatically view and print the report in pdf format?? This is really urgent! I would really appreciate your help and time. Thanks, Sesi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sesi Odury INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms/Reports on web with Weblogic
Can anyone provide any info on deploying forms/reports application on web using other application servers (specially Weblogic ). servlet or cgi, any implementation. i m unable to find a way to create virtual directory to map with cgi executable file. TIA Shuja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M. Shuja Uddin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Barcode Generation in Forms/Reports
Hi Lists, How to generate/Read/Print Barcode using Oracle Forms/Reports ( Windows / Unix). Please Help. Nitheesh *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Barcode Generation in Forms/Reports
Nitheesh, Please note that bar code is no special thing other than representing characters in bars. You can use a font called bar code font that represents characters as bars. A free version is available to download at www.idautomation.com The barcode device connected to a computer reads the barcode, and writes its equivalent numbers at current cursor position. If you cursor is in a text item in a forms it will display the numbers there, if you cursor is in a text editor like notepad it will write the numbers there. As if it was typed in through a keyboard. Now if you set the font of the field to the barcode font, these characters will be displayed as a barcode. Both forms and reports support barcode font. HTH! Aleem -Original Message- Sent: Thursday, February 06, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Subject:Barcode Generation in Forms/Reports Hi Lists, How to generate/Read/Print Barcode using Oracle Forms/Reports ( Windows / Unix). Please Help. Nitheesh *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Barcode Generation in Forms/Reports
Hi Kumar, In my company I have several report that also print the barcode. I think it isn't big deal if you have font that support the character of barcode. Rgrds, Sony -Original Message- From: Pullikol Kumar [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Barcode Generation in Forms/Reports Hi Lists, How to generate/Read/Print Barcode using Oracle Forms/Reports ( Windows / Unix). Please Help. Nitheesh *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tuning forms/reports application
The application is not extremely slow. Actually, i want to do proactive tuning (instead of reactive). I want to see which application is misusing the database resources and correct that form or report.. Further, I am still unable to find the name of the forms/reports module that's currently executing from any of the database views. Shuja "Jamadagni, Rajendra" wrote: 1. you sure can, but it depends on what you want to tune for ... 2. Usually in my case, I trust my user, if they say form xyz is running slow like a drunk snail, there is a good chance that it is, so I work on that. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: M. Shuja Uddin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: tuning forms/reports application 1. Is there any way we can tune the forms/reports application ? **> you sure can ... but it depends 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja
Re: tuning forms/reports application
i don't see any data in the module/action columns, and ofcourse i don't wanna re-engineer all those forms/ reports... further, i can't see the statistics when i enable that parameters with statistics=YES I have tried it with the forms preferences statistics as well as runtime command line. Shuja Connor McDonald wrote: there is a stats=yes (or similar) parameter which creates a trace file for a form execution which can then be used to check sql performance (the most common cause of 'slow' forms). i haven't checked, but forms by default might pop some things into module/action columns which you could see in v$session and v$sql. if forms is not doing it by default, then its a very good practice to start doing this yourself (see: dbms_application_info) hth connor --- M. Shuja Uddin [EMAIL PROTECTED] wrote: 1. Is there any way we can tune the forms/reports application ? 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M. Shuja Uddin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M. Shuja Uddin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tuning forms/reports application
thanks for your suggestions Raj. FRD is nice thing to work. can you also provide more detail on pl/sql profiler and dbms_support package... Shuja "Jamadagni, Rajendra" wrote: Connor, Forms is dumb ... I mean it doesn't think it is important to use dbms_application info, you have to do it manually. The statistics parameter ... gosh .. never got it to work right against 7x, 8x and 9x ... For my developers, I tell them use use, * FRD (Forms Runtime Diagnostics) if they want to know which built-in is blowing up the form ... FRD also has different options and you can also use trace diagnostics with forms. * PL/SQL Profiler (to see where they spend lot of time writing redundant code) * dbms_support.start_trace for SQL performance problems. So, there are different techniques for different problems. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 6:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: tuning forms/reports application there is a stats=yes (or similar) parameter which creates a trace file for a form execution which can then be used to check sql performance (the most common cause of 'slow' forms). i haven't checked, but forms by default might pop some things into module/action columns which you could see in v$session and v$sql. if forms is not doing it by default, then its a very good practice to start doing this yourself (see: dbms_application_info) hth connor
RE: tuning forms/reports application
About 2), you'll have to use dbms_application_info to set teh name explicity. I had brought this to Formd developmemt'd atten, and I believe they logged an internal enhancement to do this, I have no idea about the status. Raj -Original Message-From: M. Shuja Uddin [mailto:[EMAIL PROTECTED]]Sent: Sunday, February 02, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: tuning forms/reports applicationThe application is not extremely slow. Actually, i want to do proactive tuning (instead of reactive). I want to see which application is misusing the database resources and correct that form or report.. Further, I am still unable to find the name of the forms/reports module that's currently executing from any of the database views. Shuja "Jamadagni, Rajendra" wrote: 1. you sure can, but it depends on what you want to tune for ... 2. Usually in my case, I trust my user, if they say form xyz is running slow like a drunk snail, there is a good chance that it is, so I work on that. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: M. Shuja Uddin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: tuning forms/reports application 1. Is there any way we can tune the forms/reports application ? ** you sure can ... but it depends 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: tuning forms/reports application
Title: RE: tuning forms/reports application Connor, Forms is dumb ... I mean it doesn't think it is important to use dbms_application info, you have to do it manually. The statistics parameter ... gosh .. never got it to work right against 7x, 8x and 9x ... For my developers, I tell them use use, * FRD (Forms Runtime Diagnostics) if they want to know which built-in is blowing up the form ... FRD also has different options and you can also use trace diagnostics with forms. * PL/SQL Profiler (to see where they spend lot of time writing redundant code) * dbms_support.start_trace for SQL performance problems. So, there are different techniques for different problems. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 6:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: tuning forms/reports application there is a stats=yes (or similar) parameter which creates a trace file for a form execution which can then be used to check sql performance (the most common cause of 'slow' forms). i haven't checked, but forms by default might pop some things into module/action columns which you could see in v$session and v$sql. if forms is not doing it by default, then its a very good practice to start doing this yourself (see: dbms_application_info) hth connor This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
tuning forms/reports application
1. Is there any way we can tune the forms/reports application ? 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M. Shuja Uddin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tuning forms/reports application
Title: RE: tuning forms/reports application 1. you sure can, but it depends on what you want to tune for ... 2. Usually in my case, I trust my user, if they say form xyz is running slow like a drunk snail, there is a good chance that it is, so I work on that. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: M. Shuja Uddin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: tuning forms/reports application 1. Is there any way we can tune the forms/reports application ? ** you sure can ... but it depends 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: tuning forms/reports application
there is a stats=yes (or similar) parameter which creates a trace file for a form execution which can then be used to check sql performance (the most common cause of 'slow' forms). i haven't checked, but forms by default might pop some things into module/action columns which you could see in v$session and v$sql. if forms is not doing it by default, then its a very good practice to start doing this yourself (see: dbms_application_info) hth connor --- M. Shuja Uddin [EMAIL PROTECTED] wrote: 1. Is there any way we can tune the forms/reports application ? 2. How can we check which form/report is actually the bottleneck. We have a large no. of forms/reports and almost all are very big/complex. Is there any third party utility to do this ? TIA Shuja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M. Shuja Uddin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Forms,Reports performance problem
Oracle 8.1.6 Win Nt Has anyone experience/heard of performace problems after migrating from forms 5 to forms 6.0.8.15 and from reports 2.5 to 3.0? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms 4.5 : DB 8.1.7.4 and Client 7.3.*
Hello, Unable to connect to FRM-10247 with DB Version 8.1.7.4 and client version 7.3.* Same Forms and Menu work with Oracle 8i client. Another interesting issue.. Same Forms and Menu when connect to Oracle 8.1.7.2 DB with 7.3.* client or 8i client works like a champ. Any help or hint in this regard will be highly appreciated. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is Oracle Forms going away?
Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4? I was in a technical meeting with Retek (a retail application), and they presenter said that. I did not see anything on the metalink site relating to that information. If Forms is going away, what will replace it? Thanks in advance GillianDo you Yahoo!? HotJobs - Search new jobs daily now
Re:Is Oracle Forms going away?
JDeveloper Reply Separator Author: Gillian [EMAIL PROTECTED] Date: 11/6/2002 9:18 AM Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4? I was in a technical meeting with Retek (a retail application), and they presenter said that. I did not see anything on the metalink site relating to that information. If Forms is going away, what will replace it? Thanks in advance Gillian - Do you Yahoo!? HotJobs - Search new jobs daily now PHave anyone heard about Oracle Forms going away with Oracle 9.0.1.4?/P PI was in a technical meeting with Retek (a retail application), and they presenter said that. I did not see anything on the metalink site relating to that information./P PIf Forms is going away, what will replace it?/P PThanks in advance/P PGillian/Ppbrhr size=1Do you Yahoo!?br a href=http://rd.yahoo.com/careers/mailsig/*http://www.hotjobs.com HotJobs/a - Search new jobs daily now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-
I found that query-only applications seemed to run OK against 8.x.x databases, but update applications encountered locking problems because of the expanded rowid. (I think Forms 3.0 stores the rowids within the form and only stores part of the expanded rowid). I don't know how you could possibly run Forms 3.0 update applications against 8.x.x or 9.x.x, but then again I am all converted from Forms 3.0 at this point and don't need to worry about it any more. -Original Message- Sent: Thursday, September 26, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 11]] Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who
RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11
I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11]]
Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11
Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Web forms via PL/SQL
I need to write a pl/sql procedure to produce a form via the pl-sql cartridge. Not a problem- been doing this kinda thing now for a couple of years. Now I need to handle a INPUT TYPE=FILE tag in the form. Anyone know how to process the result via pl/sql or am I going to need to write a cgi script to handle it. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Web forms via PL/SQL
Hi Ron,
In short (as I am hitting the bed)
What I have here is done via 9ias.
It (ias) requiers that you define a document table with some specifick
column (you can add your own ) (look in the documentation)
The script I am sending you requiers some other scripts and access
diffrent kind of tables, but I hope it can give you a hint.
If you need some more details I'll be back tomorrow
reards
Torben
Navn NULL?Type
-
ID NUMBER
NAME NOT NULL VARCHAR2(128)
MIME_TYPE VARCHAR2(128)
DOC_SIZE NUMBER
DAD_CHARSETVARCHAR2(128)
LAST_UPDATED DATE
CONTENT_TYPE VARCHAR2(128)
CONTENTLONG RAW
BLOB_CONTENT BLOB
STATUS VARCHAR2(45)
OWNER VARCHAR2(30)
CUSTOMERID NUMBER
DOC_NAME VARCHAR2(128)
SHORT_DESCRIPTION VARCHAR2(4000)
EMPID NUMBER
DATO DATE
create or replace package MaintainVisitReports is
procedure main;
procedure show(p_customerid number := null);
procedure upload(p_customerid number := null, p_short_description in
varchar2 := null, p_initials in varchar2 := null, file in varchar2 := null);
procedure download(p_name varchar2);
procedure deletefile(p_customerid number := null, p_id number);
procedure filelist ;
end ;
/
create or replace package body MaintainVisitReports is
Procedure main is
begin
ccs.ccs;
htp.p('TABLE');
htp.p('TR');
htp.p('TD');
htp.p('a href=mirres.MaintainVisitReports.show
TARGET=mainUpload/a');
htp.p('/TD');
htp.p('TD');
htp.p('a href=mirres.MaintainVisitReports.filelist
TARGET=mainList/a');
htp.p('/TD');
htp.p('/TR');
htp.p('/TABLE');
htp.p('HR');
end main;
--
-
--
--
-
procedure show(p_customerid number := null)
is
l_custname varchar2(50);
cursor GetCustomer is
select custname from customer where customerid = p_customerid;
begin
open GetCustomer;
fetch Getcustomer into l_custname;
close GetCustomer;
ccs.ccs;
Javascript.script;
javascript.call_popup;
Javascript.end_script;
--
htp.p('html');
htp.p('body');
--
htp.p('FORM enctype=multipart/form-data
action=mirres.MaintainVisitReports.upload method=POST');
if p_customerid is not null then
htp.p('INPUT TYPE=SUBMIT VALUE=Luk style=border-style: solid;
border-width: 1 onClick=window.close()');
end if;
htp.p('TABLE background= border=0 cellPadding=0 cellSpacing=0
style=CURSOR: auto; WIDTH: 100% width=100%');
htp.p('TR');
htp.p('TD class=label
WIDTH=120px'||misc.get_translation('Kunde')||'/TD');
htp.p('TD');
htp.p('INPUT TYPE=TEXT VALUE='||l_custname||' onfocus = blur()
SIZE=50 MAXLENGTH=50');
if p_customerid is null then
htp.p('nbsp;A HREF=javascript:call_popup(1)IMG
SRC=/images/list.gif alt=LIST border=0 align=bottom /Anbsp;a
href=javascript:clearcustomer()IMG SRC=/images/viper.gif
alt=vipe border=0 align=bottom/A/TD');
else
htp.p('TD');
end if;
--
htp.p('INPUT TYPE=HIDDEN NAME=p_customerid
VALUE='||p_customerid||' SIZE=0 MAXLENGTH=32/TD');
htp.p('/TR');
--
htp.p('TR rowspan=100%');
htp.p('TD class=label
WIDTH=70px'||misc.get_translation('Initialer')||'/TD');
htp.p('TD ');
components.initials;
htp.p('/TD');
htp.p('/TR');
--
htp.p('TR');
htp.p('TD class=labelBeskrivelse:/TD');
htp.p('TD');
htp.p('TEXTAREA name=p_short_description style=HEIGHT: 87px; WIDTH:
283px maxlength=512/TEXTAREA');
htp.p('/TD');
htp.p('/TR');
--
htp.p('TR');
htp.p('TD class=label WIDTH=120px'||misc.get_translation('Fil der
skal uploades')||'/TD');
htp.p('TDINPUT type=file name=file style=border-style: solid;
border-width: 1 /TD');
htp.p('/TR');
--
htp.p('TR');
htp.p('TDnbsp;/TD');
htp.p('TDINPUT type=submit value=Upload file
style=border-style: solid; border-width: 1 /TD');
htp.p('/TR');
--
htp.p('/TABLE');
htp.p('/FORM');
if p_customerid is not null then
htp.p('HR');
htp.p('pFiles/p');
htp.p('TABLE background= border=1 cellPadding=0 cellSpacing=0
style=CURSOR: auto; WIDTH: 100% width=100%');
if p_customerid is null then
htp.p('TH ALIGN=leftKunde/TH');
end if;
htp.p('TH ALIGN=leftFilnavn/TH');
htp.p('TH ALIGN=leftBeskrivelse/TH');
htp.p('TH ALIGN=leftOpdateret/TH');
htp.p('TH ALIGN=leftInitialer/TH');
htp.p('TH
RE: Suggestions for a single sign on in Forms and Reports ....
use the concept of single login facility rgds, Ams. -Original Message- Michael Sent: Tuesday, August 20, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Just got back from vacation and have been dragged into a working group on a problem the users find unacceptable on one of our new systems. Has anybody had any experience with Forms / Reports through the 9IAS server such that one can be authenticated using the unix login/password without having to log onto Forms / Reports ? The clients connect to 9IAS through HTTP so there is no Oracle Client software installed above the apps. server and I would like to keep it this way. FYI ... I know how to do this off of a SQLPLUS command and that is not what I am looking for here. Thank You much for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Suggestions for a single sign on in Forms and Reports ....
Just got back from vacation and have been dragged into a working group on a problem the users find unacceptable on one of our new systems. Has anybody had any experience with Forms / Reports through the 9IAS server such that one can be authenticated using the unix login/password without having to log onto Forms / Reports ? The clients connect to 9IAS through HTTP so there is no Oracle Client software installed above the apps. server and I would like to keep it this way. FYI ... I know how to do this off of a SQLPLUS command and that is not what I am looking for here. Thank You much for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difficulty compiling forms ported from NT to UNIX
Title: RE: Difficulty compiling forms ported from NT to UNIX We did this recently and for the same reason! We have around a thousand forms which were referring to the libraries in different cases, thus failing on the Unix system. We generated FMTs in batch, changed the cases appropriately, and reconverted to FMB. We have tested it out and we have not encountered any errors as such. Yes you need to be cautious in what you are trying to update in the FMT. What kind of errors are you coming across? rgds amar http://amzone.netfirms.com -Original Message- From: Cohen, Erik [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Subject: Difficulty compiling forms ported from NT to UNIX Please forgive the post (and cross-post) to DBA forums, but due to firewall upgrades, I am no longer able to access the newsgroups. If anyone has had similar experiences to the one described below, I would appreciate any guidance in finding a utility work-around. TIA. Designer generated Forms (FMBs) are moved to UNIX platform along with the attached libraries (llbs). FMBs are not compiling successfully on UNIX. (Note: They all work fine on windows platform). This is to serve the Designer generated Forms using Forms Server 6i installed on UNIX. The UNIX machine is Compaq Alpha Server running Compaq Tru64 UNIX V5.1A (Rev. 1885). The Developer software on UNIX is Developer 6i patchset 10. One of the attached library OFGTEL.llb is referencing OFGMES.llb in an Initcap case format. After making OFGMES.llb to Ofgmes.llb, OFGTEL.llb compiled alright. At this point all attached libraries are moved to UNIX and compiled successfully. But, the FMB is not compiling successfully as it is not attaching the libraries properly no matter what case we use for libraries and its compiled versions. All upper case and all lower case filenames did not work. We noticed that an error message did refre to the refreenced filename as Initcap format, so we changed all attached filename to Initcap format. Then we have to convert .fmb file to .fmt and edit it to convert external filename references to Initcap. Then convert the fmt back to .fmb format. This version of .fmb compiled successfully with all attached library files being Initcap. Editing Designer generated .fmb by converting to .fmt (text format) is tedious and error prone. We are trying to find if Oracle has a patch/utility for this bug. Has anyone had a similar experience? Erik Cohen SAIC Falls Church, VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cohen, Erik INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FORMS - text_io - dynamic formating
Csv is a text file. The attributes that you ask for are implemented in the tool that reads and display the data. You can research this tool and add the necessary tags/format chars so the tool will display the results as you want them. I once used this method to format a report from a clipper (once upon a time) application that inserted control characters into the output stream. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 7:38 PM Hi I have used Text_io to export a datablock to csv, is there a way i can automatically set the text once in csv to Bold, or even change the colour? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Difficulty compiling forms ported from NT to UNIX
Please forgive the post (and cross-post) to DBA forums, but due to firewall upgrades, I am no longer able to access the newsgroups. If anyone has had similar experiences to the one described below, I would appreciate any guidance in finding a utility work-around. TIA. Designer generated Forms (FMBs) are moved to UNIX platform along with the attached libraries (llbs). FMBs are not compiling successfully on UNIX. (Note: They all work fine on windows platform). This is to serve the Designer generated Forms using Forms Server 6i installed on UNIX. The UNIX machine is Compaq Alpha Server running Compaq Tru64 UNIX V5.1A (Rev. 1885). The Developer software on UNIX is Developer 6i patchset 10. One of the attached library OFGTEL.llb is referencing OFGMES.llb in an Initcap case format. After making OFGMES.llb to Ofgmes.llb, OFGTEL.llb compiled alright. At this point all attached libraries are moved to UNIX and compiled successfully. But, the FMB is not compiling successfully as it is not attaching the libraries properly no matter what case we use for libraries and its compiled versions. All upper case and all lower case filenames did not work. We noticed that an error message did refre to the refreenced filename as Initcap format, so we changed all attached filename to Initcap format. Then we have to convert .fmb file to .fmt and edit it to convert external filename references to Initcap. Then convert the fmt back to .fmb format. This version of .fmb compiled successfully with all attached library files being Initcap. Editing Designer generated .fmb by converting to .fmt (text format) is tedious and error prone. We are trying to find if Oracle has a patch/utility for this bug. Has anyone had a similar experience? Erik Cohen SAIC Falls Church, VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cohen, Erik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difficulty compiling forms ported from NT to UNIX
Yes, I've had a similar experience implementing OAS. Move from NT to Solaris. I did it all by hand. No utilities that I'm aware of to correct it. Have you checked MetaLink? Jared Cohen, Erik [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/02/2002 09:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Difficulty compiling forms ported from NT to UNIX Please forgive the post (and cross-post) to DBA forums, but due to firewall upgrades, I am no longer able to access the newsgroups. If anyone has had similar experiences to the one described below, I would appreciate any guidance in finding a utility work-around. TIA. Designer generated Forms (FMBs) are moved to UNIX platform along with the attached libraries (llbs). FMBs are not compiling successfully on UNIX. (Note: They all work fine on windows platform). This is to serve the Designer generated Forms using Forms Server 6i installed on UNIX. The UNIX machine is Compaq Alpha Server running Compaq Tru64 UNIX V5.1A (Rev. 1885). The Developer software on UNIX is Developer 6i patchset 10. One of the attached library OFGTEL.llb is referencing OFGMES.llb in an Initcap case format. After making OFGMES.llb to Ofgmes.llb, OFGTEL.llb compiled alright. At this point all attached libraries are moved to UNIX and compiled successfully. But, the FMB is not compiling successfully as it is not attaching the libraries properly no matter what case we use for libraries and its compiled versions. All upper case and all lower case filenames did not work. We noticed that an error message did refre to the refreenced filename as Initcap format, so we changed all attached filename to Initcap format. Then we have to convert .fmb file to .fmt and edit it to convert external filename references to Initcap. Then convert the fmt back to .fmb format. This version of .fmb compiled successfully with all attached library files being Initcap. Editing Designer generated .fmb by converting to .fmt (text format) is tedious and error prone. We are trying to find if Oracle has a patch/utility for this bug. Has anyone had a similar experience? Erik Cohen SAIC Falls Church, VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cohen, Erik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FORMS - text_io - dynamic formating
Hi I have used Text_io to export a datablock to csv, is there a way i can automatically set the text once in csv to Bold, or even change the colour? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FORMS - text_io - dynamic formating
Don't the text_io procs work with just plain text files? I wouldn't think those would support persistant formatting per se. But maybe you could write html tags inline w/your data values apply formatting that way (tho there's likely some other built-in more tailored to spitting out html and/or xml). hth, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, August 01, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Hi I have used Text_io to export a datablock to csv, is there a way i can automatically set the text once in csv to Bold, or even change the colour? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Converting Forms 4.5 Apps to 3-Tier apps
Hi all, There is some information which i want regarding Converting Forms 4.5 Apps to 3-Tier apps. The application is running on Forms version 4.5 and Reports Version 2.5, and the client wants it to be converted into a 3-tier architecture. I have a few queries regarding that: 1. What is the best architecture to do it? HTML - J2EE-Oracle D/b or Using Form 6i(Using JInitiator) Or Forms 9i? 2. Is Forms 6i, or Forms 9i a true 3-tier architecture like HTML-J2EE-Oracle D/b? 3. While converting to Forms 6i or 9i how much is the magnitude of change and coding required? Any sugegstions, information and pointer will be highly appreciated. Regards, Naveen Nahata Associate - IS MindTree Consulting Pvt. Ltd. No. 42, 27th Cross, 2nd Stage, Banashankari Bangalore - 560 070 Ph. 6711777 extn. 1614 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deploy forms on web
Here's an excerpt from the documentation: When deploying a Forms application on the Web, the icon files in ICO format specified for an iconic button, a menu, or a window) are not used. The only file formats accessible through the Web are GIF or JPG files (GIF is the default format). By default, the icons are found relative to the DocumentBase Directory, which is the directory containing the HTML file. If you want to store your icons in another location, you have to create an application file to specify the virtual directory where the icon files reside and the file format they use (GIF or JPG). This application file must be referenced in the HTML file. Make sure that the .ico extension is not used in your fmb file. Then the correction extension will be used by the forms server when your form is on the web. Just convert your icon files or get new images and store then in the correct directory and it will work automatically. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 12:08 AM So i dont have to do anything with my original .fmb compiled in .fmx for icon, but how does forms server would know that where am diplaying connect icon on .fmx file will be converted into connect.gif while displaying the same .fmx in browser.actulay i have setup everything from my side like ,change in forms60web.cfg ,registry file,vitrual directory for icons, but still waiting for a luck .. -Original Message- Sent: Tuesday, July 30, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Also be sure you have gif files set up. You can't display icon files in the browser so you must convert any icons to gif files and store them in the appropriate directory. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 5:05 PM icons not appearing is most commonly caused by the various env setting FORMS60_... not mapping correctly to the virtual directories defined on the web server hth connor --- Arvind Kumar [EMAIL PROTECTED] wrote: DearAll i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http
Re: deploy forms on web
trying again... --- Forwarded message follows --- - begin returned message - http://www.odtug.com/web_members/mbrsonly_signup.asp S*u*b*s*c*r*i*b*e to the developers list, they have recently dealt with the problem, see the archives. It is a limitation of Developer. On 28 Jul 2002 at 20:43, Arvind Kumar wrote: i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. - end returned message - --- End of forwarded message --- Start at: http://www.odtug.com/index.asp click on Become a FREE ODTUG Web Member today... Enter your emali address, etc. and wait for the confirmation email that contains a password that you can then enter at the ODTUG web site to get access to the email list subscription screen. (or you can manually subscribe, see below). If you become a paying member of ODTUG, you can search the email list archives. Mailing Lists ODTUG is pleased to host nine mailing lists to keep you informed. ODTUG-L for general ODTUG questions, discussions, and administrative notices ODTUG-WAREHOUSE-L for data warehousing and OLAP-related topics ODTUG-METHODS-L for methodology and process topics ODTUG-DES2K-L for Oracle Designer topics *** *** ODTUG-DEV2K-L for Oracle Developer topics *** ODTUG-DISC2K-L for Oracle Discoverer topics ODTUG-JAVA-L for JDeveloper, JDBC, and Java-related topics ODTUG-SQLPLUS-L for SQL*Plus, PL/SQL, and general SQLtopics ODTUG-WEBDEV-L WSG, OAS, OWAS, WebDB, and other Web-related topics To subscribe to any of these lists, please fill out the subscription form below. To subscribe to the mailing lists on your own, send an e-mail message to: [EMAIL PROTECTED] And in the message BODY (not Subject line), put: SUBSCRIBE mailing list real name Have mailing list be the name of the list you want to receive, and real name be your full given name, not your e-mail address. Omit the angle brackets when sending your message. More than one SUBSCRIBE command can be put in the same message, but they must each be on a separate line. For example: SUBSCRIBE ODTUG-L John Doe To remove yourself from a list, use the UNSUBSCRIBE command (with the same parameters as above). You may also include the HELP command for a list of how to use the mailing list server software to change your subscription, check status, obtain archives, read digests, and more. If you would like to subscribe or unsubscribe to one of our current mailing lists, just fill out the form below. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deploy forms on web
icons not appearing is most commonly caused by the various env setting FORMS60_... not mapping correctly to the virtual directories defined on the web server hth connor --- Arvind Kumar [EMAIL PROTECTED] wrote: DearAll i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deploy forms on web
Also be sure you have gif files set up. You can't display icon files in the browser so you must convert any icons to gif files and store them in the appropriate directory. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 5:05 PM icons not appearing is most commonly caused by the various env setting FORMS60_... not mapping correctly to the virtual directories defined on the web server hth connor --- Arvind Kumar [EMAIL PROTECTED] wrote: DearAll i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deploy forms on web
So i dont have to do anything with my original .fmb compiled in .fmx for icon, but how does forms server would know that where am diplaying connect icon on .fmx file will be converted into connect.gif while displaying the same .fmx in browser.actulay i have setup everything from my side like ,change in forms60web.cfg ,registry file,vitrual directory for icons, but still waiting for a luck .. -Original Message- Sent: Tuesday, July 30, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Also be sure you have gif files set up. You can't display icon files in the browser so you must convert any icons to gif files and store them in the appropriate directory. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 5:05 PM icons not appearing is most commonly caused by the various env setting FORMS60_... not mapping correctly to the virtual directories defined on the web server hth connor --- Arvind Kumar [EMAIL PROTECTED] wrote: DearAll i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deploy forms on web
DearAll i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deploying forms reports on web problem
Dear All, i want to deploy my application (forms reports) on web, for this i have instlled forms and reporst server 6.0. i can see the forms in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT (?) -- UNC, NetBIOS, mapped drives and Apache / iAS forms serv er
This is OT I suppose, but I would like to see if there are any comments re. this. For Apache I believe the account used to map the drive must be the same used to create the share at the other end. This is important if you have aliases that point to remote locations. For iAS forms server, I never managed to make it recognize mapped drive on our NT machines here regardless of which account the NT Forms Server service is configured to run as. In the end I had to use a process launched from a batch file. Even that doesn't work when launched as a job, it has to be launched interactively from the desktop. We are gradually moving to servlets to get rid of the Forms server altogether... Mapped drives, UNC names, NetBIOS must be an old part of the win32 platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deploying forms reports on web problem
Dear All, i want to deploy my application (forms reports) on web, for this i have instlled forms and reporst server 6.0. i can see the forms in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Fwd) ORACLE HAS ONCE AGAIN ROYALLY F*ED UP / Re: Looking for Forms 5
Assuming that you can somehow find the patch number (which is the same as the directory name), this is the new patch download facility: ftp updates.oracle.com cd 1647241 binary get p1647241_210_WINNT.zip ---log file--- 230- 230- Welcome to the Oracle Patch Download FTP Server 230- 230- Access 230- -- 230- Access to this system is limited to authorized users of Oracle 230- Metalink. Unauthorized access to or use of this system is prohibited 230- and may subject you to civil and criminal prosecution. Use of this 230- system may be monitored for the purpose of maintaining system 230- security, and system information may be accessed or disclosed under 230- limited circumstances. 230- 230- All transmissions of Oracle software, documentation, source code, 230- technical data or technology must comply with Oracle's Export 230- Compliance Corporate Policy. For more information, refer to Oracle's 230- Internal Export Control Compliance Manual or contact your division's 230- Export Control Officer. 230- 230- Usage 230- - 230- To download a patch, you must know the patch number. At any time you 230- can cd patch number and then ls to find a listing of patches 230- with that number. Enter quote site help to get this welcome banner 230- and additional helpful instructions. 230- 230- Caveats 230- --- 230- - You may not list files or directories from the root directory. 230- - You must select binary transfers for this service to work. 230 ftp --- dir PORT 192,168,0,2,13,85 200 PORT command OK. --- LIST 150 Opening data connection for file listing. total 1 226-Listing complete. Data connection has been closed. 226-It is the policy of this server to deny all 226-requests to list from the root directory. 226-Only diretories with names which match 226 bug numbers exist and there are too many to be listed. ftp: 9 bytes received in 0.00Seconds 9000.00Kbytes/sec. ftp --- quit QUIT 221 Goodbye. Service closing connection. ---end log file--- --- Forwarded message follows --- Looking for Forms 5 patches To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Go into Metalink and click on the Patches button on the left: Notice: All critical patches have been moved to this new advanced Patch Download screen. As of June 17, 2002, the old patch download area has been decommissioned. Patch Download Screen, Decommission Information --- http://metalink.oracle.com/metalink/plsql/ml2_documents.showNO T?p_id=199805.1 excerpt: As of June 17, 2002, this portion of the MetaLink patch download area has been decommissioned. For your convenience, all critical patches have been moved from this area to the main patch download area. You can access the main patch download area by clicking on the Patches button in the MetaLink navigation menu. In the unlikely event that you are unable to retrieve a critical patch, please create a Metalink iTar, with details of the required patch, for Oracle Support to resolve. Do not use the MetaLink feedback button to request a patch, as this will only delay the resolution. Thank you! The MetaLink team. --- View the latest Applications Release 11i Packs ( http://ap103aru.us.oracle.com/quicklinks/apps.html ), the latest Oracle Server / Tools Patchsets ( http://ap103aru.us.oracle.com/quicklinks/server.html ), or enter your selection criteria below. Patch Download To view a list of available patches, select a product and platform combination from the drop-down lists. Patch Number: Product Family: select a product family ... Limit Search to: select an entry ... Includes File: ... Order by: Release date Patch Number Copyright (c) 1995, 2001 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. Of course the profoundly sick b*stards that designed the convoluted select criteria list made it impossible to find something simple like a list of patches for forms 5, you have to rummage around amongst various options/suboptions for Developer, Developer Suite, etc. Another victim of Oracle's byzantine product naming/numbering scheme. Note that a simple search for forms 5 patch returned a vast number of entries that do not appear to be relevant. CAN SOMEBODY PLEASE TELL THE DECISION MAKERS AT ORACLE THAT METALINK SUCKS?!?! Moving right along, I look in Top Tech Docs. Internet Developer Tools seems the closest approximation??? (of course forms 5 may, or may not, be used for Internet, but nevermind.) Ah yes, click Oracle Forms. Under Patches, there is almost nothing useful!!! AMAZING! CAN SOMEBODY PLEASE TELL THE DECISION MAKERS AT ORACLE THAT METALINK SUCKS?!?! Ah, but in 64630.1, there is a link to 74145.1 (Developer Version Number Matrix). hm... : Forms 5.0.5 = Developer 2.0 Forms 5.0.6 = Developer 2.1 So
Forms Question
Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms Question
It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms Question
I'm running 6, how would I go about it? -Original Message- Sent: Thursday, June 27, 2002 12:29 PM To: Multiple recipients of list ORACLE-L It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database 9iR2 and client-server with Forms 6i / RE: (Fwd) Re:
interesting. do you have any explanation of why oracle says that database 91 R2 (9.2.x) *doesn't* support client-server? am I missing something? (i haven't read the database 9iR2 3-tier architecture docs extensively, assuming that it would be a waste of time for the environment i work in.) have you run afoul of oracle tech support with that configuration? what were the problems with your package specifications? regards, ep On 24 Jun 2002 at 12:18, Shaw John-P55297 wrote: you only need 9ias if you are running webforms and then you only need 9ias if you are running in servlet mode. I found that Client server works fine. THere were problems with our package specifications, but once I corrected them it seemed to work. -Original Message- Sent: Monday, June 24, 2002 11:34 AM To: Multiple recipients of list ORACLE-L My understanding is that the developer mode is still client-server, but to do the deployment (more or less runtime?), you have to also have 9iAS set up and running. Can you execute a form in client-server mode in the same manner as a user would (in other words, not in developer mode)? Thanks, Eric On 24 Jun 2002 at 6:08, Shaw John-P55297 wrote: Date sent:Mon, 24 Jun 2002 06:08:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell -Original Message- Sent: Friday, June 21, 2002 12:07 PM To: Multiple recipients of list ORACLE-L in pure client-server mode? if so: quick, someone tell oracle tech support !!! :) what versions of the database? personal, standard, enterprise, etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent: Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] I have 9iR2 and forms 6i on my pc and its running ok so far. -Original Message- Sent: Friday, June 21, 2002 5:08 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7
9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell -Original Message- Sent: Friday, June 21, 2002 12:07 PM To: Multiple recipients of list ORACLE-L in pure client-server mode? if so: quick, someone tell oracle tech support !!! :) what versions of the database? personal, standard, enterprise, etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent: Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] I have 9iR2 and forms 6i on my pc and its running ok so far. -Original Message- Sent: Friday, June 21, 2002 5:08 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
database 9iR2 and client-server with Forms 6i / RE: (Fwd) Re:
My understanding is that the developer mode is still client-server, but to do the deployment (more or less runtime?), you have to also have 9iAS set up and running. Can you execute a form in client-server mode in the same manner as a user would (in other words, not in developer mode)? Thanks, Eric On 24 Jun 2002 at 6:08, Shaw John-P55297 wrote: Date sent: Mon, 24 Jun 2002 06:08:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell -Original Message- Sent: Friday, June 21, 2002 12:07 PM To: Multiple recipients of list ORACLE-L in pure client-server mode? if so: quick, someone tell oracle tech support !!! :) what versions of the database? personal, standard, enterprise, etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent:Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to:[EMAIL PROTECTED] I have 9iR2 and forms 6i on my pc and its running ok so far. -Original Message- Sent: Friday, June 21, 2002 5:08 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
client-server on database 9x (update)/ Re: Upgrading from Forms 5, Oracle 7
--- Forwarded message follows --- re: client-server support on database 9.x Looks like database 9.0.1.x will probably die (without *any* EAS) a lot sooner than 8.1.7. since there is no evidence at this time that database 9.2.x, or later, will ever support client-server, database 8.1.7 looks like the better choice for longevity reasons. regards, ep additional background: ---excerpt--- Linked from search results for 190435.1 Oracle Server (RDBMS) Releases Support Status Summary Information here was last updated on 10-June-2002 ... Oracle Server Releases Status Summary ... Release: 9.0.1.X Current Patch Set 9.0.1.3 Next Patch Set : Late 2002 Error Correction Support Ends ***Probably 30-June-2003** Error Correction Support Ends ***No EMS*** ... http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=148054. 1 ... Product Version(s): 8.1.7 (8i) Platform(s): Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-DEC-2003 Extended Assistance Support (EAS): 31-DEC-2006 Extended Maintenance Support (EMS): 31-DEC-2005 ... EAS will be provided until 31-DEC-2006, if the customer has a current support contract in place. ... Exceptions and/or Miscellaneous Information: Extended Maintenance Support (EMS) will be offered on the following platforms ONLY until 31-DEC-2005: ... Microsoft Windows 2000 ... ---end--- ---excerpt from TAR--- New info : ~ Apparently I neglected to also ask how long database 9.0.1 will be supported? ~ Here is the only information I found, which is not definitive: ~ ~ ~(Enterprise database server) ~ ~ | Desupport Information: ~ | ~ | The lifecycle policy for all Oracle Server releases, where ~ | lifecycle is defined as the length of support by development, ~ | is 21 months for all non-terminal releases and 27 months for ~ | all terminal releases. All desupport dates adhere to this ~ | policy. These dates [***]may move out[***], however, based ~ | on business need, product interdependencies, etc. ~ ~ Oracle database versions 8.1.7 and 9.0.1 have start dates of FEB- 2002. ~ Are you aware of any official statement indicating that there will be a database version (9.0.1, or its replacement?) that supports client- server and developer 6i stuff through the 2006-2008 time frame? ~ Thanks for your patience, Eric 24-JUN-02 15:16:05 GMT Hi Eric, UPDATE TO CUSTOMER: For latest information about database desupport kindly refer the Note#190435.1. Till now there is no official statement indicating replacement for database 9.0.x that supports client-server. ... 24-JUN-02 15:16:24 GMT Email Update button has been pressed -- Sending email. ---end--- On 20 Jun 2002 at 18:43, Eric D. Pierce wrote: ... Would like to go to Oracle 9 on the database if possible. According to OWS, you can run Forms6i (etc.) against database 9.0.x *IN CLIENT SERVER MODE*. ... Apparently Forms 6 latest patch is certified against some Oracle 9s but not the most recent. True? Yes, as stated above, according to OWS you can run client-server against database 9.0.x fyi, according to Metalink lifecycle (or whatever they call it now) the lifecycle of database 9.0.1, which btw started almost the same day as database 8.1.7, would extend from FEB-2002 for either 21 or 27 months. So, the death of databases 9.0.1 and 8.1.7 would be somewhere around DEC-2003, possibly as late as MAY-2004 if they are considered terminal releases. ---excerpt from metalink--- (Enterprise database server) | Desupport Information: | | The lifecycle policy for all Oracle Server releases, where | lifecycle is defined as the length of support by development, | is 21 months for all non-terminal releases and 27 months for | all terminal releases. All desupport dates adhere to this policy. | These dates [***]may move out[***], however, based on business | need, product interdependencies, etc. ---end--- Note that the above dates are well short of the announced death of Forms6i (and presumably other developer 6i stuff) which was 2006 (2008 with extended assistance support, or whatever they call it now). That obviously makes one wonder how one could continue using Forms 6i in client-server mode until 2006 or 2008 unless some database version other than 8.1.7 or 9.0.1 will have client-server support, or unless the desupport dates of either DEC-2003 or MAY-2004 are moved out. Here is the latest word from OWS: | Q) How long will I be able to run developer | (forms/reports/etc) 6i products (or their | replacement products) in client-server mode | against database 9.0.x, or database 9.x ? | | A) Developer 6i products supports Client-Server | mode. Developer 6i is supported until 2006 and | extended support is until 2008. Till 2008 all | developer 6i products which are certified against
Forms 4.5, views and instead-of triggers
Hi, We're using Forms 4.5 against an 8.1.7.1.4 database. The database is on NT4 and clients are on NT4, W2K XP. 1 of the forms is based on a view which joins 2 tables (by an equi-join on 2 fields) and has an instead-of trigger in place. If I update a field in that view from SQLPlus, a lock gets taken out on both of the base tables - as I would expect. When a record is modified in a Form based on that view, a lock initially only gets taken out on 1 table - the lock is always on the same table and sometimes not even on the table the field being modified is from. The problem is this allows another form to change the same record and we can end up with changes get overwritten by other users. I'm not a Forms developer but am hoping someone else may have a suggestion on how to get the form to put locks on both tables or whatever other suggestions come forth. I can then pass these onto our Developer. Also, is anyone else using Forms 4.5 with Instead-of triggers? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Fwd) Re: Upgrading from Forms 5, Oracle 7
--- Forwarded message follows --- ... Going back to the original question because now I'm really confused. I know the feeling. Everything is looking good in test with Forms 6i, Oracle 8i. sounds good. Would like to go to Oracle 9 on the database if possible. According to OWS, you can run Forms6i (etc.) against database 9.0.x *IN CLIENT SERVER MODE*. What I found out is that Forms6i (etc.) does *not* run against database 9.2.x (in *any* mode). If you get the secret instructions (see my TAR from hell posts), you can actually find the certification info for all the developer 6i components (Forms6i, plus others) in the dark maze of Metlink's certification matrix thingy. I'll try to get all that together in one place and post it (since my repeated requests to OWS to do so were apparently futile). The key is that the server versions mentioned under Application Tier Certifications are actually the *database* server versions, not the *iAS* server versions. (what the hell, I'll cut and paste the secret instructions: | Go to Metalink --- Certify Availability | --- View Certification by product | --- Development Tools |--- Oracle Forms 6i | (or others) | --- Microsoft Windows 2000, | | check the combinations for 9.0.x certifications. ) OAS is not an option at today's prices, so we know Developer 9i is out. certainly. fyi: we get almost all Oracle software free (huge 25 campus site license), but the cost of setting up an additional server for 9iAS is by itself (hardware/OS/maintenance/etc.) a major disincentive (given the current context of things here). Apparently Forms 6 latest patch is certified against some Oracle 9s but not the most recent. True? Yes, as stated above, according to OWS you can run client-server against database 9.0.x fyi, according to Metalink lifecycle (or whatever they call it now) the lifecycle of database 9.0.1, which btw started almost the same day as database 8.1.7, would extend from FEB-2002 for either 21 or 27 months. So, the death of databases 9.0.1 and 8.1.7 would be somewhere around DEC-2003, possibly as late as MAY-2004 if they are considered terminal releases. ---excerpt from metalink--- (Enterprise database server) | Desupport Information: | | The lifecycle policy for all Oracle Server releases, where | lifecycle is defined as the length of support by development, | is 21 months for all non-terminal releases and 27 months for | all terminal releases. All desupport dates adhere to this policy. | These dates [***]may move out[***], however, based on business | need, product interdependencies, etc. ---end--- Note that the above dates are well short of the announced death of Forms6i (and presumably other developer 6i stuff) which was 2006 (2008 with extended assistance support, or whatever they call it now). That obviously makes one wonder how one could continue using Forms 6i in client-server mode until 2006 or 2008 unless some database version other than 8.1.7 or 9.0.1 will have client-server support, or unless the desupport dates of either DEC-2003 or MAY-2004 are moved out. Here is the latest word from OWS: | Q) How long will I be able to run developer | (forms/reports/etc) 6i products (or their | replacement products) in client-server mode | against database 9.0.x, or database 9.x ? | | A) Developer 6i products supports Client-Server | mode. Developer 6i is supported until 2006 and | extended support is until 2008. Till 2008 all | developer 6i products which are certified against | database 9.0.x is supported. That's it! No *specific* mention of how long the database 9.0.1 will be supported! (stay tuned for the final exciting conclusion coming in the next episode of our show.) note, just found on metalink: | Upcoming Oracle Product Desupports | | PLEASE NOTE: This file contains details for upcoming Oracle Product | desupports, with an end of Error Correction Support (ECS) date (13) months | ONLY. ((13) months is the minimum notification period for customers, which | includes the required (12) months notification period plus (1) month of | Obsolescence processing.) NOTE: The information in this file is subject to | change without notice and is not considered a formal desupport announcement | until the required process and approval is received and a formal desupport | notice is generated. Customers may also view this file via MetaLink under | Product Lifecycle == Certifications == 1. View Certifications by | Product == Desupport Advisories and Notices == | | Upcoming Oracle Product Desupports or by searching for Doc ID: 190435.1. | | Product Product Version(s) Platform(s): *Oracle Server 9.2.0.1 | Platform Version(s): ALL Platforms | End of ECS Date : 30-SEP-2005 | End of EAS Date : 30-SEP-2008 | End
RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7
I have 9iR2 and forms 6i on my pc and its running ok so far. -Original Message- Sent: Friday, June 21, 2002 5:08 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- ... Going back to the original question because now I'm really confused. I know the feeling. Everything is looking good in test with Forms 6i, Oracle 8i. sounds good. Would like to go to Oracle 9 on the database if possible. According to OWS, you can run Forms6i (etc.) against database 9.0.x *IN CLIENT SERVER MODE*. What I found out is that Forms6i (etc.) does *not* run against database 9.2.x (in *any* mode). If you get the secret instructions (see my TAR from hell posts), you can actually find the certification info for all the developer 6i components (Forms6i, plus others) in the dark maze of Metlink's certification matrix thingy. I'll try to get all that together in one place and post it (since my repeated requests to OWS to do so were apparently futile). The key is that the server versions mentioned under Application Tier Certifications are actually the *database* server versions, not the *iAS* server versions. (what the hell, I'll cut and paste the secret instructions: | Go to Metalink --- Certify Availability | --- View Certification by product | --- Development Tools |--- Oracle Forms 6i | (or others) | --- Microsoft Windows 2000, | | check the combinations for 9.0.x certifications. ) OAS is not an option at today's prices, so we know Developer 9i is out. certainly. fyi: we get almost all Oracle software free (huge 25 campus site license), but the cost of setting up an additional server for 9iAS is by itself (hardware/OS/maintenance/etc.) a major disincentive (given the current context of things here). Apparently Forms 6 latest patch is certified against some Oracle 9s but not the most recent. True? Yes, as stated above, according to OWS you can run client-server against database 9.0.x fyi, according to Metalink lifecycle (or whatever they call it now) the lifecycle of database 9.0.1, which btw started almost the same day as database 8.1.7, would extend from FEB-2002 for either 21 or 27 months. So, the death of databases 9.0.1 and 8.1.7 would be somewhere around DEC-2003, possibly as late as MAY-2004 if they are considered terminal releases. ---excerpt from metalink--- (Enterprise database server) | Desupport Information: | | The lifecycle policy for all Oracle Server releases, where | lifecycle is defined as the length of support by development, | is 21 months for all non-terminal releases and 27 months for | all terminal releases. All desupport dates adhere to this policy. | These dates [***]may move out[***], however, based on business | need, product interdependencies, etc. ---end--- Note that the above dates are well short of the announced death of Forms6i (and presumably other developer 6i stuff) which was 2006 (2008 with extended assistance support, or whatever they call it now). That obviously makes one wonder how one could continue using Forms 6i in client-server mode until 2006 or 2008 unless some database version other than 8.1.7 or 9.0.1 will have client-server support, or unless the desupport dates of either DEC-2003 or MAY-2004 are moved out. Here is the latest word from OWS: | Q) How long will I be able to run developer | (forms/reports/etc) 6i products (or their | replacement products) in client-server mode | against database 9.0.x, or database 9.x ? | | A) Developer 6i products supports Client-Server | mode. Developer 6i is supported until 2006 and | extended support is until 2008. Till 2008 all | developer 6i products which are certified against | database 9.0.x is supported. That's it! No *specific* mention of how long the database 9.0.1 will be supported! (stay tuned for the final exciting conclusion coming in the next episode of our show.) note, just found on metalink: | Upcoming Oracle Product Desupports | | PLEASE NOTE: This file contains details for upcoming Oracle Product | desupports, with an end of Error Correction Support (ECS) date (13) months | ONLY. ((13) months is the minimum notification period for customers, which | includes the required (12) months notification period plus (1) month of | Obsolescence processing.) NOTE: The information in this file is subject to | change without notice and is not considered a formal desupport announcement | until the required process and approval is received and a formal desupport | notice is generated. Customers may also view this file via MetaLink under | Product Lifecycle == Certifications == 1. View Certifications by | Product == Desupport Advisories and Notices == | | Upcoming Oracle Product Desupports or by searching for Doc ID: 190435.1. | | Product
RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7
in pure client-server mode? if so: quick, someone tell oracle tech support !!! :) what versions of the database? personal, standard, enterprise, etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent: Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] I have 9iR2 and forms 6i on my pc and its running ok so far. -Original Message- Sent: Friday, June 21, 2002 5:08 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms system editor not creating temp file under Windows
Hi, We are using Forms 4.5 under NT4 and Windows 2000 against 81714 database on Windows. For a particular form, the fields are set to invoke the System Editor when Edit, Edit is selected from the menu or Ctrl-E is pressed. This works under NT4 but under W2K. Under W2K, Forms 4.5 tries to create a temp file with a 4 character extension (eg .1TMP) but the file is not created. Under NT4, the file is created successfully with the expected 3 character .TMP extension. Has anyone seen this behaviour and know of a workaround? We are considering altering the item properties to use the default editor instead of the system editor, but it would be better to allow the system editor (notepad) to keep working. I have tried altering the system editor to write or the NT4 version of notepad (by the registry setting forms45_editor) but this has no effect. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tool for migrating from forms 3 to forms 6
Hi Gurus any one have idea of any tool which can be used for migrating from forms 3 to forms 6. Help needed in this is very much appreciated Ayap This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tool for migrating from forms 3 to forms 6
Hi, you could try migrator. See www.logis.cz Robert ---Original Message-- Date: Fri, 07 Jun 2002 03:13:37 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: Tool for migrating from forms 3 to forms 6 Organization: Fat City Network Services, San Diego, CaliforniaPrecedence: bulk Content-Transfer-Encoding: 7bit Hi Gurus any one have idea of any tool which can be used for migrating from forms 3to forms 6. Help needed in this is very much appreciated Ayap This communication contains information, which is confidential and may alsobe privileged. It is for the exclusive use of the intended recipient(s). Ifyou are not the intended recipient(s), please note that any distribution,printing, copying or use of this communication or the information in it isstrictly prohibited. If you have received this communication in error,please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RT INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tool for migrating from forms 3 to forms 6
Hi, you could try migrator. See www.logis.cz Robert ---Original Message-- Date: Fri, 07 Jun 2002 03:13:37 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: Tool for migrating from forms 3 to forms 6 Organization: Fat City Network Services, San Diego, CaliforniaPrecedence: bulk Content-Transfer-Encoding: 7bit Hi Gurus any one have idea of any tool which can be used for migrating from forms 3to forms 6. Help needed in this is very much appreciated Ayap This communication contains information, which is confidential and may alsobe privileged. It is for the exclusive use of the intended recipient(s). Ifyou are not the intended recipient(s), please note that any distribution,printing, copying or use of this communication or the information in it isstrictly prohibited. If you have received this communication in error,please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RT INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Tool for migrating from forms 3 to forms 6
Go to www.kumaran.com. Good people, know what their doing. We had a VERY good experience with them when we left forms 3 behind. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 6/7/2002 3:13 AM Hi Gurus any one have idea of any tool which can be used for migrating from forms 3 to forms 6. Help needed in this is very much appreciated Ayap This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
get_file_name built-in of forms for web
Hi Friends
Did someone succeed to implement the get_file_name built-in of forms using a
javabean with the wrapper class as suggested by Oracle at Metalink
(Note:74140.1) ?
When I try to compile it, I've got the following error :
MyDialog.java:4: Public class FDialog must be
defined in a file called FDialog.java.
public class FDialog extends Canvas {
^
1 error
The java source that I tried to compile is given here below :
Bookmark Fixed font Go to End
Doc ID: Note:74140.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 16-SEP-1999
Last Revision Date: 05-DEC-2001
PURPOSE
===
The get_file_name built-in of forms is currently not implemented for Web.
You could create a Javabean and use it to implement this functionality
for WebForms.
Attached below are the source code of JavaBean the Wrapper Class for the
Bean.
CREATING JAVABEAN
=
The Bean uses the following methods and Classes
---
PropertyChangeSupport for the file_name property.
java.awt.FileDialog class is used to show the File Dialog.
firePropertyChange method is called to pass a PropertyChange event to all
classes which are registered as listeners to this class.
addPropertyChangeListener is used by other classes to register themself as
PropertyChangeListener for this class.
---
import java.awt.*;
import java.beans.*;
public class FDialog extends Canvas {
private String file_name ;
private PropertyChangeSupport pcs;
public FDialog() {
file_name = ;
pcs = new PropertyChangeSupport(this);
}
public void set_file_name()
{
Frame frame = new Frame(Sample);
java.awt.FileDialog OpenDlg = new FileDialog(frame, Open ,
java.awt.FileDialog.LOAD);
OpenDlg.setFile(*.*);
OpenDlg.show();
String old_file_name = file_name;
file_name=OpenDlg.getDirectory() + OpenDlg.getFile();
pcs.firePropertyChange(file_name, old_file_name, file_name);
}
public void addPropertyChangeListener(PropertyChangeListener pcl)
{
pcs.addPropertyChangeListener(pcl);
}
public void removePropertyChangeListener(PropertyChangeListener pcl)
{
pcs.removePropertyChangeListener(pcl);
}
}
-
Thanks for your help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ALEMU Abiy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
SSO on WinNT for Oracle 8iR3 + Web Forms 6i
Hi, did some one implement Web Forms using the Single Sign On concept from Oracle. Coudl you point me to some starting documents please? I have multiple Forms 6i application running on iAS 9i with Oracle 8iR3 databases and I have to implement SSO in a Windwos 2000 environment (server and client alike), but do not know how to start. Every help is highly appreciated. Thanks in advance, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms
Hi All If a form is developed using Developer 2000 on a window's 95 machine having a particular resolution of the monitor (eg.640 x 480 ) and installed on a machine with a different monitor resolution(eg.800 x 600) ,the window size of the form changes.Is there any method to the make these forms independant of the monitor resolution. Regards Systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
