daogu

I have written a simple but neat ER diagramming tool for Oracle. Admittedly it’s not finished yet, but any feedback would be appreciated. It is totally free and can be download at http://www.schemester.com, have a play you might like it!
Answer:Martyn,
Great tools (have seen a demo). Have downloaded it.
Problem to use it: tnsnames.ora no id defined [...]

hi
i want to create form and i want to put in it text item and button once i write anything in this text i want to press the button then this message will send to the email i specfied before also attach file
this is my idea

how to create form [...]

Hi,
The code below (WHEN_BUTTON_PRESSED trigger)is supposed to create a group of applications and display their short cuts on the screen but it does not seem to be working.
I can see this comment at the bottom

Quote:

FRM-40735 WHEN_BUTTON_PRESSED trigger raised unhandled exception ORA-106555

On searching the forum I got answers on using excel and encountering this error but [...]

Hi,
I am calling report9i from forms9i.
i am getting following error
invalid report id
when i call a report from form in when button pressed trigger.
and also giving the following error
argument(1) can’t be null.

v_rep varchar2(100);
v_rep := run_report_object(’report5′,pl_id);
or [...]

Dear Experts,
I am developing an application using FORMS6I with Oracle 9i.
Please anyone advice me how do I open this applicatio in Internet Explorer ?
What should I install in the clients PCs to do so ?
Thanks.
Answer:Look at http://www.orafaq.com/forum/t/123189/67467/
David

hi every one,
i have installed oracle 10g database and 10g form successfully
i develop a form in 10g but i m unable to run it in browser
i have made all settings that one should
when i run it, explorer is opening but blank
Answer:did you start the OC4J instance?
did you point the forms to the database home [...]

Hi all,
I have a form which is calling many reports, I use to pass a parameter from the form and call the report and save it, but I have to do so for every report. Now I want a code which should call the reports one by one and save in memory at single click,
can [...]

Hi guys,
I have a problem here. In a forms at some point, I have a List Box of type Poplist that gets its values repopulated. An end user has pointed out a bug that happens just after this repopulation. Even though the list is showing the first new value of the list, whenever I [...]

hi
i want to write code in when_validate_item trigger
i want alert appears when i leave this item
says(’you have just inserted a duplicate value’)
becuse this record is unique

what is the code to handle duplicate values

Answer:Search this forum for ‘unique’. This is a common question. The ‘record group’ [...]

Hi All
actually i am new to use OLE2 package(in oracle form) so that i need some study material of that, so i need some help to provide me,Notes(Documentation ) regarding the OLE2 packege and their function/procedure.

best regards
Jitender
Answer:Surprisingly, but OraFAQ Forum offers the Guide for members. In there – if you took some time to read [...]

Hello,
Im using a LOV but im not sure how i can use the returned values
of this lov to fill up my datablock on my form with this values
Answer:Ress F1, go to the index for ‘LOV’, and read.
You need to set the ‘Return Item’ in the ‘Column Mapping Properties’ of the LOV.
You can only populate [...]

hello all,
my problem i can not run my oracle form 10g.or when i run, the browser shows the html codes. even though i have done the following steps:
1. start OCJ4
2. edit -> references> set the runtime
3. before now, it was fine and i can run the developing forms.
[...]

Hi all,
I have a form which are now converted to 10g version which will reference a table type defined in stored package, like this :
In forms trigger :
DECLARE
i_TDTL_RECORDS PKG_1.TBL_TYPE_1;
BEGIN
:
:
END;
where PKG_1 is a database package
and TBL_TYPE_1 is defined like the following :
TYPE TBL_TYPE_1 IS TABLE OF REC_1 INDEX BY BINARY_INTEGER;
I [...]

Sir
this is my design in my prototype…
the system would be a additional setup for categories
the CATEGORY represent by CAT_CD would be for every 1 category have many PERIL represent by PERIL_CD for each PERIL have 2 CONTAINER(i.e) containerized and non containerized

EXAMPLE that would be the relationship
C1 —1–contain
–non contain
2–contain
–non contain
3–contain
–non contain
4–contain
–non contain
my design would be like [...]

This is the scenario. In my place several apps are developed in Oracle Forms & Reports 6i, and each workstation that uses them is required to install the Oracle Forms, Graphics and Reports Runtime components straight from the Oracle Forms 6i install CD. We recently adquired Altiris Deployment Solution, and we intend to send software [...]

Pls anyone could tell me how do I assign values to COLUMN MAPPING PROPERTY at RUN TIME for a LOV.
I want to use the same LOV in more than one Data Blocks.

Hi Friends,
I have installed Oracle Forms from "Oracle 10g Development Suite" in Oracle website.
I need to connect it to the database for the first time. Please let me know how to connect it.
Is there any default user name / password.
Pls help as it is needed in emergency
Thanks
Answer:Do you have access to the database? [...]

I have to check if a block is related to another block. If I have block_A and I create relation there to relate block_A and block_B. Now, I’m in Block_B, let’s say I want to check if block_B is related to any other block, what is the quikiest way for me to know that it [...]

Hi Experts! I am trying to display image in Image control at oracle form. i want to adjust image but quality should maintain. when i adjust image it cant maintain the quality of image. Anybody can help me.
Answer:Create a bigger image via another product and place the new image into the form.
David

Hi Experts! I am facing a problem. i am using main form that is maximized, but when i call a new form using call_form through menu it restore the existing window and display the new form. i want to display the existing form maximized and other forms should display in restore mode and main window [...]

when i close the form at run time ,alert message box ask
do you want to changes made?
My question is
that message box doesn’t come when close the form at run time.
send solution please
Answer:

Quote:

send solution please

You want to add the message or remove?
If you want to add use Alerts.
If you want to remove the message. Remove alert [...]

Hiya
We are migrating our Oracle Forms 6i application to web based Oracle Forms 10g. The application runs using Sun JRE 1.5.0_05 in Internet Explorer on Windows XP.
Oracle Forms 10g uses Java classes for its own purpose which Oracle has supplied them in JAR files (e.g. frmall.jar)
Oracle recommends that we should cache these JAR files [...]

Hi
When we run, oracle forms 10g, it reads frmweb.cfg file present on Application Server. There is a background parameter in this file. What should be the path of image i want to display as a background. How does it work??
Regards
Asma
Answer:http://download-west.oracle.com/docs/cd/B10464_05/web.904/b10470/configure.htm#sthref304
Regards,
Answer:It has worked. Thanks..
Regards..
Asma

Hi,
The project I am working on needs to store resumes in the database. I want to select resumes stored on the OS but not able to figure out how I will invoke the file searching screen of the operating system.
The screen shot is attached, can you please suggest something?
Answer:try to use OLE Container
i had develop [...]

Hi,
Under mention form showing level setup for accounts(i.e. 001-01-01-001),actualy that is format mask for text item. I want to implement this to a text item

New level can be insert at any time
thanx in advance
Answer:Please check this link, it may help u..
http://www.orafaq.com/forum/m/337674/98907/#msg_337674

Hi
I was design the form in 10g. I run the same form it is running . when press any of button on screen I got the message like below
please guide me
kanish
Answer:Did you checked out GOOGLE?
Click Here
Answer:Have you solved your problem?
David
Answer:hi
Thanks i solved it.
kanish
Answer:
How to solved your problem
I also [...]

Hi,
I am working on a Sales system where multiple user may provide input from the same form using different user name. For an Example if user MIS Enter into the system it will get the Serial Number 22 from table Master, So when the user DBA enter into the system it should get the serial [...]

Hi everyone ,
i have just installed developer suit 10g. i have developed a form and when i run the form, the following error prompted. http listener is not started.
can anyone help me in this regard. i will be very thankful to you.
ok bye
Athar
Answer:hi,
You’ll have to Start the OC4J instance to run the form [...]

hi all
how to install or config. webutil, any documentation please.
please help.
jahangir
Answer:You can start by atleast searching this forum for webutil.

Hello, I want to open a word from a field of a forms, that me get the field content, to be able to modify the text of the word and on having closed the word, put the content of the word in the field.
DECLARE
app CLIENT_OLE2.OBJ_TYPE;
docs CLIENT_OLE2.OBJ_TYPE;
doc CLIENT_OLE2.OBJ_TYPE;
selection CLIENT_OLE2.OBJ_TYPE;
args CLIENT_OLE2.LIST_TYPE;
sel_text varchar2(4000);
BEGIN
app := CLIENT_OLE2.CREATE_OBJ(’Word.Application’);
CLIENT_OLE2.SET_PROPERTY(app,’Visible’,1);
docs := CLIENT_OLE2.GET_OBJ_PROPERTY(app, ‘Documents’);
doc [...]

Dear All,
I have entry screen with tabular format having "Horizontal scroll bar" property set to "Yes" in Stacked canvass.
My requirement is, I need to freeze first three columns while scrolling (like we do in Excel sheet). Is it possible? I searched this forum but did not get any useful clue.
Waiting for your [...]

Hi guyz,
I have a problem with query, I have almost 48 tables but no one is attach with other I mean no primary key or foreign key all are common but the one field is common in all table Computer_name is there anyway to query all the tables or select one record from [...]

Hi,
I have a form which is copying, deleting and printing files on the users Windows p.c. via client_host commands. I have included the NO_SCREEN option, but still a background window appears momentarily.
Due to my form having approx 15 of these client_host commands executing in quick succession, users have requested that the "flashing screens" do [...]

Hi Freinds,
I have been looking for gud books on oracle forms & Reports Developer, can anyone recommend me some good books on that?
Tahnks in Advance
Yoonus
Answer:Search this forum for ‘good book’.
David
Answer:I searched and found some.
Thank You very much
Answer:As a matter of fact, there are _no_ good books on this subject.
There are, actually only 2 books [...]

Hi Dear
i have one tabular block in this block i have lots of record .
like this
4:01 and 5:45 i have to calculate this (both field are varchar2)
i have to calculate like this
4:01 and 5:45 = 9:46 (it basically total time)
please give me solution hocould i calculate this.
thanks and regards
Sajid
Answer:what if it [...]

Answer:Check out Calculation Mode Property In online help of the oracle forms. You need to set that property to summary and then set the other properties (summary function,summerized block,summerized item). Online help explains what to do.
Regards,

Products:
Forms [32 bits] Versin 10.1.2.0.2 (In Windows)
Pl/SQL Versin 10.1.0.4.2 (In Windows)
Oracle Database 10g Release 10.2.0.3.0 (in AIX)
OAS 10g (in AIX)
JInitiator 1.3.1.26 (In Windows)
Windows XP Professional (In Windows)
Mrs., excuse my english, i like read or open a file (it does not matter), but i [...]

Sir,
I am using developer 2k forms 6i and reports 6i,there is one simple update statement which updates one column in the database.
this table has no on-update triggers on this column.
but at times it updates some time it does not update.
this code is within the form.
/*code*/
update vouch
[...]

hi,
while running test.fmx through web my browser is closing.
please explain me about this ..
Answer:Do NOT hijack existing threads!!
Have you changed the ‘test’ form?
David

hi,
it is my second time to tell you guys. when i run the form, the web browser shows this —>
Network Access Message: The page cannot be displayed
Explanation: The request timed out before the page could be retrieved.
Try the following:
Refresh page: Search for the page again by clicking the Refresh button. [...]

Hi,
when i want to open an excel from forms using the link of my local forms i get this error (10g forms )
Oracle.Forms.Webutil.Ole.Olefunctions Bean Not Found. CLIENT_OLE2.create_obj will not work.
On searching in the net i found a solution
Solution
– To implement the solution, please execute the following steps::
1.
Open the default.env file located in $ORACLE_HOME/forms/server
Add [...]

Dear all,
i need to convert our existing application which is (client/server) into web based but first i have to document the requirements for conversion to 10g i.e. what minimum database or application server is required e.g
anyhelp will be appreciated
Regards,
Kashif Ali
Answer:Do you have a PC? [...]

Hello,
I have made a form with 4 datablocks
company, project, contract and student
when i press on ctrl f11 and then want to switch to the next record in my db he always asks if i want to save de changes even if i have changed nothing. Is there e way to suppress this error or warning [...]

hello for all
I want to get weight from weighing machine in a form6i field
any one help me or suggest the code for this
thanks
anil sharma

The requirement is like this:
We have 2 forms Tasklist and Taskdetails. Taskdetails is based on a table whereas Tasklist is not.
1) When I click on the Tasknumber of Tasklist form, it should open the Taskdetails form with details regarding the particulat task number.
Now I want to have a hyperlink on Task number [...]

Hello,
I m trying to use webutil facility in oracle 10g.
Can anybody suggest how to use this.
I have created a form and attached webutil.pll and sub classed webutil.obj.
Further,I have written code on when-button-pressed to open file
Please suggest on this.
If its right or wrong…
Answer:What happens when you run this code? Have you run the example ‘webutil’ [...]

how to know the report server name and port number?
Answer:In a Form or in a Report?
David
Answer:in report
Answer:Look at the help file for "REPORTS_SERVER environment variable". It refers to "the Reports Servlet (rwservlet) configuration file (rwservlet.properties), as described in "Identifying the Default Reports Server" in the chapter "Configuring OracleAS Reports Services" of the Oracle Application [...]

I have developed ON LINE APPLICATION FORM using oracle developer suite 10g.An applicant apply for a post.He enter his details.Finally he click the submit button,the data stored in the database.Here i put one push button when i click the button
all the datas viewed in reports successfully.But i want the current applicant data only.In [...]

hello all,
i need your help with this. Frm-40508 oracle error: uable to insert record.
how can i solve this problem?
regards
me
Answer:Common reason for this error is insuficient privilege on the table
Answer:Go to "Help – Display Error" menu and see what the INSERT statement complains about.
Answer:Hi dear,
In forms 6i , you can find the error by going to [...]

I am facing a problem that in the table there are many duplicate key records and I want to query the distinct records in a form block using execute_query. If anyone knows about it, so please help me…I am in urgency….
Answer:Create a view asand use the view as data source for a data block. Or, [...]

Hi,
My Setting for icons are
Window Registry
[Key_local_machine]>[Software]>[Oracle] UI_icon D:\Assets\Icons
Registry file
Default Path=D:\Assets\icons
Default Extension=GIF
button property
Iconic= yes
icon filename=conn
But icon not display
Thanx for help
Answer:Hi ,
In "Registry.dat" file
alter path and type of your icons
In "Orien-web.xml" file
Alter virtual path of your icon folder
Copy your folder \forms\
Restart instance
Bye

hi experts…
my form multiple colums n rows just like this :
branch 9999 xxxxxxxxxxxxxxxxxx
slip no 99999999

no payee code payee name cheque date ref.no
———————————————————-
99 xxxxxx xxxxxxxxxxxxxxx [...]

Hi Experts!
I am facing a problem I want to calculate leave. In my form user enter a date time in format ‘DD-MM-YYYY HH24:MI’ and i want to add hours in this date time. I have another field in my form for hours. if user enter hours more than eight i convert it in days and [...]