Printable View
I want to store bold,italic,underline text in oracle database.Can any one please guide me how to go about ? It would be of great help if an example is also given with reply. Basically I want to store a Rich Text Document which contains some bold and italics words and sentences.
My email address is [email protected] . You can mail me also. I am in very much need of this solution. Please help me as soon as possible.
Thanks in advance.
Hi Apoorva,
if you would like to store the doc file in oracle using vb first you have to have a field with "RAW" data type in your table then you use the OLE control of VB to write the doc file of store a file then when you update the database u can use the ole update propety.before this you have to connect ur ole to the table and the field to whcih the doc has to be saved.
there is another simple solution for this instead of saving the file in database you can just store the path with filename of the file in a table field and while accessing the file you can use this information and with the use of webbrowser control you can navigate the document when ever needed it not only shows the doc file but also it will help you to see the picture files adn other type of files.this is the simple and fast method.
Dear bhanuprakash,
Thanks for your reply.
your idea is ok. I am also trying to work in same direction. I want to know how to store the doc file into oracle database. I mean to say that what should be data type and through vb what functions should be used. Fairly speaking I hv not used Blob till the date and am very confused in Oracle Documentation. It will be opf a great help to me if you can give me a sameple code for the same assuming no tables are created and the doc file is to be stored is say try.doc . What kind of table should be created & how (commands).
And how to connect to database / this table. sample code for the same.
Thanks you very very much in advcance.
pls help me.
Regards Apoorva