6 Replies Latest reply on Oct 15, 2016 6:03 PM by yenier

Error to granting privileges to execute SPARQL 1.1 Federated queries

yenier Oct 13, 2016 4:33 PM

Dear all,

I have a problem with executing the following statement:

grant execute on mdsys.sparql_service to rdfuser;
grant execute on mdsys.sdo_sem_http_ctx to rdfuser;

Error:

ORA-04042: procedure, function, package, or package body does not exist

I checked on the Functions and Packages folders of MDSYS user and the SPARQL_SERVICE function and the SDO_SEM_HTTP_CTX package aren't found.

I don't know where the problem is. I created the rdfuser user following the steps in Oracle® Spatial and Graph RDF Semantic Graph Developer's Guide.

Thanks in advance,

Yenier

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

Go to original post