Comments (6)
Hi,
What is your database version?
What is database MAX_STRING_SIZE parameter value?
select name, value
from v$parameter
where name = 'max_string_size';
Please run below and post output:
alter view blog_v_posts compile;
alter package blog_util compile;
select *
from user_errors;
from apex-blog.
from apex-blog.
Hi,
What is your database version?
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
deployed on apex.oracle.com ;
What is database MAX_STRING_SIZE parameter value?
select name, value
from v$parameter
where name = 'max_string_size';
It should be no access permission,get error: Error at line 2/6: ORA-00942: table or view does not exist ,when excute :
select name, value
from v$parameter
where name = 'max_string_size';
from apex-blog.
There is issue in view BLOG_V_POSTS when database parameter MAX_STRING_SIZE value is STANDARD.
Create view using attached DDL
blog_v_posts_fix_issue_13.zip
And compile invalid objects.
alter view blog_v_posts_last20 compile;
alter view blog_v_archive_year compile;
alter view blog_v_comments compile;
alter view blog_v_categories compile;
alter view blog_v_archive_year compile;
alter view blog_v_tags compile;
alter package blog_util compile;
alter package blog_xml compile;
Run below insert where you replace < admin application id here > part with actual application id
insert into blog_settings(display_seq,is_nullable,attribute_name,data_type,attribute_group_message,int_min,int_max,attribute_value) values('30','0','G_ADMIN_APP_ID','STRING','INTERNAL',null,null, <admin application id here>);
Drop view
drop view blog_v_version;
Install blog public application again.
from apex-blog.
Trank you ,Problem solved, perfect!
from apex-blog.
Waiting that bug #12 is fixed from Oracle to continue development.
from apex-blog.
Related Issues (14)
- How can i Insert a image to Blog post? HOT 5
- Errors appears in the App Builder (import): Build Status must be specified. Parse As Schema must be specified. File is not a valid Oracle APEX application export file. HOT 10
- RSS as "raw XML" HOT 20
- OracleText - Error HOT 28
- 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.