Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error running prepared statement, ORA-20000 MDSYS.RDF_MATCH_IMPL_T

720065Aug 31 2009 — edited Sep 1 2009
Hello,

We are trying to build a prepared statement of the following format:

select s1, s2 from table(SEM_MATCH( *:parameter* ,
SEM_Models('int_data_modeling'), null,
SEM_ALIASES(SEM_ALIAS('dm','http://www.credit-suisse.com/zzzzzzzz#')), null))
where t=(select max(t) from
table(SEM_MATCH( '(?a <http://www.credit-suisse.com/zzzzzzzz#Timestamp> ?t)
(?a rdf:object <http://www.credit-suisse.com/zzzzzzz#Conceptual_Model>)',
SEM_Models('int_data_modeling'), null, null, null))) group by s1,s2 order by s1,s2

later, we replace :parameter with the following string

'(<http://www.credit-suisse.com/zzzzzzz/aaaa> rdf:type <http://www.credit-suisse.com/zzzzz#iiiii>)
(?a rdf:subject <http://www.credit-suisse.com/zzzzzz/bbbbb>) (?a dm:Timestamp ?t) (?p dm:Comment ?s1)
(<http://www.credit-suisse.com/zzzzzz/aaaa> dm:Author ?s2)'

When we run the query as a simple one (not prepared), it works fine. However, when we executed as a prepared one, we get the following error:

ORA-06512: at line 4
". ;
MDMS0001: Generic Error "ORA-20000: RDF_MATCH Query pattern must be a non-null compile-time constant.
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 31
ORA-06512: at line 4
".

Do you know what this error mean? Is the syntax of the prepared statement correct?

I would really appreciate your help.

Regards,
Magdalini

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 29 2009
Added on Aug 31 2009
4 comments
2,651 views