-
Notifications
You must be signed in to change notification settings - Fork 8
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
BLog login ERROR #13
Comments
Hi, What is your database version?
Please run below and post output:
|
BLOG_UTIL PACKAGE BODY 1 236 21 PLS-00201: identifier
'BLOG_V_POSTS.PUBLISHED_ON' must be declared ERROR 201
BLOG_UTIL PACKAGE BODY 2 0 0 PL/SQL: Compilation unit analysis terminated
ERROR 0
BLOG_V_ARCHIVE_YEAR VIEW 1 0 0 ORA-00942: 表或视图不存在 ERROR 0
BLOG_V_CATEGORIES VIEW 1 0 0 ORA-00942: 表或视图不存在 ERROR 0
BLOG_V_COMMENTS VIEW 1 0 0 ORA-00942: 表或视图不存在 ERROR 0
BLOG_V_POSTS_LAST20 VIEW 1 0 0 ORA-00942: 表或视图不存在 ERROR 0
BLOG_V_TAGS VIEW 1 0 0 ORA-00942: 表或视图不存在 ERROR
…-------------------------------------------------------------------------------------------------
The trird line means : ORA-00942: table or view does not exist
Jari Laine ***@***.***> 于2024年1月23日周二 14:33写道:
Hi,
Please run below and post output
alter package blog_util compile;
select *
from user_errors;
—
Reply to this email directly, view it on GitHub
<#13 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BBRLLBE56RZTUHHHRCJOZCDYP5KS3AVCNFSM6AAAAABCGDJXYOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMBVGM3TIMJWGM>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
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
|
There is issue in view BLOG_V_POSTS when database parameter MAX_STRING_SIZE value is STANDARD. Create view using attached DDL And compile invalid objects.
Run below insert where you replace < admin application id here > part with actual application id
Drop view
Install blog public application again. |
Trank you ,Problem solved, perfect! |
Waiting that bug #12 is fixed from Oracle to continue development. |
ORA-04063: package body "WKSP_AIGOOGLE.BLOG_UTIL" has errors
Technical Info (only available for developers)
is_internal_error: false
ora_sqlcode: -4063
ora_sqlerrm: ORA-04063: package body "WKSP_AIGOOGLE.BLOG_UTIL" has errors
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06508: PL/SQL: could not find program unit being called: "WKSP_AIGOOGLE.BLOG_UTIL"
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC_LOCAL", line 3062
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2823
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2861
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1347
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
component.type: APEX_APPLICATION_PROCESSES
component.id: 53582057650954562157
component.name: Initialize Items
error_backtrace:
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC_LOCAL", line 3062
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2823
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2861
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 34
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS_NATIVE", line 1347
ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3634
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 192
error_statement:
begin blog_util.initialize_items(
p_app_id => :APP_ID
);
end;
The text was updated successfully, but these errors were encountered: