Skip to Main Content
Forums

SQL & PL/SQL

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!

which creating TableFunction method is better?

Aketi JyuuzouNov 2 2011 — edited Nov 14 2011
There are 2 method creating TableFunction.
My question is which is better ?:|

I think method1 is better B-)
Because when export/import each schema to other schema method2 causes "ORA-02304: invalid object identifier literal"
448115

But I often see method2 only :-(
http://psoug.org/reference/pipelined.html
http://www.oracle-base.com/articles/9i/PipelinedTableFunctions9i.php

Comments

Ruben Rodriguez

Hello,

You can add an inputText and an inputDate.

<af:panelLabelAndMessage label="Label 1" id="plam1">

     <af:inputText simple="true" id="it1" partialTriggers="id1">

     <af:inputDate label="Label 1" simple="true" id="id1" autoSubmit="true" styleClass="myClass"

                            valueChangeListener="#{testBean.valueChangeInputDate}"/>

</af:panelLabelAndMessage>

Then hide inputDate label using simple="true" and content in the skin:

af|inputDate.myClass::content{

    display:none;

}

you have to pass the value to the inputtext and you can do it in the valueChangeListener.

    public void valueChangeDate(ValueChangeEvent valueChangeEvent) {

        Object o = valueChangeEvent.getNewValue();

        RichInputText rit = (RichInputText)findComponentInRoot("it1");

        rit.setValue(o);

    }

regards,

Ruben

2 people found this helpful
dvohra21

I need a textbox which can insert words or a date

In af:inputDate words or a date may be specified without selecting a date from the calendar popup.

Ashish Awasthi

User

Go with what @"Ruben Rodriguez" suggested

Ashish

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

Post Details

Locked on Dec 12 2011
Added on Nov 2 2011
6 comments
509 views