My APEX stuff cor_dashboard in in 19.2 APEX Version
robertocapancioni / apex Goto Github PK
View Code? Open in Web Editor NEWMy APEX stuff
apex's Introduction
apex's People
Contributors
Watchers
Forkers
faggionapex's Issues
Failed to create views due to ORA-01417
Hi @robertocapancioni
I ran the Installation Script (supporting objects) and got errors ORA-0141.
I'm running this on Oracle XE 11gR2
create or replace view aut_users_groups_vw as
select
users_groups.id users_group_id,
users_groups.created users_group_created,
users_groups.created_by users_group_created_by,
users_groups.updated users_group_updated,
users_groups.updated_by users_group_updated_by,
users.id user_id,
users.name user_name,
users.description user_description,
users.created user_created,
users.created_by user_created_by,
users.updated user_updated,
users.updated_by user_updated_by,
groups.id group_id,
groups.name group_name,
groups.description group_description,
groups.created group_created,
groups.created_by group_created_by,
groups.updated group_updated,
groups.updated_by group_updated_by
from
aut_users_groups users_groups,
aut_users users,
aut_groups groups
where
users_groups.user_id(+) = users.id and
users_groups.group_id(+) = groups.id
Error report -
ORA-01417: a table may be outer joined to at most one other table
01417. 00000 - "a table may be outer joined to at most one other table"
*Cause: a.b (+) = b.b and a.c (+) = c.c is not allowed
*Action: Check that this is really what you want, then join b and c first in a view.
And these 2 views have the same error:
aut_groups_roles_vw
aut_objects_vw
And these two have errors too (different error):
Error starting at line : 439 in command -
create or replace view aut_authorizations_vw as
select
authorizations.id authorization_id,
authorizations.name authorization_name,
authorizations.description authorization_description,
authorizations.created authorization_created,
authorizations.created_by authorization_created_by,
authorizations.updated authorization_updated,
authorizations.updated_by authorization_updated_by,
roles.id role_id,
roles.name role_name,
roles.description role_description,
roles.created role_created,
roles.created_by role_created_by,
roles.updated role_updated,
roles.updated_by role_updated_by,
privileges.id privilege_id,
privileges.name privilege_name,
privileges.description privilege_description,
privileges.created privilege_created,
privileges.created_by privilege_created_by,
privileges.updated privilege_updated,
privileges.updated_by privilege_updated_by,
objects.id object_id,
objects.name object_name,
objects.description object_description,
objects.created object_created,
objects.created_by object_created_by,
objects.updated object_updated,
objects.updated_by object_updated_by,
type_object.id type_object_id,
type_object.name type_object_name,
type_object.description type_object_description,
type_object.created type_object_created,
type_object.created_by type_object_created_by,
type_object.updated type_object_updated,
type_object.updated_by type_object_updated_by,
applications.id application_id,
applications.name application_name,
applications.description application_description,
applications.created application_created,
applications.created_by application_created_by,
applications.updated application_updated,
applications.updated_by application_updated_by
from
aut_authorizations authorizations,
aut_roles roles,
aut_privileges privileges,
aut_objects objects,
aut_type_object type_object,
aut_applications applications
where
objects.application_id(+) = applications.id and
objects.type_object_id(+) = type_object.id and
authorizations.role_id(+) = roles.id and
authorizations.object_id(+) = objects.id and
authorizations.privilege_id(+) = privileges.id
Error report -
ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
Error starting at line : 498 in command -
create or replace view aut_all_vw as
select
authorizations.id authorization_id,
authorizations.name authorization_name,
authorizations.description authorization_description,
authorizations.created authorization_created,
authorizations.created_by authorization_created_by,
authorizations.updated authorization_updated,
authorizations.updated_by authorization_updated_by,
roles.id role_id,
roles.name role_name,
roles.description role_description,
roles.created role_created,
roles.created_by role_created_by,
roles.updated role_updated,
roles.updated_by role_updated_by,
privileges.id privilege_id,
privileges.name privilege_name,
privileges.description privilege_description,
privileges.created privilege_created,
privileges.created_by privilege_created_by,
privileges.updated privilege_updated,
privileges.updated_by privilege_updated_by,
objects.id object_id,
objects.name object_name,
objects.description object_description,
objects.created object_created,
objects.created_by object_created_by,
objects.updated object_updated,
objects.updated_by object_updated_by,
type_object.id type_object_id,
type_object.name type_object_name,
type_object.description type_object_description,
type_object.created type_object_created,
type_object.created_by type_object_created_by,
type_object.updated type_object_updated,
type_object.updated_by type_object_updated_by,
applications.id application_id,
applications.name application_name,
applications.description application_description,
applications.created application_created,
applications.created_by application_created_by,
applications.updated application_updated,
applications.updated_by application_updated_by,
users_groups.id users_group_id,
users_groups.created users_group_created,
users_groups.created_by users_group_created_by,
users_groups.updated users_group_updated,
users_groups.updated_by users_group_updated_by,
users.id user_id,
users.name user_name,
users.description user_description,
users.created user_created,
users.created_by user_created_by,
users.updated user_updated,
users.updated_by user_updated_by,
groups.id group_id,
groups.name group_name,
groups.description group_description,
groups.created group_created,
groups.created_by group_created_by,
groups.updated group_updated,
groups.updated_by group_updated_by,
groups_roles.id groups_role_id,
groups_roles.created groups_role_created,
groups_roles.created_by groups_role_created_by,
groups_roles.updated groups_role_updated,
groups_roles.updated_by groups_role_updated_by
from
aut_authorizations authorizations,
aut_roles roles,
aut_privileges privileges,
aut_objects objects,
aut_type_object type_object,
aut_applications applications,
aut_users_groups users_groups,
aut_users users,
aut_groups groups,
aut_groups_roles groups_roles
where
users_groups.user_id(+) = users.id and
users_groups.group_id(+) = groups.id and
groups_roles.group_id(+) = groups.id and
groups_roles.role_id(+) = roles.id and
objects.application_id(+) = applications.id and
objects.type_object_id(+) = type_object.id and
authorizations.role_id(+) = roles.id and
authorizations.object_id(+) = objects.id and
authorizations.privilege_id(+) = privileges.id
Error report -
ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
Then these:
Error starting at line : 925 in command -
create or replace view aut_authorizations_vw as
select
authorizations.id authorization_id,
authorizations.name authorization_name,
authorizations.description authorization_description,
authorizations.created authorization_created,
authorizations.created_by authorization_created_by,
authorizations.updated authorization_updated,
authorizations.updated_by authorization_updated_by,
roles.id role_id,
roles.name role_name,
roles.description role_description,
roles.created role_created,
roles.created_by role_created_by,
roles.updated role_updated,
roles.updated_by role_updated_by,
privileges.id privilege_id,
privileges.name privilege_name,
privileges.description privilege_description,
privileges.created privilege_created,
privileges.created_by privilege_created_by,
privileges.updated privilege_updated,
privileges.updated_by privilege_updated_by,
objects.id object_id,
objects.name object_name,
objects.description object_description,
objects.created object_created,
objects.created_by object_created_by,
objects.updated object_updated,
objects.updated_by object_updated_by,
type_object.id type_object_id,
type_object.name type_object_name,
type_object.description type_object_description,
type_object.created type_object_created,
type_object.created_by type_object_created_by,
type_object.updated type_object_updated,
type_object.updated_by type_object_updated_by,
applications.id application_id,
applications.name application_name,
applications.description application_description,
applications.created application_created,
applications.created_by application_created_by,
applications.updated application_updated,
applications.updated_by application_updated_by
from
aut_authorizations authorizations,
aut_roles roles,
aut_privileges privileges,
aut_objects objects,
aut_type_object type_object,
aut_applications applications
where
objects.application_id = applications.id and
objects.type_object_id = type_object.id and
authorizations.role_id = roles.id and
authorizations.object_id = objects.id and
authorizations.privilege_id = privileges.id
Error report -
ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
Error starting at line : 984 in command -
create or replace view aut_all_vw as
select
authorizations.id authorization_id,
authorizations.name authorization_name,
authorizations.description authorization_description,
authorizations.created authorization_created,
authorizations.created_by authorization_created_by,
authorizations.updated authorization_updated,
authorizations.updated_by authorization_updated_by,
roles.id role_id,
roles.name role_name,
roles.description role_description,
roles.created role_created,
roles.created_by role_created_by,
roles.updated role_updated,
roles.updated_by role_updated_by,
privileges.id privilege_id,
privileges.name privilege_name,
privileges.description privilege_description,
privileges.created privilege_created,
privileges.created_by privilege_created_by,
privileges.updated privilege_updated,
privileges.updated_by privilege_updated_by,
objects.id object_id,
objects.name object_name,
objects.description object_description,
objects.created object_created,
objects.created_by object_created_by,
objects.updated object_updated,
objects.updated_by object_updated_by,
type_object.id type_object_id,
type_object.name type_object_name,
type_object.description type_object_description,
type_object.created type_object_created,
type_object.created_by type_object_created_by,
type_object.updated type_object_updated,
type_object.updated_by type_object_updated_by,
applications.id application_id,
applications.name application_name,
applications.description application_description,
applications.created application_created,
applications.created_by application_created_by,
applications.updated application_updated,
applications.updated_by application_updated_by,
users_groups.id users_group_id,
users_groups.created users_group_created,
users_groups.created_by users_group_created_by,
users_groups.updated users_group_updated,
users_groups.updated_by users_group_updated_by,
users.id user_id,
users.name user_name,
users.description user_description,
users.created user_created,
users.created_by user_created_by,
users.updated user_updated,
users.updated_by user_updated_by,
groups.id group_id,
groups.name group_name,
groups.description group_description,
groups.created group_created,
groups.created_by group_created_by,
groups.updated group_updated,
groups.updated_by group_updated_by,
groups_roles.id groups_role_id,
groups_roles.created groups_role_created,
groups_roles.created_by groups_role_created_by,
groups_roles.updated groups_role_updated,
groups_roles.updated_by groups_role_updated_by
from
aut_authorizations authorizations,
aut_roles roles,
aut_privileges privileges,
aut_objects objects,
aut_type_object type_object,
aut_applications applications,
aut_users_groups users_groups,
aut_users users,
aut_groups groups,
aut_groups_roles groups_roles
where
users_groups.user_id = users.id and
users_groups.group_id = groups.id and
groups_roles.group_id = groups.id and
groups_roles.role_id = roles.id and
objects.application_id = applications.id and
objects.type_object_id = type_object.id and
authorizations.role_id = roles.id and
authorizations.object_id = objects.id and
authorizations.privilege_id = privileges.id
Error report -
ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
Thanks
-Gaspar
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.