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 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 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.
I want to read a range of excel by webutil in oracle form. I use command:
ole2_client.get_obj_property(worksheet, 'Range', args);
I want to know a list property of an OLE2 Automation Object?
When Running forms on local machine I successfully download data to excel. But when I place this to server (unix), the forms stops in this line: application := Client_OLE2.create_obj('Excel.Application');
I think I have no problem with webutil setup or signing it including the jacob because another form is running on server with webutil functions loading and downloading images (pdf).
The problem is why when it comes to excel I have this issue. When I run the form and the code mentioned above is encountered, the program stops. What I have on java console are:
Loading http://59.0.0.132:7778/forms/java/frmall_jinit.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/frmwebutil.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/jacob.jar from JAR cache
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.0
[code]....
my application run very well on xp but with vista the webutil can't upload a file.
View 10 Replies View RelatedIs there anyway to get a listing of the files in a specified directory on an ftp server using webutil?
View 2 Replies View RelatedI got this message but i dont no what i can do. I finish setup webutil success but when i try to use it i got this message
oracle.forms.webutil.file.File Functions bean not found. WEBUTIL_FILE.FILE_SELECTION_DIALOG_INT will not work.
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 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 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].....
I want to gerate the excel(Office 2010)file using oracle forms 6i. How we can achieve this with forms 6i?
View 4 Replies View Relatedhow to create link for uploading file from report
View 2 Replies View RelatedI need the code to export the data from the form to the excel directly.
View 1 Replies View Relatedi want to add one button in the form like "save as" and save the displayed data into excel file.
View 20 Replies View RelatedI am using OLE2 to update an excel spreadsheet from Oracle Forms 6i. If the excel spreadsheet is already open, the code runs through fine, and even asks if you want to replace the file when running the lines: OLE2.INVOKE(worksheet, 'Save');
OLE2.INVOKE(workbook, 'Save');
However, the file never gets updated. There is no error that appears. I would like to have the program check if the file is open before running the program;
I am trying to create excel file thru form....in form i create button Excel
WHEN -BUTTON - PRESSED :
Quote:
DECLARE
CURSOR C1 IS
SELECT DEPTNO,DNAME,LOC FROM DEPT;
filename varchAr2(256);
[Code].....
My excel file opened but it shows unable to read file
My excel version is 2003..
I want to create a form in oracle 10 g . In this form i want download & upload any excel file.
View 2 Replies View RelatedI need to generate a single excel file which each department details in seperate sheets of the excel file, each sheet should ne named with department no (ex :Dept_10, Dept_20,Dept_30) and the main excel should be named as Emp_details.
Header row and total row should be in bold.I have created 3 individual excels thru toad and moved them to single excel and renamed the sheets.
Can we programatically do this thru SQL or PL/SQL, does Oracle provide any build packages for excel.As excel files cannot be uploaded,I am unable to upload the excel file I generated manually.
select to_char(empno) empno,ename,job,mgr,hiredate,
nvl(sal,0) sal,nvl(comm,0) comm,nvl(sal,0) + nvl(comm,0) "Total Income" ,deptno
from emp
where deptno = 10
union all
select 'Total',null,null,null,null,sum(nvl(sal,0)),sum(nvl(comm,0)),sum(nvl(sal,0))+sum(nvl(comm,0)),null
from emp
where deptno = 10;
How to pick excel data in oracle form 6i. and data show in forms column ?
View 1 Replies View RelatedI have a Excel File which contains some columns and rows, i need to load that excel into a form and import that form data to Database Table, using DDE Method.
In simple i say; Just to read the excel and load into a form, which can be imported into a table later.
How to achieve this? only dde method.
I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.
I am using THe DDE package and when using
DDE.EXECUTE(convid, '[Save()]', 10000);
there is no problem, but the changes are saved. I have tried '[Exit()]' and '[Close()]' but always have error message ORA-106555. Is there any way of doing this without errors?
have a link to install/configure webutil for use with Forms 11g?
View 2 Replies View Relatedhow configure webutil in forms 10g. send me all the doc related to this.
View 2 Replies View RelatedI'm migrating some forms from 6i to 9i and one of them has to use the webutil library, but when I execute the form in the IE, a message appear and I don't know from where because I haven't made it. The message say: "Confirme el mensaje" This is a print of the message,
View 3 Replies View RelatedI have challenge to do progress bar
i have simple form has one database block tabular used to upload files by webutil procedures
my question is there build_in progress bar that special for uploading could be used by webutil ?
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.
we have a problem with forms containing webutil - they start very slow, after like a timeout, while forms without start ok. since i think it has something to do with name resolution i'll first describe our environment.
we have an external net with users, ip range 10.48.x.x, connected to a cisco router which is resolved in that network with the name 'cro'. so the users from that external net access us via 'http: //cro/.....'.
behind that router we have our production net, ip range 192.168.x.x, with forms-, reports- and http-servers. external users accessing our forms server will have to klick a link "http: //cro:8888/forms......'. that way they acces the cisco router which, depending on the port (here 8888) will NAT them to the correct forms server, say http: //forms1:7778/forms....' - up to here everything works well and fast with 'normal' forms (eg. without webutil).
forms *with* webutil on the other hand take like 30-60 seconds to load from that external net (via the router) while they load fast when called from a test-client in the internal 192.168.x.x net. after searching i found [URL] with a hint to alter the clients hosts file.
what i've found out so far is that the clients from the external 10.18.x.x net try to name resolve the *forms servers* in the internal net 192.168.x.x - i can cheat them by providing a fake hosts file which resolves the server named forms1 to the ip of the cisco router cro, but thats a temporarily and bad solution since i cant do that to real clients because i have no access to them.
so... how can i tell a webutil loaded form not to try to connect to the server they are started from (forms1) but to use the host they have been given to start from (cro)? or is there any other solution (which ofc cant include fiddling with the external net or external clients)?
how to use the AS_TO_CLIENT webutil function? The WebUtil User's Guide doesn't give examples. It just gives a description of what the function does:
Quote:AS_To_Client Transfers a file from the application server to the client. The webutil.cfg parameter transfer.appsrv.enabled must be set to true to use this function, and if the transfer.appsrv.accessControl parameter is also set to true, the upload target directory must be listed in the transfer.appsrv.read. list. It is sensible to call the WebUtil_File_Transfer_IsASReadable function with the target filename before starting the download to ensure that you will be able to read from this location on the application server.