Comments (10)
I'm not yet able to find what causes this because import works when running e.g. from SQLcl.
Workaround is use e.g. SQLcl to install applications.
Here is example how import applications:
set serveroutput on size unlimited;
-- Import blog admin application
begin
apex_application_install.generate_offset;
apex_application_install.set_auto_install_sup_obj( p_auto_install_sup_obj => true );
-- Set your workspace name
apex_application_install.set_workspace( '<WORKSPACE_NAME>' );
-- Set your schema name
apex_application_install.set_schema( '<SCHEMA_NAME>' );
-- Set application id
apex_application_install.set_application_id( 402 );
end;
/
@blog-administration-latest.sql;
-- Import blog public application
begin
apex_application_install.generate_offset;
apex_application_install.set_auto_install_sup_obj( p_auto_install_sup_obj => true );
-- Set your workspace name
apex_application_install.set_workspace( '<WORKSPACE_NAME>' );
-- Set your schema name
apex_application_install.set_schema( '<SCHEMA_NAME>' );
-- Set application id
apex_application_install.set_application_id( 401 );
end;
/
@blog-public-pages-latest.sql;
-- Query errors
select *
from user_errors
;
from apex-blog.
It seems splitted export import works.
You can download whole repository.
Go to repository home page and click green "Code" button. Click "Download ZIP".
Extract ZIP and then go extracted folder -> APEX.
Zip folder blog_administration and create another Zip from folder blog_public_pages.
You can now import those created Zip files using APEX builder. Remember import first Zip containing blog_administration,
from apex-blog.
It seems splitted export import works. You can download whole repository. Go to repository home page and click green "Code" button. Click "Download ZIP".
Extract ZIP and then go extracted folder -> APEX. Zip folder blog_administration and create another Zip from folder blog_public_pages. You can now import those created Zip files using APEX builder. Remember import first Zip containing blog_administration,
Thank you for your help. I've follow the above instructions but this error appears:
Application parsing schema must have role CTXAPP or execute privilege to package CTX_DDL.
Could you please help how I can give Application parsing schema role CTXAPP ?... I'm still new in Oracle DBA :( ....
from apex-blog.
Connect to DB as SYS and grant CTXAPP role to schema associated to your APEX workspace.
grant ctxapp to <schema name>;
from apex-blog.
Unfortunately you are hitting another APEX bug 35410651 that is fixed in latest APEX 23.1 patch set bundle 35283657. You should apply that that patch before installing applications.
Or workaround is run supporting objects database_objects.sql scripts using e.g. SQLcl when connected to application parsing schema.
from apex-blog.
Hi @jariolaine,
Thank you for your reply.
I follows your instructions as above but appears this error:
Error report -
ORA-06550: line 2, column 3:
PLS-00201: identifier 'APEX_APPLICATION_INSTALL.GENERATE_OFFSET' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
ORA-06550: line 3, column 3:
PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_AUTO_INSTALL_SUP_OBJ' must be declared
ORA-06550: line 3, column 3:
PL/SQL: Statement ignored
ORA-06550: line 5, column 3:
PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_WORKSPACE' must be declared
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
ORA-06550: line 7, column 3:
PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_SCHEMA' must be declared
ORA-06550: line 7, column 3:
PL/SQL: Statement ignored
ORA-06550: line 9, column 3:
PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_APPLICATION_ID' must be declaredORA-06550: line 9, column 3:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: Refer to the following PL/SQL messages for more
information about the error.
More Details :
https://docs.oracle.com/error-help/db/ora-06550/
https://docs.oracle.com/error-help/db/pls-00201/
--application/set_environment
from apex-blog.
Have you connected right database and user? Errors indicate that database where you have connected doesn't have APEX installed.
Also check that user you use is assigned to APEX workspace where you going to import applications.
from apex-blog.
I managed identify problem. It seems when including Copyright Banner application export is corrupted. This is APEX bug.
from apex-blog.
Issue is fixed in latest version.
from apex-blog.
Thank you. my 'grant CTXAPP' problem solved. but appears new issue in blog_administration only & it's running as below screenshot:
Note: blog_public_pages was succussed in installation steps...
Please help me.
from apex-blog.
Related Issues (14)
- How can i Insert a image to Blog post? HOT 5
- RSS as "raw XML" HOT 20
- OracleText - Error HOT 28
- BLog login ERROR HOT 6
- Error with new constant handling and translated app HOT 16
- Application Item G_DATE_FORMAT is missing in Public App HOT 5
- Application Language Derived From always English HOT 2
- Are you interested in the (german) translated app? HOT 3
- APEX 21.2 - Font APEX Icon "fa-rss-square" is empty (?) HOT 4
- Enhancement - CKEditor5 HOT 1
- Post pagination incorrect HOT 1
- Oracle Text error: DRG-10599: column is not indexed HOT 1
- Installation error for "apex_blog_22.2.4.20230518" HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from apex-blog.