Home » SQL & PL/SQL » SQL & PL/SQL » how can store 'jpg' file into oracle db?
how can store 'jpg' file into oracle db? [message #20512] Thu, 30 May 2002 21:54 Go to next message
bo lu
Messages: 1
Registered: May 2002
Junior Member
how can i store a '.jpg' file into a oracle database and how can i to retrieve it from database.

lu bo
dba
hrbsb@0451.com
thank you
Re: how can store 'jpg' file into oracle db? [message #20513 is a reply to message #20512] Thu, 30 May 2002 22:35 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Typically, you should use BLOBs (Binary Large OBjects).

With Oracle Forms you can natively store and retrieve them, and for usage from withing PL/SQL units, there's the DBMS_LOB package. I'm sure you'll find some more elaborated info on Oracle Technet (otn.oracle.com).

HTH,
MHE
Previous Topic: ALTER SEQUENCE in a procedure
Next Topic: Re: ALTER SEQUENCE in a procedure
Goto Forum:
  


Current Time: Tue Apr 23 12:48:09 CDT 2024