Forms :: Webtil - Uploading File On Vista
Dec 9, 2011my application run very well on xp but with vista the webutil can't upload a file.
View 10 Repliesmy application run very well on xp but with vista the webutil can't upload a file.
View 10 RepliesWhen i am uploading data in an excel file to my Forms(Windows) the screen works fine but when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is uploaded with decimal points.
The field is a char type and no format mask is set.
E.g. :
Actual data: In Form(Windows) In Form (AIX)
4080026 4080026 4080026.0
When i am uploading data in an excel file to my Forms(Windows) the screen works fine . But when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is wrongly uploaded . The field is a number type and no format mask is set.
E.g. :
Actual data:---------- In Form(Windows)------In Form (AIX)
3101513480750030000 3101513480750030000 3101513480750029800
I am using below code to copy the value
cell_value :=Client_OLE2.get_num_property(cell, 'Value');
COPY(cell_value,'data.field'||k);
I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
I am having problem in installing 9i on vista I installed forms 6i successfully but when installing 9i database it is not installing properly.
View 3 Replies View RelatedI am trying to migrate 6i forms to 10g on vista machine . If i compile pll or fmb files in 10g,I am able to run the form only once. If i close the form and try to open it again,form builder crashing.
nothing is opening after compiling once in 10g. I reattached all the pll files to forms after compiling..This even does not worked.
I have multibyte CSV files (extract from BI) : Excel says "Unicode txt" and when I save them from Excel in "Text CSV", they get half the size on the disk.
here is the piece of code where the uploaded file get converted from blob to clob then to varchar2 (CSV Util from Oleg.Lihvoinen [URL]...
SELECT blob_content
INTO v_blob_data
FROM wwv_flow_files
WHERE NAME = p_file_name;
[code]...
I have tried different values for "blob_csid := 873 ;" (and by the way, the list of possible values for this code is very difficult to find : I know, there is a function CS_name to CS_ID but a list would be great), but without any visible effect.If I use the Apex CSV uploader app, the result is the same than with this code.
is an example :
�O�R�A�C�L�E�
instead of :
ORACLE
How I can have these files imported whithout an Excel conversion ?
I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:
Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[Code].....
how to create link for uploading file from report
View 2 Replies View RelatedI have a form that upload an excel file to the database . I make for in it a browsing button for the uploaded file and take the path (e.g c:upload.xls) when the procedure of upload work. it always search for the path on the application server and thats wrong . I want it to search on the client machine for that path .
PROCEDURE XLS IS
BEGIN
DECLARE
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
workbook OLE2.OBJ_TYPE;
worksheets OLE2.OBJ_TYPE;
worksheet OLE2.OBJ_TYPE;
cell OLE2.OBJ_TYPE;
args OLE2.OBJ_TYPE;
[code]........
you see this
filename := :block7.FILE_NAME; (5th line from the begin block)
:block7.FILE_NAME is the path that i said as an example c:upload
That path is on the client machine the form trying to open that path from the application server.
uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.
I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;
But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.
I tried to install Oracle 11G (release 11.1.0.6.0) on my Desktop whose operating system is Windows Vista Business Service pack 2.I chose as kind of installation: Personal Edition but I had the following error messages (the same happend when I chose Eenterprise Edition):
ORA-00445 error PMON does not start even after 120 sec at the time of instance starting up. If I gnore it I have ORA-01034 Oracle not available.I couldn't check the trace file of PMON under bdump and the alert log file under udump because these directories were not yet created.
I checked also the environment variables ORACLE_HOME and ORACLE_SID and they were OK.i also checked the Ram available(I've got more than 2GB) and the available space on disk (I have more than 300 GB on C)
What should I do?? Do I need install any specific patches???I am Oracle Certified professional 10G DBA and i need to install 11 G to do the exam of upgrading Is there any other Oracle versions that i can download freely and that work with my operating system?
Im trying to install oracle 11g release 2(11.2.0.1.0) on oracle solaris 10(x86-64) on vmware on my laptop and my host OS is vista home basic ...
i successfully installed solaris on vmware but while im trying install 11g on it,its show .oui:syntax error at line 1: '|' unexpected.
i follow oracle documentation as well as OFA...
I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedGetting Error while uploading payment using API ap_checks_pkg.Insert_Row:
ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_AC_TABLE_HANDLER_PKG.INSERT_ROW<-AP_CHECKS_PKG.INSERT_ROW<-
with parameters (ROWID = , CHECK_ID = 39368)
while performing the follow
I am trying to upload the data into emp table through sqlloader and facing the following error.
col1 in the data file size is 300.
After reduced the length to 200 and its getting inserted successfully.
EMP
-----
COL1 varchar2(300)
Error in Sql log file :-
value used for ROWS parameter changed from 64 to 10
Record 1: Rejected - Error on table "SCOTT"."EMP", column COL_1.
Field in data file exceeds maximum length
Version : SQL*Loader: Release 11.2.0.3.0 - Production on Mon Mar 4 15:53:55 2013.
I am running emca -config all db -repos recreate command and recreating the repository. Doing so I am getting error while uploading the repository. The Drop and Create is going fine. The exception that I am getting is :
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions
at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
[Code]..
And the emca config file is showing exception with i18N jar file.
oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
SEVERE: null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Code]...
Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper
why this exception is coming while uploading the reporsitory.
I have got an issue while uploading the raster data which are in .img format, the upload process is very slow.Previously it was done in 6-8 mins for 10 images but now it is of 30min and even 1 hour too..
View 20 Replies View RelatedI got error "Upload New Image must be specified. Click browse to select an image from your local computer" while i upload image in shared components>image>create ...
my logo is saved in local drive D. when i browse file and click to upload it gives error that i mentioned. This is happening with every uploading weather its image or weather its plugin.
I am using SQL Loader to load data from text file to DB. non-ASCII characters present in the text file is not uploaded correctly to DB.
Sample Data
test data üindex
Data in DB
test data ?index
I have been searching the forum (and Google) looking for tips on how to ensure users can only upload files of specific formats (Word, PDF, etc) for specific document types as defined within the application (e.g. Curriculum Vitae (Word), Copy of Transcripts (PDF)).
While I have used this research to start work on a server-side solution, I would like to know if there is an apex-friendly way to "validate" a file-browse item based on mime-type.
I have created the below stored procedure and calling the procedure in when-button-pressed trigger. Problem here is that when I cancel the file selection in file open dialogue box its raising exception.
PROCEDURE TEST
IS
buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);
BEGIN
[code].......
Is it possible to get the same name of file name from imported text file?
What i've is, I import the text file then I exported it.
can I get the same name of the imported text file?
i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).
(1) now the rest of the page will be covered by the third frame in which the fmx's will run.
(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.
Exporting text data from a table. Suppose I have a table of employees.
In oracle Forms. I make the two column of Hire_date1 and Hire_date2. When I put the Date Into Hire_date1 and Hire_date2 , And press push button. All the data save in text file C: emp folder.
The form which i developed is for Multiple user. i.e many no of user upload the same csv file at the same time. To differentiate it 4r the user i gave the user name in Prefix. say the users name are xx and yy and the file name is test.csv. In the kentucky server it is loaded as "xx_test.csv" and "yy_test.csv". It loaded along with Double quotes.I used the varible to get loaded
l_bare_filename := '"'||v_username||'_'||substr(:FIC_SOURCE,instr(:FIC_SOURCE,'',-1)+1)||'"';
l_bare_filename is that variable.
When i tried to null the csv file it is not created as Double quotes in Kentucky server. say it is displaying xx_test.csv file. Below is the command for making null. I used the same variable
host('cat /dev/null > /tmp/'||l_bare_filename )
I want it to be displayed with Double quotes.
I have generate a excel file through oracle developer 2000 6iwith password protect using OLE2 but autofilter,sort and format column options are not working.
PROCEDURE UnProtectCell(r NUMBER,c NUMBER) IS
BEGIN
args:= ole2.create_arglist;
ole2.add_arg(args, NumToRange(r, c));
XLRange:= ole2.get_obj_property worksheet, 'Range', args); ole2.destroy_arglist(args);
[code]...
i want to run sql file by forms...is there command do that
View 3 Replies View Relatedoracle forms 6i
oracle ebs 11.5.10
database 9i
i create new custom application in my ebs 11i and i want to upload file in our custom application and save it as file system in my server lunix
how i attach my file and i want to save it not as blob but just upload to my server and after download it?
I'm in an environment with Weblogic Oracle Forms 11G (Oracle Fusion Middleware). I can not update a form that is in use. I can not change the fmx file.
Can I change this? Where can I configure this?