how to get the value of a parameter "of OperationBinding" at runtime

Hi
This method is used to retrieve the input value of a parameter of an Operation


    public String viewScannedDocumentAction() {
        String outcome = null;
        Long doctype = null;
        String yer = null;
        DCIteratorBinding scanedDocIter = ADFUtils.findIterator("DocTransDocDtlVoIterator");
        DCIteratorBinding currentIterator = ADFUtils.findIterator("DocTransDocCountIterator");
        OperationBinding opr = getOperation("ExecuteWithParams");
        Row row = currentIterator.getCurrentRow();
        if (row != null) {
         //   Map operationParamsMap = opr.getParamsMap();
            DCInvokeMethod method = (DCInvokeMethod) opr.getOperationInfo();
            if (method != null) {
                DCInvokeMethodDef methodDef = method.getDef();
                if (methodDef != null) {
                    OperationParameter[] operationParameters = null;
                    operationParameters = methodDef.getParameters();
                    if (operationParameters != null) {
                        for (OperationParameter operationParameter : operationParameters) {
                            String argumentName = operationParameter.getName();
                            Object argumentType = operationParameter.getTypeName();
                            Object defaultValue = operationParameter.getValue();                        
                            if (argumentName.equals("p_doc_type")) {
                                doctype = (Long) JSFUtils.resolveExpression((String) defaultValue);
                               
                            } else if (argumentName.equals("p_year")) {
                                yer = (String) JSFUtils.resolveExpression((String) defaultValue);
                               
                            }
                        }
                    }
                }
            }

            if (doctype != null & yer != null) {
                ViewObject vo = scanedDocIter.getViewObject();            
                vo.setNamedWhereClauseParam("p_doc_type", doctype);
                vo.setNamedWhereClauseParam("p_year",yer.replaceAll("\\s", ""));
               String month = (String) row.getAttribute("MonthDisplay");            
                vo.setNamedWhereClauseParam("p_month", month.replaceAll("\\s",""));
                vo.executeQuery();            
                outcome="viewScannedDocument";
            } else {
                JSFUtils.addFacesErrorMessage("Please select document type and a year and press execute first");
            }
        }

        return outcome;
    }

Comments

Anonymous said…
Hello Tarek,

I don't understand below line. It gives me error. Can you please explain it further.

OperationBinding opr = getOperation("ExecuteWithParams");
January 17, 2017 at 8:29 AM
Tarek Fathy said…
getOperation is another method that return OperationBinding
this is the method body
import oracle.binding.OperationBinding;

private OperationBinding getOperation(String oprName){
DCBindingContainer bc = (DCBindingContainer) BindingContext.getCurrent().getCurrentBindingsEntry();
OperationBinding opr = bc.getOperationBinding(oprName);
return opr;
}
January 18, 2017 at 11:42 AM
Post a Comment

Popular posts from this blog

Another user has changed the row with primary key oracle.jbo.Key[12 ].

Image
Try these solutions:  make sure that you check "refresh after insert" and refresh after update" for the primary key column in you entity object. in the application module tab Click the Properties tab and select jbo.locking.mode. Double click the “pessimistic”value next to the property to open the field editor and type “optimistic” over the value.Press enter. if error still exist then you must set "refresh after insert" and refresh after update" as true for all attributes in the entity object another way is to execute the View Object after the commit operation to bring back updated data to ViewObject. For this we need to override the  afterCommit()  of ViewObject class as follows:                  public void afterCommit(TransactionEvent){                         executeQuery();                  ...
Read more

weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck

Integreated weblogic serer cannot be started and retuen this error weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck Solution is simple  just remove the cwallet.sso file and cwallet.sso.lck located in C:\Users\tarek.DHAMAN\AppData\Roaming\JDeveloper\system12.2.1.4.42.190911.2248\o.jdeveloper.rescat2.model Then open jevveloper again and start weblogic again
Read more

Working With File Throgh WebUtill

-------------------------------------------------- Required Configuraion : By default the file transfer is disabled in webutil for a security measure. So, you have to enable File transfer configuration in webutil.cfg file. The webutil.cfg file is located in  forms\server. Open The webuil.cfg file and edit the following parameters : transfer.database.enabled=FALSE   Change To TRUE transfer.appsrv.enabled=FALSE       Change to TRUE WebUtil_File contains APIs to manipulate files and directories on the client. These Functions Or APIs are: Copy_File :  Copies a file Returns a Boolean to indicate success.  Syntax :   Webutil_File.Copy_File(SourceFileName in Varchar2 , Destination In Varchar2) Return Boolean  Example   Declare  vCopied Boolean;  Begin   vCopied :=  Webutil_File.Copy_File('C:\temp\mypic.jpg','X:\destination_folder');  If vCopied = true Then    Message('File copied Successfully');  Else   Message('Error in Copying File');  End if; Delete_File: ...
Read more