I'm trying to create an upload button in oracle forms 6i using D2KWUTIL win_api_dialog.open_file function. This works fine in Windows XP (32-bit), but in Windows 7(32-bit) I keep receiving "FRM-40734: Internal Error: PL/SQL error occurred" error.
I traced the source of the error to an exception called "WIN_API.NOT_AVAILABLE" captured in a function called "ChooseFile" that are used by the "Open_File" function and reside on the same package.
I know that this topic in not new, but maybe my case is a bit different than common.My form has multi-record block (4 columns) in which i want to upload CSV file.
The form will have "Browse..." button to piont CSV file (on local users disc, not where Forms server resides) after pointing the CSV file, user will press UPLOAD button which will import CSV data into block. After that data is visible in block. But whole form must not be refreshed.
I'm studying about UTL_FILE package, but it seems it allows manipulating files on server not local user's machines. Do Forms have such "Browse... -> UPLOAD" possibility or I need to learn Java and create Java funcionality inside Forms?
Or it is impossible to load data directly into form? (I have to use SQLoader and load data into temp table then into block on form????)
I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
I have installed Oracle Form6i/Report6i Developer Suit on Windows 7 32-Bit Enterprise Edition and I don't have any issue in development/programming area. Forms/Reports are compling good without any error.
But when I try to run any ".fmx" than an error comes which is attached herewith. Whereas my exprience say, it is an error related to incompatability between Oracle Form6i "ifrun60.exe" and Microsoft Windows 7 32-Bit.
I have windows 7 professional edition 32bit and i have tried to run oracle form 10g on chrome and Mozilla browsers they require plugin but don't install, windows ie8 crashes. i searched through internet about this problem some suggested to use jinitiator, i installed it manually and auto both and also paste the "jvm.dll" but the problem is yet to be solved.
i want to hide the MDI window which comes at run time when we run a form in the browser and i have attached a windows.jpg file. in the first window in which these things are written Action Edit Query Block Record Field Window ORACLE.
i like a color which is on my desktop, i want that color as my Canvas background color. i press the print screen button on my laptop, open Ms Paint, Paste it there, and pick the color.
Now i want to use the picked up color to be appeared in my oracle forms color palate. how could i do that.
I am trying to install Oracle 10g Developer suite on windows 7 but the system gives the following error. (file attached). I have successfully installed Oracle 10g Database.
i have a picture saved in file system (sharing area on the server) ,i need to retrive the picture with windows picture and fax viewer how i can call windows picture and fax viewer
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Solaris: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production
Current written logic for reconciliation:
1. Load data from source_a in a staging table using date filter
2. Load data from a file (Source_B) in temp table
3. Algo for reconciliation:
fetch value from source_B and if an entry exists in source_a then match say 10 columns if they match update reconciliation_oke = TRUE
there is an and written for testing all the 10 columns There is report generated out this which shows non matched columns and the entries which are missing....Now the requirement is to modify the logic in a way which shows which all columns are mismatched on the report in case present.
Since there are around 10 thousand records which would be reconciled on a daily basis, performance also needs to be taken care of...I guess i would be required to use PL/SQl tables...
I have a Problem related to performance and quickness of a customized application
suppose that this application work on 2 clients. Those 2 clients logon to the same database and the same mapping application folder also the 2 PC configuration are the same.
the first client has OS windows XP , the second client has OS Windows 7. I noticed that the the second client (win7) is less performance than the first one (win xp) also I saw the application on the second client is slower than the first client.
I know that Oracle 6i on win7 is dis supported . Also i know i should upgrade to 10g or change the OS to xp. But is this the only way for enhancing the performance or is there another way i can do without changing anything (Patch , etc)
I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs
When i trying to install oracle Forms on Windows XP i am getting following error message . When i click on Setup , Dos windows Opens with following error message .
Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 5.1 Passed Checking monitor: must be configured to display at least 256 colors . Actual 4294967296 Passed Checking swap space: 0 MB available, 1535 MB required. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before continuing with the installation, at which time they will be rechecked.
I have a forms 11g application that of course has several message and alert windows that pop up when various errors or messages need to be displayed. This all works great on the developer machine, but when I try and run the form on another machine using any browser the message and alert windows appear to be hidden and the application locks up with the rolling bar across the bottom. I would guess it is waiting for a response, but I cannot get the window to appear.
Following is an example of an alert to be displayed: declare vAlertButton number; begin vAlertButton := show_alert('NO_EMAIL'); end;
I have an oracle application (Froms 6i) that is being accessed from a PC client running Windows 7 Professional. Whenever I try to access the the application I get a "Oracle Forms Runform has stopped working" error. I tried installing the runtime over and over again withn no use. This is not the first problem I encounter with "Windows 7- Oracle 6i" combination.
