How to import APEX application using SQLPLUS
I have build an application in APEX 18 on my Development environment. Now I want to deploy the whole application on Test environment. I have already exported the file from application builder, so I have the export sql with me.
My question is: Is there any way that I can import this file into my test environment using SQLPLUS and not by the Import functionality on application builder.
Can you please let me know the way to import using sqlplus.
Thanks,
Abha..
oracle-apex
asked Nov 23 '18 at 13:56
AbhaAbha
588
add a comment |
I have build an application in APEX 18 on my Development environment. Now I want to deploy the whole application on Test environment. I have already exported the file from application builder, so I have the export sql with me.
My question is: Is there any way that I can import this file into my test environment using SQLPLUS and not by the Import functionality on application builder.
Can you please let me know the way to import using sqlplus.
Thanks,
Abha..
oracle-apex
asked Nov 23 '18 at 13:56
AbhaAbha
588
add a comment |
I have build an application in APEX 18 on my Development environment. Now I want to deploy the whole application on Test environment. I have already exported the file from application builder, so I have the export sql with me.
My question is: Is there any way that I can import this file into my test environment using SQLPLUS and not by the Import functionality on application builder.
Can you please let me know the way to import using sqlplus.
Thanks,
Abha..
oracle-apex
asked Nov 23 '18 at 13:56
AbhaAbha
588
I have build an application in APEX 18 on my Development environment. Now I want to deploy the whole application on Test environment. I have already exported the file from application builder, so I have the export sql with me.
My question is: Is there any way that I can import this file into my test environment using SQLPLUS and not by the Import functionality on application builder.
Can you please let me know the way to import using sqlplus.
Thanks,
Abha..
oracle-apex
oracle-apex
asked Nov 23 '18 at 13:56
AbhaAbha
588
asked Nov 23 '18 at 13:56
AbhaAbha
588
asked Nov 23 '18 at 13:56
AbhaAbha
588
asked Nov 23 '18 at 13:56
AbhaAbha
588
asked Nov 23 '18 at 13:56
AbhaAbha
588
588
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Definitely. It's well documented here:
https://docs.oracle.com/database/apex-18.2/AEAPI/Import-Script-Examples.htm
Here's what I'd typically have for an install script:
declare
c_workspace constant apex_workspaces.workspace%type := 'DEMO';
c_app_id constant apex_applications.application_id%type := 20000;
c_app_alias constant apex_applications.alias%type := 'MYDEMO';
l_workspace_id apex_workspaces.workspace_id%type;
begin
apex_application_install.clear_all;
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = c_workspace;
apex_application_install.set_workspace_id(l_workspace_id);
apex_application_install.set_application_id(c_app_id);
apex_application_install.set_application_alias(c_app_alias);
apex_application_install.generate_offset;
end;
/
@f10000.sql
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
add a comment |
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%2f53448035%2fhow-to-import-apex-application-using-sqlplus%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Definitely. It's well documented here:
https://docs.oracle.com/database/apex-18.2/AEAPI/Import-Script-Examples.htm
Here's what I'd typically have for an install script:
declare
c_workspace constant apex_workspaces.workspace%type := 'DEMO';
c_app_id constant apex_applications.application_id%type := 20000;
c_app_alias constant apex_applications.alias%type := 'MYDEMO';
l_workspace_id apex_workspaces.workspace_id%type;
begin
apex_application_install.clear_all;
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = c_workspace;
apex_application_install.set_workspace_id(l_workspace_id);
apex_application_install.set_application_id(c_app_id);
apex_application_install.set_application_alias(c_app_alias);
apex_application_install.generate_offset;
end;
/
@f10000.sql
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
add a comment |
Definitely. It's well documented here:
https://docs.oracle.com/database/apex-18.2/AEAPI/Import-Script-Examples.htm
Here's what I'd typically have for an install script:
declare
c_workspace constant apex_workspaces.workspace%type := 'DEMO';
c_app_id constant apex_applications.application_id%type := 20000;
c_app_alias constant apex_applications.alias%type := 'MYDEMO';
l_workspace_id apex_workspaces.workspace_id%type;
begin
apex_application_install.clear_all;
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = c_workspace;
apex_application_install.set_workspace_id(l_workspace_id);
apex_application_install.set_application_id(c_app_id);
apex_application_install.set_application_alias(c_app_alias);
apex_application_install.generate_offset;
end;
/
@f10000.sql
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
add a comment |
Definitely. It's well documented here:
https://docs.oracle.com/database/apex-18.2/AEAPI/Import-Script-Examples.htm
Here's what I'd typically have for an install script:
declare
c_workspace constant apex_workspaces.workspace%type := 'DEMO';
c_app_id constant apex_applications.application_id%type := 20000;
c_app_alias constant apex_applications.alias%type := 'MYDEMO';
l_workspace_id apex_workspaces.workspace_id%type;
begin
apex_application_install.clear_all;
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = c_workspace;
apex_application_install.set_workspace_id(l_workspace_id);
apex_application_install.set_application_id(c_app_id);
apex_application_install.set_application_alias(c_app_alias);
apex_application_install.generate_offset;
end;
/
@f10000.sql
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
Definitely. It's well documented here:
https://docs.oracle.com/database/apex-18.2/AEAPI/Import-Script-Examples.htm
Here's what I'd typically have for an install script:
declare
c_workspace constant apex_workspaces.workspace%type := 'DEMO';
c_app_id constant apex_applications.application_id%type := 20000;
c_app_alias constant apex_applications.alias%type := 'MYDEMO';
l_workspace_id apex_workspaces.workspace_id%type;
begin
apex_application_install.clear_all;
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = c_workspace;
apex_application_install.set_workspace_id(l_workspace_id);
apex_application_install.set_application_id(c_app_id);
apex_application_install.set_application_alias(c_app_alias);
apex_application_install.generate_offset;
end;
/
@f10000.sql
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
edited Nov 23 '18 at 15:23
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
answered Nov 23 '18 at 14:18
Adrian PAdrian P
46137
46137
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
add a comment |
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Thanks. I tried to follow all the steps for "Import Application with Specified Application ID" in the same DEV environment, but I am getting following error : ERROR at line 1: ORA-20001: Package variable g_security_group_id must be set. ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843 ORA-06512: at "APEX_180100.WWV_FLOW_API", line 3276 ORA-06512: at line 2 Here, I am just trying to import the application on same workspace sam schema but with a different application id.
– Abha
Nov 23 '18 at 14:29
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Updated the answer with code.
– Adrian P
Nov 23 '18 at 15:24
Thanks this works !
– Abha
Nov 27 '18 at 9:21
Thanks this works !
– Abha
Nov 27 '18 at 9:21
add a comment |
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.
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%2f53448035%2fhow-to-import-apex-application-using-sqlplus%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
