35:
36: l_lob_id number;
37:
38: cursor c_get_next_lob_id is
39: select fnd_lobs_s.nextval
40: from dual;
41:
42:
43: BEGIN
52: CLOSE c_get_next_lob_id;
53:
54: x_file_id := l_lob_id;
55:
56: --insert an empty lob into fnd_lobs
57: insert
58: into
59: fnd_lobs
60: (file_id,
55:
56: --insert an empty lob into fnd_lobs
57: insert
58: into
59: fnd_lobs
60: (file_id,
61: file_name,
62: file_content_type,
63: file_data,