Skip to Main Content
  • Questions
  • How save clob object directly into Database table

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Adinarayana.

Asked: January 06, 2020 - 3:20 pm UTC

Last updated: January 07, 2020 - 3:58 am UTC

Version: 10g

Viewed 1000+ times

You Asked

I need to write a procedure to save the clob object in database table.

The procedure will call from java and they will give id and two files objects as input.

I need to save them to our db table.

I created a table as follows

<Create table text1(id number, file_type varchar2(20), upload_date timestamp, file_name varchar2 (20), data clob);>

I know how to save the clob file when they provide file name and directory name.

In this case they are not going to provide those. I didn't have idea to do this. Can you help me with some inputs

and Connor said...

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

In those cases they provided the directories

A reader, January 07, 2020 - 4:38 am UTC

In my case they don't provide the directory names to read the clob object. They are giving the clob objects. Please check once.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library