Skip to Main Content
Forums

Oracle Database Discussions

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.

Error in Installing DBMS_SUPPORT Package (XE)

abhijit74Nov 12 2008 — edited Nov 12 2008
I am trying to install the DBMS_SUPPORT package on my XE database. I am running XE on Windows XP.
I am getting the following error.

SQL> @D:\OracleExe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\dbmssupp.sql

Package created

Warning: Package body created with compilation errors

SQL> SHOW ERROR
Errors for PACKAGE BODY SYS.DBMS_SUPPORT:

LINE/COL ERROR
-------- ----------------------------------------------------------
35/2 PLS-00103: Encountered the symbol "O3FOUBHI3J3FESPZBDA6Q"

Comments

843844
Not sure, but shouldn't you wrap this piece of code in a4j:region?
WAQ28
Confused..
Look at the code:

<h:selectOneMenu id="symbol" value="#{user.name}" >
<f:selectItem id="b" itemLabel="Symbol" itemValue="symbol" />
<f:selectItem id="a" itemLabel="Code" itemValue="code" />
<a4j:support event="onchange" reRender="re2" />
</h:selectOneMenu>
<h:outputText id = "re2" value="#{user.name}"/>

It works fine and update the text with selected value from the menu.
But if i change the last line from output text to input, as:

<h:inputText id = "re2" value="#{user.name}"/>

Sometimes it work and sometimes not.
Strange, isn't it?
Any idea?
WAQ28
My problem has not been solved yet..
843844
Try their own forum over there at JBoss.org. The RichFaces/Ajax4jsf boys are walking over there.
losintikfos
BalusC wrote:
Not sure, but shouldn't you wrap this piece of code in a4j:region?
Sure! the code above should be wraped in a4j:region.
losintikfos
WAQ28 wrote:
Confused..
Look at the code:

<h:selectOneMenu id="symbol" value="#{user.name}" >
<f:selectItem id="b" itemLabel="Symbol" itemValue="symbol" />
<f:selectItem id="a" itemLabel="Code" itemValue="code" />
<a4j:support event="onchange" reRender="re2" />
</h:selectOneMenu>
<h:outputText id = "re2" value="#{user.name}"/>

It works fine and update the text with selected value from the menu.
But if i change the last line from output text to input, as:

<h:inputText id = "re2" value="#{user.name}"/>

Sometimes it work and sometimes not.
Strange, isn't it?
Any idea?
Implement your a4j eventListener like this; 
<a4j:region selfRendered="true" ajaxListener="#{yourbean.a4jMethod}" id="text">
       <h:selectOneMenu id="symbol" value="#{user.name}" >
       <f:selectItem id="b" itemLabel="Symbol" itemValue="symbol" />
       <f:selectItem id="a" itemLabel="Code" itemValue="code" />
       <a4j:support  reRender="re2" actionListener="#{yourBean.a4jMethod}" event="onchange"/>
       </h:selectOneMenu> 
</a4j:region>
<h:outputText id = "re2" value="#{user.name}"/>
WAQ28
Thanks for the reply

....But what does the follwoing statement do and when does it executes? 
ajaxListener="#{yourbean.a4jMethod}"
losintikfos
Will suggest you do some background research on a4j. But as your question relates, ajaxListener listens to the AjaxEvent method within your bean with which you want to invoke.

For Example
*ajaxListener="#{yourbean.a4jMethod}"* Will asynchronously execute an AjaxEven method as shown below;

{code}public class yourbean{

public yourbean{ }

//AjaxEvent method
public a4jMethod(AjaxEvent arg1){
if(arg1 !=null){
//TODO
}
}
}{code}
WAQ28
then what is the use of actionListener="#{yourBean.a4jMethod}" which u defined in <a4j:support>? Which one executes first?
losintikfos
WAQ28 wrote:
then what is the use of actionListener="#{yourBean.a4jMethod}" which u defined in <a4j:support>? Which one executes first?
if you using the example as shown above, then obviously the a4j:suppot should look like this; 
<a4j:support  reRender="re2"  event="onchange"/>
WAQ28
Thanks all, problem solved.
One last question. I m still confused about this ajaxRegion which you told me to use, because before that i worked with simple example in which i updated outputText without using this region. So actually where is the difference? what does this region do?
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 10 2008
Added on Nov 12 2008
#database, #database-installation, #installation, #support
6 comments
631 views