Tarek Fathy

تاسيس الشركات ذات المسؤلية المحدودة

2011-12-22T13:09:00.000+02:00

http://www.lawforall.info/index.pl/incorporation_of_llcs

error in internet explorer

2011-12-19T18:04:00.000+02:00

http://www.oratraining.com/blog/2010/04/internet-explorer-has-closed-this-webpage-to-help-protect-your-computer/

how to create dynamic menu based on table

2011-12-01T10:06:00.002+02:00

http://biemond.blogspot.com/2008/11/dynamic-menu-based-on-roles-database.html

How to create fixed list in ADF

2011-10-16T07:31:00.004+02:00

1- create a read only view object based on a query

example:

SELECT 'Reject' DESCRIPTION

,'BCK' CODE
FROM DUAL
UNION ALL
SELECT 'Accept' DESCRIPTION
,'GM' CODE
FROM DUAL

2- in the base view object (your main view object that you want to add the fixed list) add a new Transient attribute for example "Manager_descision"

3- Create view accessor in the main view abject that referes to the readonly query VO

4- associat a LOV to your Transient attribute that is based on your view accessor

Note that you must add list return value to retrun the value to the database attribute to save the returned value in the DB

5- in your page drag and drop the transient attribute from the data control to the page as selectOneChoceList

6- go to the page Bindings and select the attribute in the strucure window and right click to add attribute names and attribute values

6- save and run the page

The JRE was not found in directory

2011-06-14T10:36:00.000+02:00

The JRE was not found in directory G:\weblogicServer\jdk160_21. (JAVA_HOME)
Please edit your environment and set the JAVA_HOME

this error occurred when deploying a page on jdeveloper. to solve this error go to tools menu and select credentials and correct the path specified

Deleting multi-selected rows from adf table

2011-04-28T10:57:00.000+02:00

In this example i will selected rows using
1) CTRL or SHIFT with mouse click
2) Checkbox at the row
and press Delete button for ease of understanding i created 2 separate buttons in the examples.

Before start i assumed you already setup a Application with EO,VO and AM also using HR Connection

- Add a Transient Attribute to VO of Boolean type named "SelectedRow" We will use this to select row
Here the layout looks like

- Drag a Collection from DataControl as ADF Table to JSF page
- Dont Check RowSelection Checkbox
- Set the table RowSelection property to multiple
- Set EditingMode property to clickToEdit
- Surround your table with af:PanelCollection for look and feel give table a id "myTab"
- Add a toolbar in toolbar facet of Panelcollection
- Add 2 toolbar buttons to your toolbar
- Add partial triggers to your table reference both buttons on toolbar
- Create a backing bean
- Add a RichTable object to your bean with getter and setter methods.
- Set the binding property of the af:table to your Managed Bean
- Add Methods in Backing bean similar to the following code
- Link a method deleteAction to your "Delete Selected Rows" button and DeleteCheckedRows to other button.

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

2011-04-27T11:34:00.001+02:00

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

Detail entity with row key null cannot find or invalidate its owning entity.

2011-04-27T08:26:00.001+02:00

in the model project go to the association.
double click on the association and expand the behavior node under relationship tab.
make sure that the primary key column is set to DBsequance, if you have a sequence on the database or a function that generate the db sequence from a trigger

3- check on composition association and cascade update key attribute

ADF Desktop Integration-enabled Excel Workbook

2011-04-17T10:46:00.000+02:00

Part 3: Developing a More Refined ADF Desktop Integration-enabled Excel Workbook

In Part 2 you created a basic Excel workbook, integrated with a Fusion Web application. In this part of the tutorial you add detail to that workbook to create one that is more functional.

Open wikipedia in a modal popup.

2011-03-29T10:16:00.000+02:00

This post was more or less inspired by the noteWindow example on
Oracles tag demo site. When hovering the highlighted text in this example the user gets extra information about the subject. I wanted to give the end user the opportunity to get even more information, for instance by invoking a wikipedia page about the subject. The catch here is that I wanted this information to be shown in a modal popup, and one that is not prohibited by popup blockers. Luckily ADF 11g provides javascript popups that can also be made modal, so the user has to close the popup before returning to the application.

This post describes how I used an in a to open the correct wikipedia in a modal popup.

Step 1: Create the plain text that invokes the noteWindow.

This is taken directly from the mentioned Oracle example.

 
            Vultures are scavenging birds, feeding mostly on the carcasses of dead animals. 
            Vultures are found in every continent except 
            
                           inlineStyle="color:red; font-weight:bold">
              
                                    triggerType="mouseHover" alignId="antarctica"/>
            
             and in Oceania.

This code produces the following page.

Step 2: Create the noteWindow that calls wikipedia.
This piece of code shows the noteWindow with the extra information. There is an with an associated . Also note the binding of the goLink. This binding makes sure that I can use the textvalue of the goLink in the backing bean to create the URL with the request parameter for the wikipedia page.


            
              Antarctica is Earth's southernmost continent, overlying the South
                 Pole. It is situated in the southern hemisphere almost entirely
                 south of the 
                                         binding="#{toolTips.goLink}"
                                         id="gl1">                                          
                               
                 and is surrounded by the Southern
                 Ocean. At 14.4 million km² (5.4 million sq mi), it is the
                 fifth-largest continent in area after Asia, Africa, North
                 America, and South America. Some 98% of Antarctica is covered by
                 ice, which averages at least 1.6 kilometres (1.0 mi) in thickness.

The link in the text is the one that I'm going to use to invoke Wikipedia.

Step 3: Creating the wikipedia URL.

Wikipedia uses a pretty simple URL with request parameters to navigate to the requested subject.

http://en.wikipedia.org/w/index.php?search=

With this knowledge it is easy to create a URL yourself to navigate to the requested page.

private static String wikipedia =
    "http://en.wikipedia.org/w/index.php?search=";

  String url;
  String reqParam;  
  private RichGoLink goLink;

  public ToolTips() {
  }

  public String getUrl() {
    return wikipedia + this.getReqParam();
  }
  public void setReqParam(String reqParam) {
    this.reqParam = reqParam;
  }
  public String getReqParam() {
    return this.goLink.getText();
  }

The popup containing the inlineframe is also straightforward. The source attribute of the inlineframe is an EL expression pointing to the url property in the above code fragment.


          
                          modal="true" 
                          title="External Internet Info in a Modal Popup" 
                          contentHeight="625" 
                          contentWidth="700" 
                          resize="on">          
             
                          source="#{toolTips.url}"
                          styleClass="AFStretchWidth"
                          inlineStyle="height:600px;">

When you click the goLink, the requested wikipedia page opens in a modal popup.
The users can 'only' return to the application by closing the popup.

How to launch LOV and Date dialogs using the keyboard

2011-03-29T07:27:00.002+02:00

How to launch LOV and Date dialogs using the keyboard

By frank.nimphius on February 26, 2011 9:13 AM

Using the ADF Faces JavaScript API, developers can listen for user keyboard input in input components to filter or respond to specific characters or key combination. The JavaScript shown below can be used with anaf:clientListener tag on af:inputListOfValues or af:inputDate. At runtime, the JavaScript code determines the component type it is executed on and either opens the LOV dialog or the input Date popup.

<af:resource type="javascript">
    /**
    * function to launch dialog if cursor is in LOV or
    * input date field
    * @param evt argument to capture the AdfUIInputEvent object
    */

The af:clientListener that calls the JavaScript is added as shown below.

As you may have noticed, the call to open the popup is different for the af:inputListOfValues and theaf:inputDate. For the list of values component, an ADF Faces AdfLaunchPopupEvent is queued with the LOV component passed s an argument. Launching the input date popup is a bit more complicate and requires you to lookup the implicit popup dialog and to open it manually. Because the popup is opened manually using theshow() method on the af:popup component, the alignment of the dialog also needs to be handled manually. For this, the popup component specifies alignment hints, that for the ALIGN_END_AFTER hint aligns the dialog at the end and below the date component. The align Id hint specifies the component the dialog is relatively positioned to, which of course should be the input date field.

The ADF Faces JavaScript API and how to use it is further explained in the Using JavaScript in ADF Faces Rich Client Applications whitepaper available from the Oracle Technology Network (OTN)

http://www.oracle.com/technetwork/developer-tools/jdev/1-2011-javascript-302460.pdf

An ADF Insider recording about JavaScript in ADF Faces can be watched from here

http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/adf-insider-javascript/adf-insider-javascript.html

Dynamically add region at runtime

2011-03-22T09:34:00.000+02:00

1- Create a .jspx page based on your template as usual and leave it blank until this time

2- Create all the bounded taskflows that you wants and create the page fragments as usual.

3- Create a java bean class called"DhamanJavaBean"

Package org.dhaman

import oracle.adf.controller.TaskFlowId;

public class DhamanJavaBean {

private String taskFlowId = "/WEB-INF/emp-flow.xml#emp-flow";

public DhamanJavaBean () {

super();

}

public TaskFlowId getDynamicTaskFlowId() {

return TaskFlowId.parse(taskFlowId);

}

At this moment the calss contains only one attribute " taskFlowId" and only one method " getDynamicTaskFlowId()"

1- Double click the "adfc-conf.xml" unbound taskflow and click on overview tab to add a new managed ben as follow:

- Name: dhamaBean

- Class : org.dhaman .DhamanJavaBean

- Scope: pageflow

2- Now return to the ".jspx" page and click on "Bindins" tab at the button of the page to open the page definition bindings page.

3- Under executable click add and select "adf task flow bindings" and select "task flow"

1- Click ok - the dialog will appear

1- Id: region " or you can write any name you like"

2- taskFlowId: #{pageFlowScope.dhamanBean.dynamicTaskFlowId} " this is the the method in the managed bean that will return the taskflow Id"

3- click ok and return to the source of the page " I mean the jsf source"

4- add a region tag under the facetRef like this

value="#{bindings.region.regionModel}"/>

1- save all

2- go to DataBindings.cpx and click on it and go to the structure window

1- you will add a "definition factory" in the databindings structure by right click on the Databindings and select "insert inside databinding" and select definition factory.

2- A new folder will be created as "definitionFactories"

3- Right click on that folder and select "insert inside" and select factory

- Namespace: http://xmlns.oracle.com/adf/controller/binding

- className: oracle.adf.controller.internal.binding.TaskFlowBindingDefFactoryImpl

1- save all

1- for testing add a default value for the " taskFlowId" in the java class. The default value is the task flow file name followed by "#" and taskflow id as show in the example

2- now run the .jspx file

General Considerations

2011-02-01T08:56:00.000+02:00

The page should be pleasant to look
at with colors and graphics that do not distract from the functional purpose of the page

Introduction To Task Flows

2011-01-24T07:54:00.006+02:00

فى بدايتنا مع ال jsf لما كنا بنعمل plan للمشروع بتاعنا كان شغلنا بيبقى عبارة عن pages و بينها flows و كان كل ما نحتاج function جديدة او متطلب جديد كنا بنعمله page و نربط الصفحة دى ب flow و ن control ال flow دة من خلال managed-bean او حتى backing-bean

طيب تخيل معايا لو الموضوع كبر مننا و لقينا نفسنا بعد سنتين بقى عندنا 25 او 30 صفحة على اقل تقدير

تخيل منظر ال flows و ال pages هيبقى عامل ازاى

تخيل ال maintenance هيبقى ازاى

طبعا الموضوع هيكون صعب جدا

طيب اية الحل؟

لو روحنا لل system analyst و قولناله الحقنا دورلنا على حل اكيد اول حاجة هيقولهانا " قسمو شغلكم ل modules"

و هو دة الحل فعلا

بس نطبقه ازاى؟

هنا تيجى اوراكل و تقدملنا حل

الحل فى ال task flows

ال task flows هو انك تفكر باسلوب المديولات . هو انك تقسم شغلك لمديولات . مجموعه الصفحات دى اللى ليها علاقة بالمبيعات فى مدويول المبيعات و مجموعه الصفحات دى اللى ليها علاقة بالمخازن فى مديول المخازن مثلا

اقرا معايا ال paragraph اللى جاى دة من كتاب Oracle fusion ware developer guide

ADF task flows provide a modular approach for defining control flow in an application.
Instead of representing an application as a single large JSF page flow, you can break it
up into a collection of reusable task flows.

طيب السؤال هنا ازاى يعنى اعمل كل محموعة صفحات فى task flow

طيب وفى حالة انى عاوز اعمل navigate من صفحة فى مدول المبيعات لصفحة فى مديول المخازن بردة تتعمل ازاى؟

الاجابة باختصار معنى انك تقسم شغلك لمديولات يعنى انك تعمل كل مديول فى config file و تديله اسم

مش احنا فى الاول كنا بنعمل ال page flow بتاعنا فى ال faces-config.xml

لا الوقتى هتعمل اكتر من config file كل ملف بيمثل مديول معروف بدايته و معروف نهايته ودة اللى بنقول علية bound task flow

اية bound task flow و اية unbound task flow
مبدأيا نقول ان ال unbound task flow هى ال entry point for our application و ان ال bound task flow هى ال task اللى ليها بدايه محددة و معروفه و ليها نهاية كمان
ممكن يجى فى دماغ واحد و يقول " اةة يعنى unbound task هى login page "
اجى انا و اقولة لا مش ال login ال login page عمرها ما تنفع تبقى unbound task لا ليها بداية محدده و ليها نهاية كمان و معروف حدودها و معروف اليوزر هميش لفين و يروح لفين
تعالو نتكلم بامثله احسن
هنتكلم عن يوزر داخل موقع ياهو و نشوف هيعمل اية

تعالو ندخل موقع ياهو و نتفرج علية

اليوزر دخل على الصفحة الرئيسية و دى هى ال entry point
ايون دى هى ال entry point يعنى دى هى ال unbound task
لية unbound؟
لان مش عارفين حدودها مش عارفين اليوزر هيضغط على ايى لينك و لا هيعمل بحث و لا لا و لا هيقرا الاخبار و لا هيعمل اية
اهو كل اللى انا قولته دة( الاخبار - اللينكات - الميل - البحث) يبقى bound tasks

You typically use an unbounded instead of a bounded task flow if:

You want to take advantage of ADF Controller features not offered by boundedtask flows, such as bookmarkable view activities.
The task flow will not be called by another task flow.

طيب سؤال : معنى كدة ان كل APPLICATION لية entry point واحدة؟؟
الاجابه : بالطبع لا
لو لاحظتو الصورة هتلاقوها myyahoo مش yahoo
بالطبع ممكن يكون عندك اكتر من entry point

3. The application has multiple points of entry.

لكن هى نفسها لا تحتوي على single point of entry

كل الكلام اللى فات دة كلام نظرى كان مقدمة
بس الدنيا هوضح اكتر لو هنعمل مثال عملى و نطبقة كمان

المثال العملي:
تخيلو معايا ان احنا الوقتى بنتفرج على لقاء بين محلل نظيم و بين عميل يبقى صاحب شركة اجهزة كهربائية
تعالو نشوف المدادثة اللى بينهم ---
انا هفترض انا انا العميل و انتم شركة ال IT اللى هتعملي السيستم
العميل :
احنا شركة مبيعات اسمنا الشركة مصرية للاجهزة الالكترونية
عاوزين نظام يشتغل للعملاء يعرضلهم منتجاتنا اللى بينبيعها على الانترنت
و كمان عاوزين نفس النظام يقدر الموظفين يدخلو من عليه و يسجلو منتجات جديدة و كمان يعملو عروض اسعار تظهر للعملاء فى صفحتهم

محلل النظم :
يعنى انتو عاوزين العملاء و الموظفين يدخلو من نفس الصفحة و كل واحد يشوف حاجته حسب صلاحياته
و لا عاوزين للعملاء صفحة و للموظفين صفحة مختلفة

العميل:
لا احنا عاوزين صفحة العملاء مختلفه عن صفحة الموظفين مش كلهم يدخلو من نفس المكان
لان احنا هننشر صفحة العملاء على الانترنت لكن صفحة الموظفين هتبقى داخلية بس

محلل النظيم " بيكلم نفسه : اةة يعنى كدة هيبقى عندى two entry points" مممممم" يعنى 2 unbound task flows"

محلل النظم:
طيب انت عاوز تعرض اية فى صفحة العملاء دى بالظبط؟
العميل:
عاوز اعرض اول حاجة تظهر للعميل العروض لو كان فيه عروض و بعد كدة جدول بالمنتجات و كل منتج ممكن اعرض تفاصيلة و مواصفاته و صورة و عاوز كمان اعمل امكانية انى ابيع بالفيزا للعميل من على النت
و كمان عاوز امكانية ان العميل يبعتلى استفسار عن اى حاجة و يوصلنى فى الميل بتاعى

محلل النظم : طيب بالنسبة للموظف عاوزة يعمل اية على السيستم؟

العميل : عاوز الموظفين كلهم اول ما يفتحو الصفحة تظهرلهم الاجازات الرسمية فى البلد للسنة الحالية علشان يبقى عارفين الاجازات امتى و كمان عاوز كل الموظفين يشوفو جدول كدة بالقرارات الادارية و جدول باخر اخبار الشركة و كمان عاوز مكان كدة يعملو منه Login علشان يدخلو يعملو شغلهم

محلل النظم: و اية شغلهم؟

العميل: فى الوقت الحالى عاوزهم بس يعملو عروض اسعار بس دة طبعا للناس بس اللى عنها صلاحية تعمل عرض اسعار
محلل النظم: فى حاجة تانية
العميل : لا بس كدة بس انت اعمل دول و اعرضلى اللى انت عملته
----------------
و انتهى اللقاء الاول بين محلل النظم و العميل و اخد محلل النظم ورقة وحاجته و راح على مكتبه

فى الحلقة القادمة ان شاء الله هنتكلم ازاى محلل النظم فكر و بدا يحلل
بس هنركز على موضوع ازاى عمل ال unbound and bound task flow

Installing developer 6i on window 7

2011-01-23T11:35:00.000+02:00

اكيد فى ناس لسة شغال
6i
و طبعا قابلو مشكلة انهم يشتغلو على ويندوز 7
الحل ان فى ملفين
dll
فى الفولدر bin
هما اللى عاميلن المشكلة دى

شوف الخظات التالية

Installing Oracle Developer (forms & reports 6i) on Windows 7 64bit

Oracle developer 6i (forms & reports) Installation tips.
Including me, many of you out there must be still using the developer 6i and getting this stuff work under Windows 7 64bit environment could be quite tricky.
Run the installer normally (without changing the compatibility mode) and finish the installation for both forms and reports. Go to this link and download the files suggested.
Now go to your developer installation folder, browse to BIN directory and make backups for these files

NN60.DLL
NNB60.DLL

Now copy the extracted files from the downloads you already have, to \BIN directory. This should deal with forms developer not responding to the “Run” button click or ‘Ctrl+R’ shortcut key.
Hope this post is useful Oracle developers.

ADF chapter 3 summary

2011-01-23T11:01:00.000+02:00

Getting Started
The important notes are:

Generic VS strong typed API:

generic is to use only one method that accepts column name as string
strongly typed is to use getter method for the attribute or column name

Example
Row row = ordersVO.getCurrentRow();
Date shippedDate = (Date)row.getAttribute("OrderShippedDate");

OrdersRow row = (OrdersRow)ordersVO.getCurrentRow();
Date shippedDate = row.getOrderShippedDate();

2. interfaces accessible for the client:
1- Application Module
2- View objects, representing the query components
3-View rows, representing each row in a given query component's results

3-Custom Client Interfaces for Components
you can create your own custom interface that contains your custom business services required to be exposed to some clients.
so, you can create your java class that extends the super interface . for example

StoreServiceAM extends ApplicationModule : Custom application module interface
OrderItemsInfo extends ViewObject : Custom view object interface
OrderItemsInfoRowClient extends Row : Custom view row interface

4- Overview of Groovy Support
Groovy is:

scripting language
Java-like syntax
executed at runtime
strongly typed language

used for :

Define an Script Expression validator or Compare validator
Define error message tokens for handling validation failure
Handle conditional execution of validators
Set the default value of a bind variable in the view object query statement criteria statement
Define the default value for an entity object attribute
Calculate the value of a transient attribute of an entity object or view object

adf object

There is one top-level object named adf that allows you access to objects that the
framework makes available to the Groovy script
adf.context - to reference the ADFContext object
adf.object - to reference the object on which the expression is being applied
all attributes in Entity objects
all attributes in View Objects
Bind variable in view objects:
Bind variable in view accessors:
Transient attributes:
adf.error - in validation rules, to access the error handler
adf.userSession - returns a reference to the ADF Business Components user session
adf.currentDate
adf.currentDateTime
newValue: in an attribute-level validator, to access the attribute value being set
oldValue: in an attribute-level validator, to access the current value

report server,forms,OC4J_BI_Forms starts and stops automatically

2010-11-27T00:14:00.000+02:00

1-
open the file opmn.xml located in application server home/midtier/opmn/conf
and edit it as follow

Go to the process-type tag with id="OC4J_BI_FORMS" module-id="OC4J". Under this process-type tag, go to the category tag with the id="urlping-parameters".
Replace the line
with:

Then, under the line
add:

2-
edit the file rwnetwork.conf located in reports/conf
comment the first line
multicast channel="228.5.6.7 ...
and un comment the second line
namingService name="Cos"
example

Exception creating EntityManagerFactory

2010-11-09T11:38:00.000+02:00

Exception creating EntityManagerFactory
This error in jdeveloper occurs when you build your ejb module on views not table
the problem is that the @id annotation is not added to the code generated by jdeveloper.
In addition to that , the java.sel.Timestamp is used insted of java.util.Date.
moreover that, the wizard that generates the code does not generate @Temporal annotation.

To solve this problem, do the following:

Do not use Java fields of type java.sql.Date! java.util.Date or java.util.Calendar instead.
add annotation @id before primary key column
add annotation @Temporal before every Date attribute

My journey with Java

2010-10-27T12:37:00.000+02:00

الحمد لله

و بعدرحلة طويلة من المحاولات فى ال j2ee و ال self study المرير

بدأنا كورس ال j2ee

بصرحاة انا كنت عاوز البداية من الويب

لكن مديرى و زمايلى اصرو انهم يبداو أ ب جافا من الاول خالص

انا قولت اكيد خير علشان هراجع اللى اتعلمته قبل كدة فى ال j2se

اصلى اخدت الكورس دة قبل كدة مرتين

Screen Recorder

2010-10-04T13:23:00.000+02:00

-********************************************************- -
Screen Recorder
this software record screen and save it to vedio and HTML and Flash
********************End*********************************-

Quiz 3

2010-09-30T07:57:00.000+03:00

-********************************************************- -
I create and populate the following table:

CREATE TABLE my_employees
(
last_name VARCHAR2 (100)
, salary NUMBER
)
/

BEGIN
INSERT INTO my_employees
VALUES ('Smith', 100);

INSERT INTO my_employees
VALUES ('Silva', 200);

INSERT INTO my_employees
VALUES ('Singh', 300);

INSERT INTO my_employees
VALUES ('Chen', 400);

INSERT INTO my_employees
VALUES ('Corvalis', 500);

INSERT INTO my_employees
VALUES ('Feuerstein', 600);

COMMIT;
END;
/
I then write the following block:

DECLARE
TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE;

l_filters namelist_t := namelist_t ('S%', 'C%', 'F%');
BEGIN
FORALL indx IN 1 .. l_filters.COUNT
UPDATE my_employees
SET salary = salary * 1.1
WHERE UPPER (last_name) LIKE l_filters (indx);

/*COUNT*/
END;
/

Which of the following choices can be used in place of the /*COUNT*/ comment so that the following text is displayed on the screen:

3
2
1
Answer
SQL%BULK_ROWCOUNT is referred to as a "pseudo-collection" because it shares some, but not all, of the properties of a true, PL/SQL collection. Specifically, none of the standard methods of a collection work with SQL%BULK_ROWCOUNT. If you want to iterate through the elements of SQL%BULK_ROWCOUNT, then you must reconstruct the looping algorithm employed by FORALL to identify and execute the DML statements. With "FORALL indx IN low_value .. high_value", you can execute code like this:

FOR indx IN low_value .. high_value
LOOP
DBMS_OUTPUT.PUT_LINE (SQL%BULK_ROWCOUNT(indx));
END LOOP;
If, on the other hand, you used INDICES OF or VALUES OF, you may have to write a considerably more complicated looping algorithm.

Here is the code I used to check my answers:

DROP TABLE my_employees
/

CREATE TABLE my_employees
(
last_name VARCHAR2 (100)
, salary NUMBER (3)
)
/

BEGIN
INSERT INTO my_employees
VALUES ('Smith', 100);

INSERT INTO my_employees
VALUES ('Silva', 200);

INSERT INTO my_employees
VALUES ('Singh', 300);

INSERT INTO my_employees
VALUES ('Chen', 400);

INSERT INTO my_employees
VALUES ('Corvalis', 500);

INSERT INTO my_employees
VALUES ('Feuerstein', 600);

COMMIT;
END;
/

DECLARE
TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE;

l_filters namelist_t := namelist_t ('S%', 'C%', 'F%');
BEGIN
dbms_output.put_line ( 'Use binding array index values' );

FORALL indx IN 1 .. l_filters.COUNT
UPDATE my_employees
SET salary = salary * 1.1
WHERE UPPER (last_name) LIKE l_filters (indx);

FOR indx IN 1 .. l_filters.COUNT
LOOP
DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (indx));
END LOOP;

ROLLBACK;
END;
/

DECLARE
TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE;

l_filters namelist_t := namelist_t ('S%', 'C%', 'F%');
BEGIN
dbms_output.put_line ( 'Use COUNT method with pseudo-collection' );

FORALL indx IN 1 .. l_filters.COUNT
UPDATE my_employees
SET salary = salary * 1.1
WHERE UPPER (last_name) LIKE l_filters (indx);

FOR indx IN 1 .. SQL%BULK_ROWCOUNT.COUNT
LOOP
DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (indx));
END LOOP;

ROLLBACK;
END;
/

DECLARE
TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE;

l_filters namelist_t := namelist_t ('S%', 'C%', 'F%');
BEGIN
dbms_output.put_line ( 'Use FIRST and LAST methods with pseudo-collection');

FORALL indx IN 1 .. l_filters.COUNT
UPDATE my_employees
SET salary = salary * 1.1
WHERE UPPER (last_name) LIKE l_filters (indx);

FOR indx IN SQL%BULK_ROWCOUNT.FIRST .. SQL%BULK_ROWCOUNT.LAST
LOOP
DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (indx));
END LOOP;

ROLLBACK;
END;
/

DECLARE
TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE;

l_filters namelist_t := namelist_t ('S%', 'C%', 'F%');
BEGIN
dbms_output.put_line ( 'Use explicit index values with pseudo-collection');

FORALL indx IN 1 .. l_filters.COUNT
UPDATE my_employees
SET salary = salary * 1.1
WHERE UPPER (last_name) LIKE l_filters (indx);

DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (1));
DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (2));
DBMS_OUTPUT.put_line (SQL%BULK_ROWCOUNT (3));

ROLLBACK;
END;
/
********************End*********************************-

2010-08-03T22:42:00.001+03:00

--------------------------------------------------

How to create Business Rules & Database Triggers:

2010-04-14T13:18:00.001+02:00

--------------------------------------------------

Environment Headstart utility

go to the Function Hierarchy Diagramer
select the container that you wish to create the business rule in, or just create a new sheet
click on Function icon "small white square on the right top of the screen", then place it in the sheet
type the lable and short definition of that function.

Note:

in this step you are building your business rules tree, so you may keep the root as a description for your business rules to be grouped under. Ex: for PMS, first we start with the root BR_PMS, and its definition is PMS Business Rules. Then for each system model, we have a group of business rules, like Funds/Portfolios Business Rules, or Securities Business Rules...etc.

pick again the function icon, and type the label according to the following convention:

· BR_TableShortName001_CEV (change event)

· BR_TableShortName002_TRS (transition event)

· BR_TableShortName003_IER (inter-relation event)

· BR_TableShortName004_ENT (entity event)

· BR_TableShortName005_DEL (delete event)

· BR_TableShortName006_UPD (update event)

· BR_TableShortName007_TPL (topple event, used to verify between columns on the table)

è for more description on those event, please reference the oracle manual.

double click on the function and assign the Entity Usage.
assign Attribute Usage
Save the diagram
go to the Repository Object Navigator
under the selected container, go to Process Events
select the event on which you want to fire the trigger, either on the table or a specific column, usually the STATUS column.

Note:

If you do not find your table there, then do the following:

- go to the http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities

- Productivity Booster --> Analysis --> Maintain Default Events for Entities

- pick your table and run.

- this will generate the needed events for the table.

under Triggering Functions, right click --> create reference --> select the business rule name that you created in the Function Hierarchy Diagramer, and save
go to the http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities
Productivity Boosters --> Business Logic Layer --> Rule Layer
select the Business Rule Design Transformer
Select the Business Rule Function that you have created, and run
from the Server Model, refresh your table triggers and you will find your trigger assigned.
Edit trigger logic, and then generate table CAPI from the utilities and then table API.

Keep Where statement as "default where" when you re query

2010-03-09T08:22:00.003+02:00

Scenario :

1- User presses enter query button

2- user enter the criteria and the presses "Execute Query" button

3- Data for the specified criteria is now displayed on the block

4- user wants now to order data ascending , so he presses "Order ASC" button which contains this code

"set_block_property('data",default_where,vColumn||' '||'asc');

Execute_query;"

5-The block now displays all the data form the table in a ascending order

requirement:

user wants to display only the data with the previous specified criteria in an ascending order

--------------------------------------------------

DECLARE

v_qry varchar2(1000);

v_where varchar2(1000);

m number;

n number;

BEGIN

csh$block.all_Rec('DATA','QF_BROWSE',:SWITCH,'CSH_ENTER',:ACTION_FLAG);

If csh$block.check_records(':browse.status',:action_flag,:switch,'CSH_ENTER','T')>0 then

v_qry:=get_block_property('BROWSE',last_query);

qms$block.go('DATA');

--set_block_property('DATA',default_where,'jv_type =''PV''');

m:=instr(v_qry,'WHERE');

n:=instr(upper(v_qry),'ORDER BY');

if m>0 then

v_where:=substr(v_qry,m+6,(n-(m+6)));

end if;

set_block_property('DATA',default_where,v_where);

v_qry:=get_block_property('DATA',default_where);

qms$menu.set_current_action('EXECUTE_QUERY');

execute_trigger('QMS$MENU_ITEM');

END IF;

end;

--------------------------------------------------------------------

Forms is Very slow after installing sun JRE

2009-08-24T12:13:00.008+02:00

--------------------------------------------------
you may face this problem
that is your form becomes very slow after running it on Sun JRE instead of Oracle jinitiator
to solve this problem :
open basejpi.htm and add this parameter
--------------------------------------------

--------------------------------------------

problem with java plugin for mozilla or firefox with forms

2009-08-24T12:09:00.001+02:00

--------------------------------------------------
If you replaced oracle Jinitiator or JRE, you may not unable to run forms using Firefox or Mozilla
To solve this problem edit formsweb.cfg

jpi_mimetype=application/x-java-applet

Installing Oracle on DHCP server

2009-07-08T13:47:00.002+03:00

--------------------------------------------------
If you are using DHCP or Your computer is not connected to a local network, You have to Follow these steps before beginning installation for Oracle Database
1-ADD Microsoft loopback adapter
To install the Microsoft Loopback Adapter, follow these steps:

1-Go to Start | Control Panel | Add Hardware.
2-In the introductory dialog box, click Next.
3-Select Yes, I Have Already Connected The Hardware, and click Next.
4-Scroll to the bottom of the Installed Hardware list box, select Add A New Hardware Device, and click Next.
5-Select the Install The Hardware That I Manually Select From A List (Advanced) option, and click Next.
6-Under Hardware Types, select Network Adapters, and click Next.
7-Under Manufacturer, select Microsoft.
8-Under Network Adapter, select Microsoft Loopback Adapter.
9-Click Next twice, and click Finish.

Assign a non-routable IP like"192.168.1.1" to Loopback Adapter
don't assign xxx.xxx.xx.xx to network adapter. because that's usually reserved for default router. Use 192.168.1.1

Go to c:\window\system32\drivers\etc
open hosts file
add at the end
192.168.1.1

Note: is your computer name

Now begin installing oracle on you PC

service started and Stoped

2009-07-06T14:21:00.001+03:00

--------------------------------------------------
OracleOraHome10g service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alert service."

solution
Check windows/system32/drivers/etc/hosts for the hostname and IP of the server you are using for the OMS, you may need to add an entry here to resolve a DNS problem.

Installing and running oracle databse on standalone PC

2009-07-06T14:18:00.002+03:00

--------------------------------------------------
- go to control panel
- add new hardware then add new networkadapter
- after adding the network adapter, go to network setting and add a static IP address
- then start installation

Some Useful WIndow Conmmands

2009-07-05T12:35:00.000+03:00

--------------------------------------------------
dxdiag to find specifications for your computer

Expand and Collapse tree

2009-06-29T11:35:00.002+03:00

--------------------------------------------------
To Collapse tree nodes
PROCEDURE collapse_tree IS
vnode ftree.node;
vhtree ITEM;
vstate varchar2(30);

BEGIN
-- Search the tree identifiant --
vhtree := Find_Item('TREE_BLOCK.HTREE');

-- Search the root --
vnode := Ftree.Find_Tree_Node(vhtree, '');

-- Collapse all nodes --
WHILE NOT ftree.ID_NULL(vnode) LOOP
vstate := Ftree.Get_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE);
IF vstate = Ftree.EXPANDED_NODE THEN
Ftree.Set_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE, Ftree.COLLAPSED_NODE);
END IF;
vnode := Ftree.Find_Tree_Node(vhtree, '', Ftree.FIND_NEXT,Ftree.NODE_LABEL, '', vnode);

END LOOP;

END;

To Expand tree nodes :
PROCEDURE explose_tree IS
node ftree.node;
htree ITEM;
state varchar2(30);

BEGIN
-- Search the tree identifiant --
htree := Find_Item('BL_TREE.MENU');

-- Search the root --
node := Ftree.Find_Tree_Node(htree, '');

-- Expand all nodes --
WHILE NOT Ftree.ID_NULL(node) LOOP
state := Ftree.Get_Tree_Node_Property(htree, node, Ftree.NODE_STATE);
IF state = Ftree.COLLAPSED_NODE THEN
Ftree.Set_Tree_Node_Property(htree, node, Ftree.NODE_STATE, Ftree.EXPANDED_NODE);
END IF;

node := Ftree.Find_Tree_Node(htree, '', ftree.find_NEXT,Ftree.NODE_LABEL,'', node);

END LOOP;

END;

How to replace oracle JInitiator with other Native Java Virtual Machine?

2009-06-17T10:09:00.005+03:00

--------------------------------------------------
1- Open forms\server\ formsweb.cfg
2- Search for [JPI] section. This section exists by default.
3- You now will add three new parameters (jpi_download_page, jpi_classid, jpi_codebase)
-------------------------------------------------
[jpi]
baseHTMLJInitiator=basejpi.htm
[MyApplication]

baseHTMLJInitiator=basejpi.htm

#archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar

archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_09/index.html

# or you may use application server URL

#jpi_download_page= http://iai2.iai.org.kw:7778/forms/jinitiator/us/jinit_download.htm

jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4-windows-i586.cab#Version=1,4,0,0

-----------------------------------------
now copy this file "jre.exe" to the following location : /jinit

note: rename this file to jre.exe

Now go to application server home>/jinit/us and open the file jinit_download.htm with note pad and edit the reference of Oracle Jinitiator to Sun jre as shown in then image

For further readings you may read Forms9i or forms10g Configurations
----------------------------------------------
updates: for windows 7 and 2008 ,XP
First, the URL you have is incorrect. The correct codebase for 1.6.0_17 would be:

http://java.sun.com/update/1.6.0/jinstall-6u17-windows-i586.cab

A complete list (mostly complete) can be found on the Sun website here:

http://java.sun.com/javase/6/docs/technotes/guides/deployment/deployment-guide/autodl-files.html

This page is generally (as far as I can tell) not updated until new patch releases go out. Since _17 was a security update and not a complete patch release, the page will not show _17 yet.

Second, if you are planning to use Sun 1.6.0_xx, be sure you are using Forms 10.1.2.3 or newer.

jpi_download_page=http://java.sun.com/javase/downloads/index.jsp
jpi_classid=clsid:CAFEEFAC-0016-0000-0017-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u17-windows-i586.cab#Version=1,6,0,17
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_17

how to create journalling tables and thier triggers

2009-06-17T09:34:00.001+03:00

--------------------------------------------------

create Journalling tables:

1. go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities

2. Productivity Boosters --> Data Layer --> Logical Database Design (DB.010)

3. click on Maintain journal tables

4. select the names of Tables to be journaled, then click on run

5. generate th journal tables from DB Admin and grant roles to ADMIN and APPROVE

6. you don't need to generate CAPI for the journal table from the utilities, just generate the table from DB admin and then generate Table API from the Server model.

7. in the properites of the table to be journalled , put Journal in the notes filed

create journalling triggers:

1.go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities

2. Productivity Boosters --> Business Logic Layer --> Rule Layer - CDM RuleFrame --> Standar rule patterns

3. click on Maintain Journalling Business Rules

4. Select the tables to be journaled, then click on run

5. go to the tables triggers in the Server Model and update the logic to insert the required information in the journalling tables.

6. jenerate the table TAPI and CAPI.

Notes:

please note that when you pass the columns in arguments of the journalling triggers, name them as old. ex: P_OLD_MGH_ID, P_OLD_ID. define them as columns, and map them to the corresponding columns in table.

you can check the pms_activities t

What is the difference between ROWNUM and ROWID

2009-06-09T14:34:00.001+03:00

--------------------------------------------------

This artical is Quoted from http://thinkoracle.blogspot.com/2005/10/rownum-and-rowid.html

ROWNUM and ROWID

Questions:
How do I limit the number of rows returned by a query?
How do I write a query to get the Top-N salaries from the employee table?
How can I add unique, sequential numbers to an existing table?
How can I differentiate between two completely identical rows?
How can I find a faster way to retrieve a queried row?
How can I find the last row processed in a big batch?

There is one thing all these questions have in common: the answer involves either ROWNUM or ROWID.

So what is ROWNUM and ROWID?

First of all, both are covered in the SQL Reference, Basic Elements of Oracle SQL, Chapter 2:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540.pdf

They are also both referred to as pseudo-columns. That is, they are not "real" columns that will show up when you DESC a table. They don't actually exist anywhere in the database. But they're available for you to use.

In fact, ROWNUM only exists for a row once it is retrieved from a query. It represents the sequential order in which Oracle has retrieved the row. Therefore it will always exist, be at least 1, and be unique (among the rows returned by the query). Obviously it will change from query-to-query. Let's look at a quick example:

scott@Robert> SELECT ROWNUM, ENAME, SAL
 2  FROM EMP;

   ROWNUM ENAME             SAL
---------- ---------- ----------
        1 SMITH             800
        2 ALLEN            1600
        3 WARD             1250
        4 JONES            2975
        5 MARTIN           1250
        6 BLAKE            2850
        7 CLARK            2450
        8 SCOTT            3000
        9 VOLLMAN          5000
       10 TURNER           1500
       11 ADAMS            1100
       12 JAMES             950
       13 FORD             3000
       14 MILLER           1300

Ok so let's say we want the 5 highest paid employees. Should be easy:

scott@Robert> SELECT ROWNUM, ENAME, SAL
 2  FROM EMP
 3  WHERE ROWNUM < 6
 4  ORDER BY SAL DESC;

   ROWNUM ENAME             SAL
---------- ---------- ----------
        4 JONES            2975
        2 ALLEN            1600
        3 WARD             1250
        5 MARTIN           1250
        1 SMITH             800

Whoops! Turns out ROWNUM is assigned before results are ordered, not after. Knowing that, we can write it like this:

scott@Robert> SELECT ENAME, SAL
 2  FROM (SELECT ENAME, SAL FROM EMP ORDER BY SAL DESC) E
 3  WHERE ROWNUM < 6;

ENAME             SAL
---------- ----------
VOLLMAN          5000
SCOTT            3000
FORD             3000
JONES            2975
BLAKE            2850

What about ROWID? ROWID actually represents the physical location of the record/row in the database. That being the case, it is (according to Oracle documentation) the fastest way to retrieve a particular row. Faster than an index, even.

Can you use ROWID to differentiate between duplicate rows?
Yes, you can. Since it actually represents the physical location of a row, no two rows within the same table will have the same ROWID. Notice the caveat I added: within the same table. If you're using clustering, two records from different tables could theoretically share the same ROWID.

Do ROWIDs change?
Yes, especially with index organized or partitioned tables. Because ROWIDs represent the physical location of a record/row, the ROWID will change every time the record is physically moved.

Can you use ROWID as a primary key?
No, that's not advisable. While the ROWID will be unique, you would ideally want to use a primary key that doesn't change.

How do you use ROWID to figure out what was the last record that was processed?
Using DBMS_SQL.LAST_ROW_ID to get the ROWID of the last row processed.

You'll see ROWNUM and ROWID pop up occasionally within solutions to problems on AskTom and various Discussion Forums, so I recommend adding it to your own toolbelt as well.

Working With File Throgh WebUtill

2009-03-24T08:58:00.015+02:00

--------------------------------------------------

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: Deletes a file. Returns a Boolean to indicate success.

Rename_File Renames a file. Returns a Boolean to indicate success.

Create_Directory Creates the named directory if it does not exist.

Any intermediate directories will also be created.

Returns a Boolean to indicate success.

Directory_Root_List Returns a FILE_LIST containing the directory roots on the client system. On a Windows PC these would correspond to the drives on the computer.

Directory_List :Returns a FILE_LIST containing all the files and subdirectories in a particular directory. There is an optional Return_Files_Only argument to restrict the returned list to just files with no directories.

Directory_Filtered_List : Like Directory_List this will return a list of files in a directory but you are able to file filter using the '*' and '?' wildcards e.g. *.FMB to restrict the list.

File_Exists :Returns a Boolean value indicating if the named file exists on the client

File_Is_Directory Returns a Boolean value indicating of the file name supplied is actually a directory on the client.

File_Is_Hidden :Returns a Boolean value indicating of the file has it's hidden attribute set.

File_Is_Readable :Returns a Boolean value indicating of the file can be read.

File_Is_Writable :Returns a Boolean value indicating of the file canbe written to.

File_Size :Returns the size of the file in bytes.

Directory_Selection_Dialog :Displays a Directory selection dialog. The initial directory and the title for the dialog can be defined. The selected directory is returned.

File_Selection_Dialog :Allows the definition of a File Save or Open dialog with a configurable file filter. Returns a single file selection. The file filter can use ? and * as wildcards and is in the format |||. Multiple filters

can be specified, e.g. |Gif Files|*.gif|JPEG Files|*.jpg|.

File_Multi_Selection_Dialog :As File_Selection_Dialog except that the user can select multiple files and these are returned in a FILE_LIST.

File_Open_Dialog :A convenience method that creates a File Open Dialog. File_Save_Dialog A convenience method that creates a File Save Dialog.

Get_file_Separator :Returns the character used on the client computer as the file separator e.g. "\" on Windows.

Get_Path_Separator :Returns the character used to separate directory locations on Paths e.g. ";" on Windows.

Document

Reading From File

2009-03-19T10:21:00.004+02:00

--------------------------------------------------

Declare

vfilename varchar2(500);

in_file Client_Text_IO.File_Type;

linebuf VARCHAR2(1800);

BEGIN

vfilename := client_get_file_name('c:/temp/', File_Filter=>'Comma Dialimeted Files (*.csv)|*.csv|');

in_file := client_Text_IO.Fopen(vfilename, 'r');

GO_BLOCK('Emp');

FIRST_RECORD;

LOOP

Client_Text_IO.Get_Line(in_file, linebuf);

p_output_line(linebuf);

Client_Text_IO.New_Line;

Next_record;

END LOOP;

FIRST_RECORD;

EXCEPTION

WHEN no_data_found THEN

Client_Text_IO.Put_Line('Closing the file...');

Client_Text_IO.Fclose(in_file);

END;

-------------------------------------------------------

PROCEDURE p_output_line(p_line varchar2) IS

vLINE VARCHAR2(4000);

vVALUE VARCHAR2(1000);

vCOMMA_COUNT NUMBER;

vREPORT_DATE DATE;

BEGIN

vLINE := p_line;

vCOMMA_COUNT := LENGTH(vLINE)- LENGTH(REPLACE(vLINE,',','')); -- COUNT THE NUMBER OF COMMAS

FOR I IN 1.. vCOMMA_COUNT+1 LOOP

vVALUE := SUBSTR(vLINE,1,INSTR(vLINE,',')-1); -- IF vLINE = 123,ABC,9877 THEN VVALUE WILL BE 123

IF vVALUE IS NULL THEN

vVALUE := vLINE;

END IF;

vLINE := SUBSTR(vLINE,INSTR(vLINE,',')+1) ; -- CHANGE 123,ABC,9877 TO BE ABC,9877

IF I = 1 THEN

:DATA.BMK_NAME := vVALUE;

ELSIF I = 2 THEN

vREPORT_DATE := last_day(to_date(vVALUE,'dd-mm-yyyy'));

:DATA.REPORT_DATE := vREPORT_DATE;

ELSIF I = 3 THEN

:DATA.BMK_RETURN := to_number(vVALUE);

END IF;

END LOOP;

EXCEPTION

WHEN NO_DATA_FOUND THEN

MESSAGE('Please Check the data type is appropriate on you excel file');

END;

-----------------------------------------------------------------------

-- notes

1- you must install webutil version 106 or later

2- make sure that you attached and compiled the webutill.pll scucessfuly

Read From Excel

2009-03-17T13:33:00.005+02:00

--------------------------------------------------

DECLARE

application OLE2.OBJ_TYPE;

workbooks OLE2.OBJ_TYPE;

workbook OLE2.OBJ_TYPE;

worksheets OLE2.OBJ_TYPE;

worksheet OLE2.OBJ_TYPE;

cell OLE2.OBJ_TYPE;

args OLE2.OBJ_TYPE;

cell_value number;

BEGIN

application := OLE2.CREATE_OBJ('Excel.Application');

ole2.set_property(application,'Visible','true');

workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks');

args := OLE2.CREATE_ARGLIST;

ole2.add_arg(args,'c:\test.xls');

workbook := ole2.GET_OBJ_PROPERTY(workbooks,'Open',args);

ole2.destroy_arglist(args);

worksheets := ole2.GET_OBJ_PROPERTY(workbook, 'Worksheets');

worksheet := OLE2.GET_OBJ_PROPERTY(application,'activesheet');

for cols in 1..4 loop -- columns

for rows_index in 1..3 loop -- rows

args:= ole2.create_arglist;

ole2.add_arg(args, rows_index);

ole2.add_arg(args, cols);

cell:= ole2.get_obj_property(worksheet, 'Cells', args);

ole2.destroy_arglist(args);

--cell_value :=ole2.get_char_property(cell, 'Value');

cell_value :=ole2.get_num_property(cell, 'Value');

go_block('t');

create_record;

:t.a := cell_value;

end loop;

-- Release the OLE2 object handles

ole2.release_obj(cell);

ole2.release_obj(worksheet);

ole2.release_obj(worksheets);

ole2.release_obj(workbook);

ole2.release_obj(workbooks);

ole2.invoke(application,'Quit');

ole2.release_obj(application);

END;

---------------------------------------------------------------------

demo form

notes:

-- PASS VALUE INTO Excel CELL (ROW 371, COL 3)

args := OLE2.CREATE_ARGLIST;

OLE2.ADD_ARG(args, 1);

cell := OLE2.GET_OBJ_PROPERTY(worksheet,'Cells', args);

OLE2.DESTROY_ARGLIST(args);

OLE2.SET_PROPERTY(cell, 'Value', '97FI01');

-- save document as test.xls

OLE2.INVOKE(worksheet, 'Save');

OLE2.INVOKE(workbook, 'Save');

OLE2.INVOKE(workbook,'CLOSE');

ora-12638 credential retrieval failed

2009-03-02T07:42:00.002+02:00

--------------------------------------------------

check the sqlnet.ora file. Change the following entry and try, this will work.

Original Entry - SQLNET.AUTHENTICATION_SERVICES= (NTS)

Modified Entry - SQLNET.AUTHENTICATION_SERVICES= (NONE)

How to Create your First Bean

2009-02-24T11:48:00.001+02:00

This documnent describs how to create your first bean

First Bean

Developing powerful Oracle Business Intelligence Beans

2009-02-20T21:17:00.002+02:00

Prerequisites

Oracle Forms 10g Rel. 2

•

Forms_Demos_10gr2.zip

Installation (1)

Download from OTN: Forms_Demos_10gr2.zip

•

•download.oracle.com/otndocs/demos/Forms_Demos_10gr2.zip

–

•Unzip it into an example-Folder of your choice

•

•Copy FormsGraph.jar into \forms\java

Source-Codes

PROCEDURE BT_Compare IS

vItem VARCHAR2(200) := :SYSTEM.Cursor_Item;

vGrafik ITEM := FIND_ITEM (Const_lokal.itm_Chart);

vData VARCHAR2(200);

BEGIN

-- Initialize Graph

SET_CUSTOM_PROPERTY (vGrafik, 1, 'CLEAR_GRAPH', '');

GO_BLOCK ('UMSATZUEBERSICHT');

FIRST_RECORD;

LOOP

vData := :UMSATZUEBERSICHT.Ums_Geschaeftsbereich || ',' ||

:UMSATZUEBERSICHT.Ums_Jahr || ',' ||

:UMSATZUEBERSICHT.Ums_Umsatz;

SET_CUSTOM_PROPERTY(vGrafik, 1, 'ADD_ROWDATA', vData);

IF :SYSTEM.Last_Record = 'TRUE' THEN

EXIT;

END IF;

NEXT_RECORD;

END LOOP;

FIRST_RECORD;

-- Show Graph

SET_CUSTOM_PROPERTY(vGrafik, 1, 'ADD_DATA_TO_GRAPH', '');

SET_CUSTOM_PROPERTY(vGrafik, 1, 'GRAPHTYPE', 'VERTICAL_BAR');

GO_ITEM(vItem);

END

PROCEDURE BT_Sum IS

vGrafik ITEM := FIND_ITEM (Const_lokal.itm_Chart);

vData VARCHAR2(200);

BEGIN

-- Initialize Graph

SET_CUSTOM_PROPERTY(vGrafik, 1, 'CLEAR_GRAPH', '');

FOR rUms IN (SELECT Ums_Geschaeftsbereich, SUM(Ums_Umsatz) Ums_Umsatz

FROM UMSATZUEBERSICHT

GROUP BY Ums_Geschaeftsbereich)

LOOP

vData := rUms.Ums_Geschaeftsbereich || ',' ||

'Total Sales 2000 - 2005' || ',' ||

rUms.Ums_Umsatz;

SET_CUSTOM_PROPERTY(vGrafik, 1, 'ADD_ROWDATA', vData);

END LOOP;

-- Show Graph

SET_CUSTOM_PROPERTY (vGrafik, 1, 'GRAPHTYPE', 'PIE_GRAPH');

SET_CUSTOM_PROPERTY (vGrafik, 1, 'ADD_DATA_TO_GRAPH', '');

END;

•

notify form

2009-02-20T21:13:00.000+02:00

to notify form from outside

http://www.4shared.com/file/88670510/ca591b00/notifyForm.html

Output query to text file

2009-02-20T20:58:00.003+02:00

I amde this demo to output the result of a query to file

http://www.4shared.com/file/88667703/e978be9c/DBToFile.html

how to make print screen from your form

2009-02-20T20:46:00.001+02:00

Form and jar file

---------------------------------------------------------------

package screen; import java.awt.AWTException; import java.awt.Robot; import java.awt.Rectangle; import java.awt.Toolkit; import java.awt.image.BufferedImage; import java.io.*; import javax.imageio.ImageIO; public class ScreenCapture { public void printScreen() throws AWTException, IOException { // capture the whole screen BufferedImage screencapture = new Robot().createScreenCapture( new Rectangle(Toolkit.getDefaultToolkit().getScreenSize()) ); // Save as JPEG File file = new File("screencapture.jpg"); ImageIO.write(screencapture, "jpg", file); // Save as PNG // File file = new File("screencapture.png"); // ImageIO.write(screencapture, "png", file); } }

---------------------------------------------------------------------------

-- form builder implementation

--------------------------------------------------------------------------

PROCEDURE printscreen IS jo ora_java.jobject; BEGIN jo:=ScreenCapture.new; ScreenCapture.printScreen(jo); END;

Configuring DAD file and MODPLSQL on Oracle Application server 10g

2008-03-30T15:35:00.001+02:00

mod_plsql DAD Configuration

This file contains documentation of all the Database Access Descriptor (DAD)level parameters that can be specified in the mod_plsql configuration file$ORACLE_HOME/Apache/modplsql/conf/dads.conf

A DAD is a set of values that specify how mod_plsql connects to a databaseserver to fulfill an HTTP request. Besides the connect details, a DAD containsimportant configuration parameters for various operations in the databaseand for mod_plsql in general. Any web-enabled PL/SQL application which makesuse of the PL/SQL Web ToolKit needs to create a DAD to invoke the application.

Some typical PL/SQL applications which would require DAD's are- Any PL/SQL Application written using the PL/SQL Web ToolKit- Oracle Application Server Portal- Oracle Application Server Single Sign-On

Creating a DAD------------------

If OHS/mod_plsql is part of the Oracle Application Server product, it isrecommended that you use Oracle Enterprise Manager to create a DAD. Otherwise,perform the following steps to create a DAD
1. Edit the DAD configuration file ORACLE_HOME/Apache/modplsql/conf/dads.conf.
2. Add a DAD where the DAD has the following format:
- The Oracle HTTP Server directive which defines a virtual path used to access the PL/SQL Web Application. This directive begins enclosing a group of directives that apply to the named Location.
For example, the directive defines a virtual path called "/myapp" that will be used to invoke a PL/SQL Web Application through a URL like http://host:port/myapp/.
Note: Older versions of mod_plsql were always mounted on a virtual path with a prefix of '/pls'. This restriction is removed in newer versions but might still be a restriction imposed by some older PL/SQL applications.
- The Oracle HTTP Server "SetHandler" directive which directs Oracle HTTP Server to enable mod_plsql to handle the request for the virtual path defined by the named Location
SetHandler pls_handler
- Additional Oracle HTTP Server directives that are allowed in the context of a directive. Typically, the following directives are used:
Order deny,allow Allow from all AllowOverride None
- One or more mod_plsql specific directives. For example:
PlsqlDatabaseUsername scott PlsqlDatabasePassword tiger PlsqlDatabaseConnectString orcl PlsqlAuthenticationMode Basic
- An Oracle HTTP Server directive which closes the group of directives for the named Location, and defines a single DAD.
3. Save the edits.
4. Obfuscate the DAD password by running the "dadTool.pl" script located in ORACLE_HOME/Apache/modplsql/conf. For instructions on performing the obfuscation, please refer to ORACLE_HOME/Apache/modplsql/conf/dadTool.README
If OHS/mod_plsql is part of the Oracle Application Server product, then issue $OH/dcm/bin/dcmctl updateConfig -ct ohs
5. Restart the Oracle HTTP Server for the configuration to take effect.
You can create additional DADs by defining other uniquely named Locations indads.conf.
Here is an example of a typical PLSQL application DAD
SetHandler pls_handler Order deny,allow Allow from all AllowOverride None PlsqlDatabaseUsername scott PlsqlDatabasePassword tiger PlsqlDatabaseConnectString orcl PlsqlAuthenticationMode Basic PlsqlDefaultPage scott.home PlsqlDocumentTablename scott.wwdoc_document PlsqlDocumentPath docs PlsqlDocumentProcedure scott.wwdoc_process.process_download

here is my example that I made it in my company

SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername moi
PlsqlDatabasePassword moi
PlsqlDatabaseConnectString moidb
PlsqlAuthenticationMode Basic

Using JTable instead of Ordinary Forms Data Block

2008-03-18T17:54:00.003+02:00

Display Result on JTable

Executing Server side procedure and publishing result on HTML

2008-03-16T17:08:00.002+02:00

source code will be avalibale soon

web.show_document('http://moiserver:7778/appweb/PKG_Download_BLOB.Download_Blob?P_tbl=CE_NOTICE&p_tranid=':CE_NOTICE.NOTICE_RECID,'_blank');

END;

another example
CREATE OR REPLACE procedure TEST.queryemp is
cursor emp_cur is
select ename,sal
from emp;
begin
htp.prn('');
htp.prn(' ');
htp.prn('Employee Data');
htp.prn(' ');
htp.prn(' ');
for i in emp_cur loop
htp.prn('');
htp.prn('');
htp.prn('

'||i.ename||'

');
end loop;
htp.prn(' ');
htp.prn('');
end;
/
--- dads conf

SetHandler pls_handler
Order allow,deny
Allow from All
AllowOverride None
PlsqlDatabaseUsername test
PlsqlDatabasePassword test
PlsqlDatabaseConnectString pmstst
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
PlsqlDocumentTablename smm_doc_table
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwdoc_process.process_download
PlsqlDefaultPage portal.home
PlsqlPathAlias url
PlsqlPathAliasProcedure wwpth_api_alias.process_download

-- restart http server
-- run this url
http://iai2.iai.org.kw:7778/myapp/queryemp

DeleteRowEnabled	True
InsertRowEnabled	True
UpdateRowEnabled	True

CancelButtonLabel	Cancel
OKButtonLabel	Yes
Prompt	Are you sure you want to delete these rows?
Title	Delete Confirmation