Often error messages like "attempt to set a parametername that does not occur in the SQL" and "Missing IN or OUT parameterat index" are caused by developers...
Often error messages like "attempt to set a parametername that does not occur in the SQL" and "Missing IN or OUT parameterat index" are caused by developers mixing required and optional bindvariables in their SQL queries WHERE clause. If you used bind variables in ADFBusiness Components SQL queries, make sure the bind variables are set to required. Bind variables that aremarked as optional are only good to be used in View Criterias. In a future version of Oracle JDeveloper,...
Often error messages like "attempt to set a parametername that does not occur in the SQL" and "Missing IN or OUT parameterat index" are caused by developers mixing required and optional bindvariables...
View Objects can have UI hints defined in their General category. For example, you may want to set the Display Name, Display Name (Plural) and Description on...
View Objects can have UI hints defined in their General category. For example, you may want to set the Display Name, Display Name (Plural) and Description on Employees View Object that is based on an Employees entity representing the Employees table in the HR database sample schema. The page snippet below shows how you can access the UI hints on a View Object to display them a header information on an page. <af:panelGroupLayout id="pgl2"layout="horizontal">...
View Objects can have UI hints defined in their General category. For example, you may want to set the Display Name, Display Name (Plural) and Description on Employees View Object that is based on an...
Groovyis a scripting language that can be used in the context of ADF BC. Itsimplifies Java object access and method execution. Basically everything youcould...
Groovyis a scripting language that can be used in the context of ADF BC. Itsimplifies Java object access and method execution. Basically everything youcould access from Java you can access from Groovy. If logging is needed in yourGroovy scripting, then this can be achieved using the ADF Logger as shown below.Just add script similar to this into the Groovy code are (e..g when workingwith custom entity validators) //log information to console.Create a logger instance for //the...
Groovyis a scripting language that can be used in the context of ADF BC. Itsimplifies Java object access and method execution. Basically everything youcould access from Java you can access...
The use case for this sample has been posted on OTN asfollows: "How to define entity validation for the Salary attribute of the Employees table so that pay...
The use case for this sample has been posted on OTN asfollows: "How to define entity validation for the Salary attribute of the Employees table so that pay raises goingbeyond the cumulated salary budget for a departments throws an exception".The logic for this is as follows: AvailableBudget – (AllSalariesInDepartment + newEmployeeSalar)+ currentEmployeeSalary < 0 The available budget is compared to all salaries paid in adepartment. Chances are that some salaries have been...
The use case for this sample has been posted on OTN asfollows: "How to define entity validation for the Salary attribute of the Employees table so that pay raises goingbeyond the cumulated...