0

I am just wondering is there any way that we can print the values of a file in plsql

thing is:

I select 5 columns from a table and one of the column is a path/file.
I want to print the contents of the file

I know its complex but will be good if someone shows me a way.

A.B.Cade
  • 16,735
  • 1
  • 37
  • 53
Kannan Lg
  • 911
  • 4
  • 11
  • 21

2 Answers2

2

One way could be to use UTL_FILE to read the file, and dbms_output to print it.
Note, that you'll have to tell ORACLE which paths can hold the files (see here)

Another way could be to use a java stored procedure, see this AskTom

Community
  • 1
  • 1
A.B.Cade
  • 16,735
  • 1
  • 37
  • 53
0

It depends on what you want to achieve or what the context is. The key words "External Tables" or utl_file Package or CLOB data type might be of interest to you.http://docs.oracle.com/cd/B19306_01/server.102/b14220/schema.htm#sthref777

Juergen Hartelt
  • 664
  • 4
  • 5