BLOB through java stored procedure

2002-09-25 Thread Manavendra Gupta
Hi, Is it possible to write a BLOB as a file on the OS through a Java stored procedure? Regards, Manav. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Any woraround for this ....?

2002-09-04 Thread Manavendra Gupta
You can use the sqlplus parameter "LINESIZE" to specify the size of each line for output. I have used it in the past with lengths of 5000 and more, and it has worked, including spooling to files. The only drawback in this case is that it "adjusts" each line to LINESIZE (adds spaces to the right wh

Re: woo hoo

2002-08-30 Thread Manavendra Gupta
from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Servic

Serving BLOB from the database

2002-08-29 Thread Manavendra Gupta
Hi,   I'm sure there has been discussion in the past about the same, but I'm more interested in the feasibility/performance of serving images (stored as BLOB) from the database.   1. For a large multi-tier application (client, web-tier, application, database), with about 5 million records up

Re: sql loader control file help - solved

2002-08-28 Thread Manavendra Gupta
ubscribing). > > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > IN

Re: Moving to UK - what are Oracle contracts like?

2002-08-16 Thread Manavendra Gupta
gt; > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bishop Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists >

Re: what is wrong with this idea ...

2002-08-14 Thread Manavendra Gupta
in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manaven

Re: nextval increments by 2 in pl/sql procedure

2002-08-14 Thread Manavendra Gupta
City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED

Multi-level passwords

2002-08-13 Thread Manavendra Gupta
Hi, How do I implement multi-level passwords for access (connecting via Oracle thin client for java, SQL*Plus) to Oracle? With Warm Regards, Manav. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services

Re: It took more than an hour to update 10,000 records

2002-08-13 Thread Manavendra Gupta
g list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from).

Re: Dba tools on NT

2002-08-13 Thread Manavendra Gupta
list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Ser

Re: Physical Database Layout

2002-08-10 Thread Manavendra Gupta
nt me in the right direction, it'll help me a lot. > > Btw, Oracle has more than 200 initialization parameters, all affecting its > working in some or the other way. Do the gurus keep all of them at their > finger-tips? > > TIA, > Manav. > > -- > Please see

Encryption of data

2002-08-10 Thread Manavendra Gupta
What is the best way to encrypt data in Oracle (like username/passwords, etc)? Is there a provision to encrypt the entire table/tablespace ? Thanks, Manav. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network

Physical Database Layout

2002-08-09 Thread Manavendra Gupta
www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself fro