Hi EveryBody, I need to write a Oracle Procdure to zip a file present in UNIX. I am not allowed to use any shell script to do this. Can anyone help me out in this. Thanks in Advance, Chandra
In 10g, you can read and write files using UTL_FILE and zip it using UTL_ZIP. In 8.1.5 and later, you can write a Java stored procedure that would do the same thing using Java's File and zip classes.
Suse 9.0 Service pack 2Oracle 10gDuring the installation, I had to interactively define a bunch of environment variables. The Oracle installation instructions didn't say to put them in a .profile or any other type of file that may be executed when necessary.However, after rebooting, those v...
I use Oracle Application Express 2.2 at my work place. I would like to know is there a way that we can integrate ZK - AJAX Frame with Oracle Application Express? The reason why I want to use ZK because it have so many AJAX functionality and components that I would like to use in Oracle Applicati...
HelloIs there any way to extract data from a text file that has been zipped, without unzipping it first.I have been using UTL_FILE to parse through normal text files and transfer the data it into an APEX table, which works fine. However there is the likelihood that we could receive files in that...
Does anyone know of any software that could convert a US Zipcode into an X/Y Coordinate that I could then load into Oracle Spatial? I'm looking at converting Zipcodes for Tennesse....
Hi Guys, Can anybody tell me how to zip a file using PL/SQL and send it accross network. My worry is ZIP utility in oracle. Does it exist or some other utility does it's job.Chao!!!...
ive downloaded over 1 gig of the zip files for oracle9i personal. Both times ive gotten corrupted zip files that wont open. Im not lagging out, or getting bad connection which usually corrupts large downloads. I am using a cable connection and DL'ing it all in around 50 minutes a piece (3 d...
Hii download both zip files. when i click on these zip files, i receive a messeage that "NO ZIP FILE, BAD ZIP FILE OR PART OF A SPANNED/SPLIT ZIP FILE". When i try to extract it again show me error . Please guide me. when i download it , it download very smothly.ThanksAtiq...
I am building a database with a seperate table for Zip Codes, Cities and States. Is there a Built-In or some other resource for building such a table with all USA Codes?Thanks in advance.Bruce Hyatt...
I produce large text files from pl/sql packages on Oracle 8i, using utl_file. I would like to zip these files after producing them, in the same pl/sql procedure.How can I do it?...
I am experiencing something that goes over my knowledge. We have done database testing for both ZHT16BIG5 and western char set in Oracle 8i. In western char set, no problems. the test goes perfect.With ZHT16BIG5 inserting of the tables fail. Below you'll find the log from the test:Performin...
Hi,I got this question from calling trim(source) on an empty string. Just wondering why Oracle thinks zero-length String is null? i.e., trim(' ') is null.Thanks!...
Dear sir,My boss told me to go for PARALLEL SERVER OPTION.Please tell me where will I get 1) The complete installation procedure. 2) The complete hardware required for it. 3) Budget required.Is there any link available.Q) What benefits will I be reaping if I register myself onto the METALINK.One...
Hello!Can anybody help me??I'm uploading images in my data base like in the samle [URL=http://technet.oracle.com/sample_code/products/intermedia/htdocs/sdk_101/webagent.htm.]http://technet.oracle.com/sample_code/products/intermedia/htdocs/sdk_101/webagent.htm.[/URL] I have just one problem,...
Hellow Sir,Please tell me about error 12571. What causes it occur how much hazardous it can proved to me.Some part of trace in UDUMP, I am enclosing*** 2002.05.30.18.09.34.545*** SESSION ID:(55.643) 2002.05.30.18.09.34.515FATAL ERROR IN TWO-TASK SERVER: error = 12571*** 2002.05.30.18.09.34.545ks...