Forms :: Uploading Excel File Using Webutil In AIX

May 28, 2013

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);

View 3 Replies


ADVERTISEMENT

Forms :: Uploading An Excel File Using Webutil In AIX

Apr 18, 2013

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

View 5 Replies View Related

Forms :: Uploading From Excel Stop When Open File?

Oct 21, 2010

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?

View 8 Replies View Related

Forms :: Uploading From Excel Sheet On The Client

Feb 19, 2013

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.

View 1 Replies View Related

Forms :: Read A Range Of Excel By Webutil?

May 7, 2012

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?

View 3 Replies View Related

Forms :: Webutil EXCEL Download CLIENT_OLE2 Stops When Create Object

May 22, 2010

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]....

View 4 Replies View Related

Forms :: Webtil - Uploading File On Vista

Dec 9, 2011

my application run very well on xp but with vista the webutil can't upload a file.

View 10 Replies View Related

Forms :: Webutil File Transfer Directory Listing

May 25, 2010

Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?

View 2 Replies View Related

Forms :: Webutil - File Functions Bean Not Found

Dec 21, 2011

I 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.

View 4 Replies View Related

Application Express :: Uploading Multibyte CSV File?

Jul 9, 2012

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 ?

View 9 Replies View Related

Forms :: D2k 6i And Excel File?

Jun 23, 2010

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]...

View 6 Replies View Related

Application Express Listener :: Log Errors When Uploading File?

Sep 28, 2012

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].....

View 1 Replies View Related

Forms :: How To Generate Excel File

Jun 12, 2012

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 Related

Reports & Discoverer :: How To Create Link For Uploading File From Report

Feb 4, 2012

how to create link for uploading file from report

View 2 Replies View Related

Forms :: How To Export Data In 10g To Excel File

Mar 15, 2011

I need the code to export the data from the form to the excel directly.

View 1 Replies View Related

Forms :: Data Export To Excel File

Jul 14, 2009

i want to add one button in the form like "save as" and save the displayed data into excel file.

View 20 Replies View Related

Forms :: OLE2 Updating Excel File From 6i

Dec 12, 2011

I 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;

View 1 Replies View Related

Forms :: Unable To Read Excel File?

Nov 1, 2011

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..

View 6 Replies View Related

Forms :: 10g - Upload And Download Excel File

Oct 29, 2010

I want to create a form in oracle 10 g . In this form i want download & upload any excel file.

View 2 Replies View Related

SQL & PL/SQL :: Single Excel File For Emp Table Department Wise In Different Sheets Of Excel

Mar 30, 2012

I 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;

View 1 Replies View Related

Forms :: How To Pick Excel File And Get Data In Column

Jun 18, 2013

How to pick excel data in oracle form 6i. and data show in forms column ?

View 1 Replies View Related

Forms :: Reading Data From Excel File And Load Into Form

Oct 25, 2013

I 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.

View 10 Replies View Related

Forms :: DDE Package - How To Close Excel File Without Saving Changes / Messages

Nov 19, 2009

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?

View 11 Replies View Related

Forms :: Configure Webutil For Use With 11g?

Jun 14, 2010

have a link to install/configure webutil for use with Forms 11g?

View 2 Replies View Related

Forms :: Configure Webutil In 10g?

Aug 3, 2012

how configure webutil in forms 10g. send me all the doc related to this.

View 2 Replies View Related

Forms :: Message From Webutil?

Apr 3, 2012

I'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 Related

Forms :: Progress Bar In Webutil

Mar 13, 2010

I 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 ?

View 1 Replies View Related

Forms :: Uploading Image Which Is Not Database Item From Operating System?

Sep 13, 2010

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.

View 1 Replies View Related

Forms :: Delay When Loading With Webutil?

Jun 22, 2012

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)?

View 1 Replies View Related

Forms :: How To Use AS_TO_CLIENT Webutil Function

Nov 3, 2009

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.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved