Skip to Main Content
Forums

Oracle Database Express Edition (XE)

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sys.aq$_jms_text_message PLS-00302: component 'SET_USERID' must be declared

user11135387Sep 15 2014 — edited Sep 16 2014

Hi.

I have some AQ-related PL/SQL that compiles fine on Oracle 11g, but have several errors or failures on XE 11g. I think I must be missing some grants or something.

These are the grants I made:

-- grant execute on dbms_aq to myuser

-- grant execute on dbms_aqin to myuser

-- grant select on sys.aq$aq_srvntfn_table to myuser

-- dbms_aqadm.grant_system_privilege('ENQUEUE_ANY','myuser',false)

-- dbms_aqadm.grant_system_privilege('DEQUEUE_ANY','myuser',false)

This grant fails, but I don't think it's relevant:

grant select on sys.aq$aq_srvntfn_table_1 to myuser

                    *

ERROR at line 1:

ORA-00942: table or view does not exist

PL/SQL package with ordinary sys.aq$_jms_text_message code, which compiles fine on 11g, gets errors like on XE:

l_message := sys.aq$_jms_text_message( header=>null/*sys.aq$_jms_header*/, text_len=>length(trim(fname_in)), text_vc=>trim(fname_in), text_lob=>null ) ;

l_message.set_userid (c_user ) ;

PLS-00302: component 'SET_USERID' must be declared

PLS-00302: component 'SET_STRING_PROPERTY' must be declared


Any ideas what I'm missing in XE? TIA

Comments

798906
I think by default jdb will use the hostname of the local machine to determine an ip address rather than localhost or 127.0.0.1. In your case this is ECIL01 so you probably just need to add that hostname to your hosts file. But also make sure that your firewall is not blocking it.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 14 2014
Added on Sep 15 2014
2 comments
1,378 views