Skip to content

Subprograms for writing to and reading from a (server) file #56

@janihur

Description

@janihur

I suggest the following subprograms for writing to and reading from a (server) text file. If the idea is accepted I can create a pull request.

-- Write a clob (p_text) into a file (p_filename) located in a
-- database server file system directory (p_path). p_path is an Oracle
-- directory object.

procedure write_to_file (
  p_text in clob,
  p_path in varchar2,
  p_filename in varchar2
);

-- Read a content of a file (p_filename) from a database server
-- file system directory (p_path) and return it as a temporary clob. The
-- caller is responsible to free the clob (dbms_lob.freetemporary()).
-- p_path is an Oracle directory object.

function read_from_file (
  p_path in varchar2,
  p_filename in varchar2
) return clob;

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions