Home » SQL & PL/SQL » SQL & PL/SQL » plz its urgent LOB problem
plz its urgent LOB problem [message #9520] Tue, 18 November 2003 02:25 Go to next message
ora
Messages: 47
Registered: June 2002
Member
Hi,
Can anyone tell me the exact syntax of storing pictures and binary data in BLOB Column.
Moreover I m using BFILe to store some external files the files r getting stored properly when when i try to read it oracle give me the error that invalid directory. But i have created the dir on OS as well as in oracle using command CREATE DIRECTORY... . Plz tell me where i m missing and wht?
Thanx.
Re: plz its urgent LOB problem [message #9523 is a reply to message #9520] Tue, 18 November 2003 03:45 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
What environment for the BLOBs? Do they come from the client. In Forms it is pretty easy (built-ins exist). You can use a Java procedure in another environment.

Here's one useful link. Search his site thouroughly, it might be worthwhile. Another interesting site is http://docs.oracle.com

MHE
Previous Topic: Problem while using Parameter of a Function/Procedure in the Declaration part of Pl/SQL block as a R
Next Topic: plz its urgent LOB problem
Goto Forum:
  


Current Time: Fri Apr 19 02:59:32 CDT 2024