Forms :: Organization Chart - Generate Automatically Without Opening Any Program
Apr 11, 2007
I need is to generate this chart automatically from the form builder without opening any program like visio (for instant). that's mean when I select the wanted department the chart will be generated automatically .
I am using org chart plugin to show the employee hierarchy, the plug-in is downloaded from
[URL]........
Current i uploaded the employee photo's in images under shared components -> files and referring in my query like below its working fine, but My question is how to refer employee photo's from table.
SELECT TO_CHAR (emp.empno) AS primary_key, TO_CHAR (emp.mgr) AS parent_key, emp.ename || '<div> <img width="100px" src="wwv_flow_file_mgr.get_file?p_security_group_id=' || :WORKSPACE_ID [code]...........
I have two control block i.e. class_register and student_info. In which student_info is multi-record block which contains stud_id, stud_name, stud_roll_no. Based on the class_register block, stud_id and stud_name is generated in the student_info table. Now I want to generate stud_roll_no automatically until the last record is present.
We have generated a fancy custom interactive report, in which the columns of string type, but can hold string, numeric or date values. However the type of values are uniform for a particular column. The end users wants to use the numerical values for generating charts, but, being a string column (though the data is numeric), it throws an error and they could not generate the chart. Is there any way to make use of this string column type numerical data for generating chart?
I need to generate a report much like a program guide from the script attached. My problem is that my script works, but it's wrong, all the information is wrong. Here's the two queries I came up with;
I would like to generate automatically at a certain interval a E-R diagram with all the tables in a schema and put the file on a certain location. My problem is the word AUTOMATICALLY. Toad Data Modeller does everything I want except this.
We have a problem while opening PDF through oracle forms, we are getting the folowing error in some PC's, but some PC's this is working fine.'there was a problem reading this document 14'.
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
There is a existing form B. From a form A I need to call form B on button press. Problem is form B has many tabs,It should open in the third tab when it is being opened from form A.
I have a multiple forms application and I use OPEN_FORM to call one form from another. However I want the new form to open in a separate tab ( the way it works in a tabbed canvas).
I have developed a new form.Something peculiar is happening for that form.Let me list down the scenario
1)In the data base for the particular table my form is using, there are 1600 records.When i do a Query on Count Hits in the forms,it gives the same number.
2)However when i open the form ,i do not get some of the records.I found that on opening the form and making an Execute Query only those records that i have added through forms exist.
3) However,when i try to add a new record and do an Execute query again,i get all the records present in the database.
My client is Oracle 10G DS Forms Developer. The application server is on a Solaris 64 bit sparc system. I have copied all the forms and libraries to my forms directory under C:DevSuiteHome_1forms10g_rel1 from the application server. and placed the following directory in my FORMS_PATH in the registry entry.
Now I am opening up the forms in my Forms builder and running the form. I get this error. I have the attached library in the form but I still get this error:
FRM-40039 Cannot attach a library while opening a form
I want to display different forms in one Frame/ canvas.when I press button Inventory then In the frame/canvas it should display Inventory form in the frame.If i press Employee it should display Employee form in frame.
In my Forms application, I must create an Excel sheet with data displayed by a pie chart, i.e. something like this
[URL]......
I'm able to create the Excel sheet by using OLE2 tool, but I dont know how to create and insert the pie chart. Searching in this forum, I found this post:
[URL].....
it's useful, but somewhat hard to understand. In detail, how can I set the form_charttype and form_chartsource so that it would produce my pie chart?
I have two graph pj item in oracle block one is pie chart and other is vertical bar graph... there is color display in bottom of pie graph which is red=50,yellow-30 and orange=20 ..and in vertical bar red=50,but orange=30 and yellow is 20 ..means orange and yellow is interchange in bar graph..how i can same the both graph value..
the graph is populate through cursor and graph properties is setting through set_custom_propert();
I have been requested to create an excel sheet report in my Forms application (10.1.2.0.2) with data grouped in a pie chart, something like the attached pic (if you cant open go to this link: [URL]
I'm able to create the excel sheet by using OLE2 tool, but I dont know how to insert my pie chart from code.
I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).
Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...
I have a program that was developed in Forms 6i.Actually, this program:
- reads a table with a Blob column that contains a MS Word format Document. - the document needs to be convert , then the program changes some variables that are wildcards.
In forms 6i I use a column with datatype Ole and the flowing procedure that read value from database:
PROCEDURE Pr_Abre_Contrato (pContrato In Contrato.Cont_Numero%Type, pQuery in Varchar2 ) Is Workbook OLE2.OBJ_TYPE; Application OLE2.OBJ_TYPE; MyDocuments ole2.obj_type; Args ole2.obj_type; vWhere Varchar2(200); [code]....
Now, I need to convert this program to forms10g. I opened the TAR in metalink and the Support said that exec_verb can not be used and it doesn't have another one to replace.
I have a master detail form based on two tables and i want to save the record automatically when the user exits the last field.how i can do it.which trigger is appropriate and what is the code.
How to change tab page automatically?I have two tabs.in first tab i have placed one button if i press this button first tab should be changed into second tab?