-
Problem in retrieving blob from database
Hi All
can any one help me ,How I can write a procedure to retrieve a blob from a table and write to the O.S file.
by usng dbms+lob and utl_ pack file.
can any one give me the source code?Will be very usefull for me.
regards
praveen
-
-
Hi.
Try these:
8i Upwards
http://www.oracle-base.com/Articles/8i/ExportBlob.asp
9i Rel2 Upwards
http://www.oracle-base.com/Articles/9i/ExportBlob9i.asp
There is a known bug with the latter on Windows 2000. Not sure which patch contains the bug fix.
Cheers
Tim...
-
Hi Tim
Thanks for your reply.
I am new to oracle/Java.
Can you help me out by giving me solution,that how I can perform the same job only by PL/SQL
thanks and regards
praveen
-
Hi
Thanks for your reply.
I am new to oracle/Java.
Can you help me out by giving me solution,that how I can perform the same job only by PL/SQL
thanks and regards
praveen
-
Hi
Upto 8i util_file can do only ascii files..i am not sure about 9i..if you are using 9i then probably you shoudl read the docs of 9i
regards
Hrishy
-
Duplicate Thread ?
http://dbasupport.com/forums/showthr...threadid=34454
Well, but here u have more input. This should make the thread starter happy to get more info.
Cheers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|