Am creating a form for some processing text files available in a local users system. Now I would like to get the directory name from the user using dialog box and read the files
[ I am already reading the file, but I allow the user to select the specific file name using get_file_name ]
I want to read all the files present in a directory of client's machine.
However I have achieved this by creating java class in database but the problem is it accesses the directory of machine on which database is installed not the client's machine.
I have oracle client and I tried to access local directory of client's machine to read all the files in that directory but it didn't work.
However, I achieved this by creating one java class for ex. test.class and I run it locally through command prompt but I want to achieve it using Pl-sql.
I have 100 image file in C:My_PIC/ i want read these image files and put in a table .
My table have 2 column : Id_pic varchar2(20) ,
PIC BLOB
I want read all files in C:MY_PIC and Insert in My table with a BUTTON in My form
ID_PIC = file name
PIC = image
I can store my video in to my database.but i cannot read such file.....using this procedure
ORA-29285: file write error
CREATE OR REPLACE PROCEDURE Extract_bfile
(p_id IN NUMBER)
IS
vblob BFILE;
vstart NUMBER := 1;
bytelen NUMBER := 32000;
len NUMBER;
[code]....
i have one directory in this directory contains 100 file these files are related to table structured creation with dependence
so how to read file names from directory and executed in scheme with logs also
procedure or script
Using PL/SQL I want to search inside a directory and execute the script files with a specific pattern.
I know that with @@ command I can execute a script, however when the name of the files come in a variable I don't know how to execute the script.
Here is the code for searching the files:
set serveroutput on
declare
directory2 varchar2(1024):='/home/oracle/dir';
[Code].....
I am on a font manager project. One of the features is to install the new font file. My understanding by "install" is to copy the file to the system directory Windows/fonts (correct me if I am wrong in this part). When I tried to use the java copy file api to do so, not surprisingly I got the access denied exception.
1. How can I do a "force-copy" of file into the system directory?
2. If that's not proper way, how can I create a "shortcut" like a softlink of the file into the system directory?
i have this stored procedures:
create or replace
PROCEDURE INSERTXML2(
p_xml_in XMLType,
p_table IN VARCHAR2 ) AS
v_context DBMS_XMLStore.ctxType;
v_rows NUMBER;
BEGIN
[code]....
that works well in little XML files but in XML files that are bigger the stored procedures to not work because string maximum length in Oracle is 4000.
im working with Oracle SQL Developer and Sap Mii, the XML file is generated in Sap Mii and then i have to pass it in one step to database..
the following situation, I have a directory named /dat/global/stock/ inside this i will get files named differently for example below.abcdef.112dfgrt.2......
Here i want to load this file one by one into the external tables and generate one more file based on some enrichment.
Step 1. Have to take first file and to load into the ext table.
Step 2. Enrichment
Step 3.File generation.
Now here i am facing a problem that in that particular directory i usually get 1000 files so i need to get file one by one and to put in one more directory. how can i get file one by one and generate file by using oracle loader
I'm trying to install forms 10g on my windows 2000 professional os which is having oracle 9i client. but while installing 10g i'm geting oracle universal installer error. error in writing to directory c:...
My D drive is having 10GB free space and C drive is having 800MB free space (both drive have normal attribute i.e it's not read only ) and oracle have already copied some temp files in C drive (size 13.6 MB) .
I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g
my problem is when i use this code
trigger WHEN-BUTTON-PRESSED
EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';
IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"
I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');
trigger WHEN-BUTTON-PRESSED
WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');
BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "
How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();
is it possible to create a button can open directory like My Documents
i test this in CMD command prompte it's work but in forms they are not work
"explorer.exe" & @MyDocumentsDir
or
cmd /c "explorer.exe" & @MyDocumentsDir
in forms : i create a button with trigger When-button-pressed
my host('"explorer.exe" & @MyDocumentsDir');
host ('cmd /c "explorer.exe" & @MyDocumentsDir');
but it's not work
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;
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.
Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?
View 2 Replies View Relatedhow do i copy an image or a text file from ex: directory c to directory d
View 5 Replies View RelatedI Want Read Image Through URL..Image Is Placed In Another Server Which Is Not in Local Network.
View 1 Replies View RelatedI want to know can Oracle Forms 6i read data throught a BarCode scanner device.
And is there any website that provides different Oracle Data Link Libraries (DLL files) that can be attached to Forms or Reports to provide different utilities to Forms?
created a form which is calling 3 different forms based on the radio button. The main form say 'MAIN.fmb' has the code " execute_query " in when-radio-changed trigger and the following:
if :BLOCK.RADIOGRPNAME = '1'
then open_form('XX');
else if :BLOCK.RADIOGRPNAME = '2'
then open_form('YY');
else if :BLOCK.RADIOGRPNAME = '3'
then open_form('ZZ');
end if;
end if;
end if;
in the pre-query trigger of the control block where XX,YY,ZZ are the three corresponding forms.
While clicking the radio button, 'm getting the error FRM-40010:cannot read form XX.fmb.
the .fmb, .fmx both exist in the location and individually all the forms are working fine but while being called from MAIN is showing this error.
I create a Menu with two Items in it (execute and Exit) .Then i save and compile it with My_Menu name .Then I edit Menu Module Property in Property palette of Module2(file name) .
Menu Module MY_MENU
But at run time its giving me following error message .
frm-10221 can't read menu
Is it possible to read the application URL while running the application
[URL]
Above is my URL i need to read i and t hold it on a variable at runtime
How to read regedit using oracle forms6i ?
View 6 Replies View Relatedin my case both are not working as i am using oracle forms 11g with oracle weblogic application server and attached the required .pll libraries in the form but no success yet.
find below the details;
case-1:
V_adobe_key := WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT'||'.PDF', '',TRUE);
when i click on the button then i does not show anything.
case-2:
V_adobe_key := CLIENT_WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT' || '.PDF', chr(0),TRUE);
when i click on the button form is hanged and on the server machie the following message appears " Close this form". when i close this it close the form applet session completely.
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?
I have a file studnet.txt in following order
JAMs|1231|PHYSICS
SAM|1232|PHYSICS
ALI|1233|CHEMISTRY
I want to read and write data from a file in | seprated mode. file READ and WRITE using Oracle Forms6i. I have a knowledge of file handling in C++ but not use it in Oracel Form before this.
I'm trying to read some data from external device via COMM Port.
Application is running n server and device is connected localy on my PC.
My device iz DPI605R for purpose of� pressure measuring.
I want read 500 GPG image files from a folder ( by A Button in Form ) and move images into a table with a image column (create new records with images) .
View 3 Replies View RelatedI 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 am running the login page on the server with the below URL .
[URL]...
However I am getting the below error .
Frm- 40010 Cannot read form test.fmx