#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    chennai,TN, India
    Posts
    4
    Rep Power
    0
    Hi !

    I have one problem in Oracle database. The size of the string i use exceeds 4000 character, so varchar2 type cannot be used. Can any one tell me with a simple example of how to convert a string of such type to a Clob type and store in database and on retrieval, convert it back to string?.

    Thanks in advance.
    swarna
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2007
    Location
    Chennai
    Posts
    1
    Rep Power
    0

    Oracle


    Originally Posted by swarna
    Hi !

    I have one problem in Oracle database. The size of the string i use exceeds 4000 character, so varchar2 type cannot be used. Can any one tell me with a simple example of how to convert a string of such type to a Clob type and store in database and on retrieval, convert it back to string?.

    Thanks in advance.
    swarna
    Do you need the conversion stuff in Oracle native functions or other language stuffs

    Comments on this post

    • Nemi disagrees : yjenith, what were you thinking? Seriously. This post is from 2001. Did you really think a follow up question was going to be answered?
  4. #3
  5. Feelin' Groovy
    Devshed Supreme Being (6500+ posts)

    Join Date
    Aug 2001
    Location
    Chicago, IL
    Posts
    10,131
    Rep Power
    5058
    http://java.sun.com/j2se/1.5.0/docs/...erialClob.html
    http://java.sun.com/j2se/1.5.0/docs/...java.sql.Clob)
    http://java.sun.com/j2se/1.5.0/docs/...a.lang.String)

    ...etc.

    It's an extremely important skill to learn to read the API and become familiar with the tools you will use to program Java. Java has an extensive set of online documentation that you can even download for your convenience. These "javadocs" are indexed and categorized so you can quickly look up any class or method. Take the time to consult this resource whenever you have a question - you'll find they typically contain very detailed descriptions and possibly some code examples.

    Java API Specifications
    Java SE 6 JDK Javadocs

    Best of luck!

    ~
    Yawmark
    class Sig{public static void main(String...args){\u0066or(int
    \u0020$:"v\"ʲ\"vΤ\"".to\u0043h\u0061rArray()
    )System./*goto/*$/%\u0126//^\u002A\u002Fout.print((char)(($>>
    +(~'"'&'#'))+('<'>>('\\'/'.')/\u002Array.const(~1)\*\u002F)));}}

IMN logo majestic logo threadwatch logo seochat tools logo