String Capabilities

[Serious_Developer]

I need to store contents of a file to a database . Can I store each page in varchar2() data type column and every page detemined by a unique key (like account nmumber )

Page 1: account 001

..

..

Page 1: account 002

..

..

I do not know which language should be used with string capabilities : SQL or PL ?

I need to use a program the store pages in two columns : Account_no,Contents of page

Thks

[Michael Moore]

What is the content of files? Simple ascii text? word .doc, PDF? 

You should read here http://docs.oracle.com/cd/E11882_01/appdev.112/e23448/u_file.htm#ARPLS069

and here
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#SQLRF54502

--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle...@googlegroups.com
To unsubscribe from this group, send email to
Oracle-PLSQL...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Serious_Developer]

Sorry for the late :

They are ASCII text but I will process some of the data . For example : I will read a unique key and use it as a primary key in certain line : line 3 : position : 6 length : 6. Similarly , I will use capture certain fields according to the line number and position and length .

Page delimiter can be Form feed or any string . Any ideas about the code .

[Michael Moore]

I would use a CLOB datatype to the table column and use PL/SQL for process logic.