Skip to content

PL/SQL (MOSC)

MOSC Banner

Error when using DBMS_LOB.GETLENGTH(BFILE) and DBMS_LOB.LOADBLOBFROMFILE()

edited Feb 5, 2018 4:02AM in PL/SQL (MOSC) 7 commentsAnswered

Hi,

I want to insert the content of a file into a BLOB type field.

When I use DBMS_LOB.GETLENGTH(BFILE), the value is always 0. Have anyone encountered this issue?

Another issue is when I use DBMS_LOB.LOADBLOBFROMFILE(). I got error 'ORA-22994: source offset is beyond the end of the source LOB'.

Please help!

Thanks & Regards,

Ying

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center