UTL_FILE.FOPEN Handling in oracle 18c
Starting in Oracle Database 18c, the UTL_FILE_DIR parameter is no longer supported.
Instead, name of a directory object need to be specified.
Eg: file_open() creates an object p_target_dir_obj.
where should the p_target_dir_obj be deleted?
Sample PLSQL Code:
FUNCTION file_open(p_target_dir IN VARCHAR2,
p_file_name IN VARCHAR2,
p_write IN BOOLEAN)
RETURN t_file
IS
BEGIN
CREATE DIRECTORY p_target_dir_obj AS p_target_dir --Created Dir object
-- open file
RETURN UTL_FILE.FOPEN(p_target_dir_obj, p_file_name, 'W', 2001);
END file_open;
PROCEDURE trial()
IS
BEGIN
p_error_file := file_open(p_debug_dir,file_name, TRUE);
UTL_FILE.fclose(p_error_file);
END
Can the object be destroyed at the end of file_open function or during the fclose() which is at the end of trial()
Is the object creation required only for passing to UTL_FILE.FOPEN ?
Note:Please ignore if any syntax error
oracle plsql oracle18c
asked Nov 22 at 10:36
Shravani H
112
add a comment |
Starting in Oracle Database 18c, the UTL_FILE_DIR parameter is no longer supported.
Instead, name of a directory object need to be specified.
Eg: file_open() creates an object p_target_dir_obj.
where should the p_target_dir_obj be deleted?
Sample PLSQL Code:
FUNCTION file_open(p_target_dir IN VARCHAR2,
p_file_name IN VARCHAR2,
p_write IN BOOLEAN)
RETURN t_file
IS
BEGIN
CREATE DIRECTORY p_target_dir_obj AS p_target_dir --Created Dir object
-- open file
RETURN UTL_FILE.FOPEN(p_target_dir_obj, p_file_name, 'W', 2001);
END file_open;
PROCEDURE trial()
IS
BEGIN
p_error_file := file_open(p_debug_dir,file_name, TRUE);
UTL_FILE.fclose(p_error_file);
END
Can the object be destroyed at the end of file_open function or during the fclose() which is at the end of trial()
Is the object creation required only for passing to UTL_FILE.FOPEN ?
Note:Please ignore if any syntax error
oracle plsql oracle18c
asked Nov 22 at 10:36
Shravani H
112
3
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58
add a comment |
Starting in Oracle Database 18c, the UTL_FILE_DIR parameter is no longer supported.
Instead, name of a directory object need to be specified.
Eg: file_open() creates an object p_target_dir_obj.
where should the p_target_dir_obj be deleted?
Sample PLSQL Code:
FUNCTION file_open(p_target_dir IN VARCHAR2,
p_file_name IN VARCHAR2,
p_write IN BOOLEAN)
RETURN t_file
IS
BEGIN
CREATE DIRECTORY p_target_dir_obj AS p_target_dir --Created Dir object
-- open file
RETURN UTL_FILE.FOPEN(p_target_dir_obj, p_file_name, 'W', 2001);
END file_open;
PROCEDURE trial()
IS
BEGIN
p_error_file := file_open(p_debug_dir,file_name, TRUE);
UTL_FILE.fclose(p_error_file);
END
Can the object be destroyed at the end of file_open function or during the fclose() which is at the end of trial()
Is the object creation required only for passing to UTL_FILE.FOPEN ?
Note:Please ignore if any syntax error
oracle plsql oracle18c
asked Nov 22 at 10:36
Shravani H
112
Starting in Oracle Database 18c, the UTL_FILE_DIR parameter is no longer supported.
Instead, name of a directory object need to be specified.
Eg: file_open() creates an object p_target_dir_obj.
where should the p_target_dir_obj be deleted?
Sample PLSQL Code:
FUNCTION file_open(p_target_dir IN VARCHAR2,
p_file_name IN VARCHAR2,
p_write IN BOOLEAN)
RETURN t_file
IS
BEGIN
CREATE DIRECTORY p_target_dir_obj AS p_target_dir --Created Dir object
-- open file
RETURN UTL_FILE.FOPEN(p_target_dir_obj, p_file_name, 'W', 2001);
END file_open;
PROCEDURE trial()
IS
BEGIN
p_error_file := file_open(p_debug_dir,file_name, TRUE);
UTL_FILE.fclose(p_error_file);
END
Can the object be destroyed at the end of file_open function or during the fclose() which is at the end of trial()
Is the object creation required only for passing to UTL_FILE.FOPEN ?
Note:Please ignore if any syntax error
oracle plsql oracle18c
oracle plsql oracle18c
asked Nov 22 at 10:36
Shravani H
112
asked Nov 22 at 10:36
Shravani H
112
asked Nov 22 at 10:36
Shravani H
112
asked Nov 22 at 10:36
Shravani H
112
asked Nov 22 at 10:36
Shravani H
112
112
3
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58
add a comment |
3
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58
3
3
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429021%2futl-file-fopen-handling-in-oracle-18c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429021%2futl-file-fopen-handling-in-oracle-18c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
You wouldn't normally create directory objects at runtime, you'd do that once as a maintenance task and then grant privileges on the directory object to the users who need to access it. Your pseudocode sugests you're letting end users pass in an arbitrary path they want to access, which rather circumvents the security that directory objects provide.
– Alex Poole
Nov 22 at 10:58