Re: how to know size of long raw

You need to store the size separately. Otherwise you just have to read until Oracle sez there's no more, which could be 2 gig later.... That's one reason LOBs are better than LONGs. Any reason for using the outdated version for what must be new software (suggested by the context)?

Dave.

pola_praveen wrote:
> I'm storing different types of files (like doc,ppt,pdf) in a long raw
> column in table.
>
> Could you please let me know how can I get the size of each file for a
> particular row from the table.
>
> can I retrieve the above information thru sql command or is there any
> dbms package api's (like dbms_lob.getlength for getting size of blob)to
> retrieve the size of a longraw.
>
> Thanks in advance whoever respond.
>
> Thx,
> praveen.
>
> --
> Posted via http://dbforums.com

-- 
Email address munged to avoid SPAM
Reverse the last two parts to reply directly