It's been a long time since I've done Oracle specific stuff, but I believe you want to look into the DBMS_LOB package (or some name like that). I think it's got a LENGTH function that will return the size of the LOB.
Here's what the syntax for usage is: SELECT DBMS_LOB.length (lob_field) FROM table ; -Chris > -----Original Message----- > From: Noel J. Bergman [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2003 12:44 AM > To: James Users List > Subject: RE: no SQL statement to find size > > > > > I thought I can simply add the oracle > retrieveMessageBodySizeSQL like this : > > <sql name="retrieveMessageBodySizeSQL" db="oracle"> > > SELECT length(message_body) FROM ${table} > > WHERE message_name = ? AND repository_name = ? > > </sql> > > > I try to retrieve that email use outlook, an error occur at outlook > > Check the logs, but length() doesn't appear to be defined by > Oracle to work on long raw columns. Find out what does. Also, > if you are using newer versions of Oracle, they recommend > converting long raw to BLOB. I don't use Oracle, but hopefully > you can find an Oracle DBA to help you out. :-) > > > What is actually the purpose that James retrieveMessageBodySize ? in > > fact that this is optional. > > It just lets the POP3 handler tell the client how big the message > will be, which is why it is optional. > > --- Noel > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
