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 .
View 9 RepliesI 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.
View 4 Replies View RelatedWe 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?
The current version of apex is 4.1.
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;
SELECT CHANNELS.channel_NO,
CHANNELS.CHANNEL_NAME,
PROGRAM_PACKAGES.PACKAGE_NAME,
SUPPLIER_LISTING.PROGRAM_NAME,
[code]...
And
SELECT CHANNELS.channel_NO,
CHANNELS.CHANNEL_NAME,
PROGRAM_PACKAGES.PACKAGE_NAME,
SUPPLIER_LISTING.PROGRAM_NAME,
[code]...
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.
View 11 Replies View RelatedI am struck in a requirement to show the organization structure in a Top Down Organizational structure.
Is there any way we can make the well structured report OR form?
I am working with APEX 4.2. I have a schema with tables and views create and with data all tables.
Question : There is some way that I can generate automatically a application for all those tables & views. I remember that version 2 have this option.
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'.
View 5 Replies View RelatedWhen 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.
View 1 Replies View RelatedHow to work on forms without opened oc4j..
am working on 10G .. Forms 10G
am using the OC4J for the oracle FORMS 10G to me the engine for woring maybe about 20 client ..
my question :
1- if am close the OC4j the forms closed ?
2- how to work forms to be like off line if the oc4j is closed and working tell before save .. ?
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).
View 4 Replies View Related 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.
I would like to ask a very small question. what is the code that should be written to open a picture inside the button.
I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory:
F:AmjadAmjadamjad1.jpg
the name of the picture is taken from table1 the colum serial_number
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.
View 1 Replies View RelatedIn 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 a Cobol program that call C program above
#include stdlib
EXEC SQL INCLUDE SQLCA;
EXEC SQL BEGIN DECLARE SECTION;
char *uid = "puntos/puntos@cmrdesar";
[code]....
Are something wrong in C programm ? Pro*C code from vouters.dyndns.org/tima/OpenVMS-Cobol-C-Cobol_ passing_ variable_ number_ of_ arguments_to_C.html
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.
Attached File(s)
piechart.jpg ( 251.88K )
Number of downloads: 1
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...
when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies View RelatedI 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 forms 10g and use oracle database11. I have a form and I need to execute a program x.bat in another PC.
View 2 Replies View RelatedIf I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
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.
View 8 Replies View RelatedHow 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?
View 1 Replies View RelatedHow can I remove (record asved) message that come automatically after commit??
View 5 Replies View RelatedAfter compiling in few minutes My Oracle Forms 6i Form is exiting automatically ... How to solve this problem.
View 1 Replies View Related