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


ADVERTISEMENT

Forms :: File Transfer From Server Directory To Client?

Oct 3, 2013

I write a file on database server by following

CREATE OR REPLACE DIRECTORY TEST_DIR AS 'c: emp'
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
SQL> select * from all_directories;

OWNER DIRECTORY_NAME
------------------------------ ---------------------
DIRECTORY_PATH
----------------------------------------------------
SYS TEST_DIR
c: emp
SYS PUBLIC_DIR
E:PUBLIC_dir

and then

PROCEDURE run_query(p_sql IN VARCHAR2
,p_dir IN VARCHAR2
,p_header_file IN VARCHAR2
,p_data_file IN VARCHAR2 := NULL) IS

[code]...

but I get error wut_118.

View 1 Replies View Related

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

Forms :: File Transfer Through Pl/sql Programming?

Jun 15, 2011

I am facing a issue with one of my programming application. We need to transfer a file through pl/sql programming from a unix server to another destination(target) server.

How can we do it through pl/sql programming. I learnt that oracle streams can be used for this.

I do not know what all code is required for this. send me the code for a sample text file.

I also want to encrypt with a password and zip the file

View 3 Replies View Related

Forms :: How To Get File Directory Path Dynamically In The Report

Sep 6, 2013

I want to get file directory path dynamically with out using directory in database or not hard code like below

the purpose is i need to check image in the path directory if not found i unable to generate report, is there any possible to get dynamically

function CF_URLFormula return Char is
v_handle utl_file.file_type;
v_file_dir VARCHAR2(60) := '/u002/app/applmgr/temp/';
begin
v_handle := utl_file.fopen(v_file_dir, :photo_name, 'R');
utl_file.fclose(v_handle);
RETURN v_file_dir||:photo_name;
exception
when others then
srw.message(100,SQLERRM);
return null;
end;

View 1 Replies View Related

Forms :: Copy Image Or Text File From Source Directory To Destination

Oct 31, 2011

how do i copy an image or a text file from ex: directory c to directory d

View 5 Replies View Related

Forms :: Use A Compound Condition On Form Listing Say 15 Records Utilizing F11 Key?

Aug 7, 2012

Is it possible to use a compound condition on a form listing say 15 records utilizing the F11 key?(ie. order column <10 and >5)

View 2 Replies View Related

How To Transfer Output File From One Server To Another Using Stored Procedure

Apr 9, 2012

We are running a store procedure by calling it from shell script.The shell script is running in Server1 and the stored procedure is running in server2(which is the data base server.).

Functionality of the stored procedure:Generating a tab delimited file and place in a directory.

Requirement: The requirement is that the store should be modified in such a way that it should drop the output file to Server1 itself(The server from where it is getting called).

Attaching the store procedure for reference. mIn the store procedure,we have a variable "lv_file_dir" which currently refers to the directory location in Databse server(Server 2) We have to change this SP such that it drops the generated file in Server1 itself(From where the shell script is running).

Attached File(s)
Procedure.txt ( 3.28K )
Number of downloads: 4

View 2 Replies View Related

Performance Tuning :: Command To Transfer File From Local To Remote Server

Apr 21, 2011

I ran a scp command to transfer a file from local server to a remote server. when I am trying to kill the process, its giving an error.

ksh: kill: 19258: No such process

If I do a ps -ef | grep scp its showing the process running, but if i try to kill it, its showing me error.

View 7 Replies View Related

Data Guard :: Unable To Transfer Archivelog Wrong Pass File

Aug 2, 2010

I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors

------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------

I copied the same pass file from primary to standby and many times verify the same but i got the same error.

View 4 Replies View Related

SQL & PL/SQL :: How To Get The File Name From Directory

Dec 12, 2012

How to get the file name from directory without Java. Is there any way to do it in Pl/Sql.

View 13 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

Accessing File From Directory?

Oct 7, 2009

have a log file in unix server under(/usr/home/oraj/log/abc.log) I am trying to access from oracle stored procedure as fallows

src_clob BFILE := BFILENAME('/usr/home/oraj/log', 'abc.log');

Exception:
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at "usr.LOAD_CLOB_FROM_XML_FILE", line 39
ORA-06512: at line 1

I dont want to create directory as such ('/usr/home/oraj/log') as it is already exists and all log files sits there.

CREATE OR REPLACE PROCEDURE Load_CLOB_From_XML_File
IS
dest_clob CLOB;
src_clob BFILE := BFILENAME('/usr/home/oraj/log/', 'abc.log');
dst_offset number := 1 ;
src_offset number := 1 ;

[code]...

View 1 Replies View Related

SQL & PL/SQL :: Generates CSV File In Directory

Feb 17, 2012

This generates a CSV file in an directory. When it runs for the 1st time it take SYSDATE -7 data. After the 1st run it appends the data since the last run. Now my problem is the appending happens at the bottom of the file and every time the header appears. I want the header only the first time and the new data should keep appending at the top so that i get the latest data always at the top.

View 18 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

Forms :: Webutil Not Working In Solaris

May 9, 2011

i have insert image using webutil (oracle forms 10g) to database in windows o.s. it was successful. but when i have tried it in solaris o.s. . It is not working in linux how to do it in solaris o.s. when i am clicking on the browse button it is showing pl/sql error how to solve it.

View 3 Replies View Related

There Is No File Audit In Adump Directory

Jan 6, 2013

I have an issue when I enable auditing feature in oracle,I use 'DB' to store the audit from user in oracle, my command is

SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate;
SQL>startup;

in show parameter audit, I see that the audit_trail already changed to DB after I create a user and enable audit for this user, I can see in the audit table dba_audit_trail for insert, update, delete,etc but If I am not wrong, if I using DB to setting the audit parameter then I will get audit file both in oracle table and in adump oracle folder installation, but in my case I cannot find any file in adump directory.

my operating system is windows7 and I use oracle database 10g express edition

View 8 Replies View Related

Forms :: WebUtil And Jacob Settings In AIX Server

Sep 21, 2010

I am using forms 10G. I have done the setting for webUtil and Jacob in my pc for browse button to be work and it is working fine .I am sending you the attachment ,which i followed for the configuration in my PC.

But can any one please tell me the steps for implement these things in AIX server so that everyone can use my form .I mean how to configure this to utility Webutil and Jacob in AIX server .

View 1 Replies View Related

Forms :: Configured Webutil For OAS On Oracle EBS R12 Linux 64?

May 1, 2010

I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.

Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"

webutil configuration steps on R12 or the error solution,

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 1.0.6 In 10g Opens Blank Page

Jul 8, 2009

I have developed a form which has webutil objects in it, and it is working fine on my local machine. When I deploy my form to my application server it opens up a blank page. I have configured the webutils in the app server as per the document and made entries into formsweb.cfg regarding frmwebutil.jar,jacob.jar. Does the dev suite need to be installed in the server for the webutils to run properly?

Also I watched my java console as I opened my form and I am pasting the contents below:
-----------------
Loading frmwebutil.jar from JAR cache
Loading jacob.jar from JAR cache
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.3
[code]...

View 14 Replies View Related

Forms :: WUT-113 - Too Many Rows Error Using Webutil To Upload Doc Or PDF

Jun 1, 2010

I'm new to using Webutil to upload and view files and am receiving the error msg 'WUT-113 Too many rows matched the supplied where clause' The process works fine for uploading photos but not when I try and upload documents and pdf files.

The code example (for documents) is outlined below but think that the issue must be to do with some sort of incorrect Webutil configuration on my machine.

declare
vfilename varchar2(3000);
vboolean boolean;

[Code]...

The :blob_id column is populated on the form with the when-create-record trigger. Why is the program at time of upload to the db saying that more than 1 row is being written to the db table?

View 4 Replies View Related

Forms :: WebUtil Host Bean Not Found

Jul 22, 2010

I have configues Webutil in Application Server and i am using Client_host to open imageviewer .. but when running the form it gives me error "Orace. Forms.webuti.host bean not found Webuti_host.execute will not work" i have done the following configuration for webutil

File frmwebutil.jar
From folder: webutil_106webutil_106java To: $ORACLE_HOME/forms/java

File: jacob.jar
From folder: jacob_18 To: $ORACLE_HOME/forms/java

File: d2kwut60.dll, JNIsharedstubs.dll
From folder: webutil_106webutil_106webutil To: $ORACLE_HOME/forms/webutil

File: jacob.dll
From folder: jacob_18 To: $ORACLE_HOME/forms/webutil
[code]....

Configuring Database:

1. Connect as Scott or your User

2. Run the script $ORACLE_HOME/forms/create_webutil_db.sql using SQLPLUS or any tool.

Setting up Form Builder:

1. Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
2. File > Save as and Rename the file to different name e.g WebUtil_lib
(Trust me it works to avoid Webutil not found error)
3. Compile the new PLL file and generate it
4. Attached the new named Webutil_lib.pll to your form with Remove Path option YES.
5. Open WebUtil.olb file Object group in builder and copy or subclass it into your form.
6. Now compile your form and run it.

View 2 Replies View Related

Forms :: WEBUTIL Error In MOZILLA And CHROME?

Jul 19, 2010

I have configured webutil correctly according to its pdf instructions, i run the form-utility which checks wether I configured webutil correctly or not(i found it in metalink) and everything seems to be ok. Webutil runs great in Internet Explorer but I keep receiving the following error in MOZILLA and CHROME:

oracle.forms.webutil.fileTranfer.FileTransfer bean not found. WEBUTIL_FILE_TRANSFER.getMaxTransfer will not work.

View 7 Replies View Related







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