AQ$_JMS_TEXT_MESSAGE
464552Nov 2 2005 — edited Mar 6 2006Hi,
I'm currently trying to 'migrate' one of our applications to the 10g Express Edition.
Everything went smoothly and was easy enough.
But then I encountered a problem with one of our pl/sql packages that is accessing the aq$_jms_text_message pl/sql type.
The following piece of code is a stripped down version that re-produces the problem.
<----snip--->
declare
msg sys.aq$_jms_text_message;
begin
msg := sys.aq$_jms_text_message.construct;
end;
<---snip--->
generates
ORA-06550: line 4, column 35:
PLS-00302: component 'CONSTRUCT' must be declared
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
This is also true, if I log on as sys.
I issued the following query to find out what's wrong:
<--- snip --->
select * from all_type_methods where type_name like '%JMS%';
<--- snip --->
and it just returned three lines for AQ$_JMS_HEADER. On the 9.2.0.5 database that we use in production significantly more line were returned and I currently have no access to out 10g development system, but we never had problems on that either.
So my question is: Is this an issue with the 10g Express Edition or is there something else I have to do?
Thanks for any help,
Torsten