SQL & PL/SQL :: Read All Files In Directory On Client's Machine
May 30, 2012
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.
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 ]
how change the default directory path from server to our local system directory in external table while loading the data from csv file to table actually my default directory 'abc'(installed oracle server directory) in external tables , now i want to change that default directory to my local(c:Sm(not installed oracle s/w)).
I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .
From a script how I can read a local file (where I have the sql client)?
I have an Oracle database on a server, and I connect from another machine with SQL Developer.I want to read a text file on my local machine ( where I run my script) to use the data in the script.I never want to read or write on the server.
Reading on internet i read about UTF_FILE package But what is not clear to me is, this is on the server or client ?Also some people says UTF_FILE can work both on client side and server side.Also I read about package text_io, but I think it is only for forms.
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?
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
the trigger shown below is working fine.But i want to get client machine name and client osuser name in the output of the same trigger shown below,how can i achieve this in the same trigger?
the output showing sessionid,date,db user name,host as local server machine name.but i want client machine name and client osuser names as u all know clients login to database from their machines.
I have installed oracle 10g on Red Hat Linux and I am able to connect as well.The listener and DB is up and running and I am able to coonect as well from the server.
But I have installed the oracle client (TOAD) on some windows machine and from there I am not able to connect . I am directly connecting by giving IP and other details and using TNS as well but I am not able to connect from client machine. I am getting ORA 12170 - TNS timeout error.
On cliente/server, I used to get the user IP address using SYS_CONTEXT and IP_ADDRESS, and the terminal name with SYS_CONTEXT and HOST.But in web environment, these functions returned Server IP and name.I have to build a trigger to obtain the information of user IP address and terminal name to save on audit table.
I have some client RMAN backups from an AIX machine, a set of .bkp files including the control file, that I have been asked to restore on a Windows 2003 server. My first question is if such a restore is possible?Also, the backups are from Oracle 10.2.0.3, and I need to restore them to 11g, will this cause any complications?
how to carry out such a restore procedure from scratch.
bash: sqlplus: command not found Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
i install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.
I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?
Is it also possible to use the EXPORT and IMPORT utilities from a client machine? I want to give these utilities to one of my developers without allowing him to sit in front of my Oracle server.
i am generating report from oracle forms using web.show_document .pdf output is coming in seperate url.entire piece of code is working fine.now i want to store this pdf out put in client machine whether path will be specified by user.
I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.
But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path. It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors.
I recently got a new PC at work which is Windows 7 64 bit.
We run lots of crystal reports(1000's) that pull data from an oracle back end.
I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.
However, when I use crystal to access the TNS Name it gives me the following error.
[URL]
My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".
I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.