daogu

Hi,

I am creating form that will print resumes of candidates. I have created a table (RESUMES) which will store the candidate name and their resume in the database.

The attached form (character_display.gif) displays one record of the table. As seen the name column (varchar2(50)) displays the name ‘Durgadas’ but the resume column (clob) does not display the characters properly.

What changes can I inculcate to display the resume in the form so that I can make it print in the word file later?

---

Answer:Did you query the database to see what is stored on it? you may need to change some properties in the regional settings of the OS if you are using multi language.

---

Answer:Thanks for the reply..

It is not a problem of the database but of the form..Here is the table from the sqlplus

As you can see the resumes column will not display properly as it is a clob column..so I tried to display the same from the form but still the resume did not show the way it can be seen in the word document. It is still displays the same off characters and signs that it shows here..basically the form is not able to interpret its data type. to add to this I also tried doing the same with BLOB datatype in the resume column but the result was the same. Would you know how to display an object stored in the database in the clob/blob data type in its normal form especially is it was a word document.

---

Answer:You could look at these links

http://forums.oracle.com/forums/message.jspa?messageID=936088

http://forums.oracle.com/forums/thread.jspa?threadID=378781&tstart=0&messageID=1272020

Let me know if you find any other solutions.

Mudabbir

Related posts:

1. dispaly pdf file thru forms Hi, I have a table in DB which has...
2. INSERT IMAGE IN 10G DATABASE Dear all i make upgrade only the database from...
3. Adding a new line in a word document using ole2 Hi dear.. I have created a form from which...
4. Form Waiting on Client Input with client frozen We are having an issue with a custom form...
5. Open a word doc from forms I’m using the developer tools that were released with...