-
1. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
alwu-Oracle Oct 14, 2016 4:23 PM (in response to yenier)Hi Yenier,
Are you using 12.1.0.2? Can you please run a desc command as follows?
[oracle@bigdatalite conf]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 14 12:24:53 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> desc mdsys.sparql_service;
FUNCTION mdsys.sparql_service RETURNS ANYDATASET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUERY VARCHAR2 IN
ENDPOINT VARCHAR2 IN
VARIABLES VARCHAR2 IN
PUSHED_RESULTS REF CURSOR IN DEFAULT
JOIN_VARS VARCHAR2 IN DEFAULT
OPTIONS VARCHAR2 IN DEFAULT
Thanks,
Zhe Wu
-
2. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
yenier Oct 14, 2016 4:29 PM (in response to alwu-Oracle)Hi Zhe Wu:
The installed version of Oracle is 12c, there is the problem.
Thank you very much,
Yenier
-
3. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
alwu-Oracle Oct 14, 2016 5:08 PM (in response to yenier)Hi Yenier,
Did the following command return any errors?
SQL> desc mdsys.sparql_service;
If not, can you run the grant commands in the same SQL*Plus session?
Thanks,
Zhe Wu -
4. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
yenier Oct 14, 2016 5:16 PM (in response to alwu-Oracle)Hi Zhe Wu:
Yes, this command returns error.
sparql_service is not found in MDSYS user.
Thanks,
Yenier
-
5. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
alwu-Oracle Oct 14, 2016 6:20 PM (in response to yenier)Hi Yenier,
How about running the following command:
select count(1) from mdsys.rdf_value$ where rownum <= 1;
Thanks,
Zhe
-
6. Re: Error to granting privileges to execute SPARQL 1.1 Federated queries
yenier Oct 15, 2016 6:03 PM (in response to alwu-Oracle)Hi Zhe:
I will send you the screen-shoots about sequences.
- I running the SQL Plus program:
- Executing desc mdsys.sparql_service;
- Executing select count(1) from mdsys.rdf_value$ where rownum <= 1;
I'm thinking to remove the current Oracle version and to install Oracle 12.1.0.2, available in http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html.
Thank you very much,
Yenier