Forms :: Oracle Forms Output Embedded In HTML File?
Jun 15, 2012
i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).
(1) now the rest of the page will be covered by the third frame in which the fmx's will run.
(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.
how to change base html page for Oracle Forms. I use Weblogic Server. Base html page - I mean this common for all forms as a background html page with "Oracle Fusion Middleware" text. I was looking something about this and I found that it is theoretically possible, but all traces reached me to the <Oracle_Home_path>forms/java directory which have only jars, with .class files.
When I run my report , I generate it in pdf format, and some fields in my report have persian characters so
1- I use Tahoma font, and
2- I have change my window registery to america_america.ar8mswin1256 also
3-I have modified UIFONT.ALI (but when I add tahoma font in this file , then I check the font in property menu of pdf file , its type is not change to type3---- I'm not sure about the modfication in this file----)
4- I have added windows/font path in report_path in registry
5- I made sure that there is tahoma.ttF in this path
but after opening PDF file ,those fields which are in Persian language (persian characters) are dipalyed in strange font.
The procedure below give me result of html code into the output :
declare l_page utl_http.html_pieces; l_url varchar2(20500) default 'http://htc.katalog-mobilov.sk/mobilny-telefon/htc-s620/'; begin l_page := utl_http.request_pieces( l_url); for i in 1 .. l_page.count loop dbms_output.put_line( l_page(i) ); -- exit when ( i =6); end loop; end;
But I need to get on the output for example from 15th to 50 records from html code.But how to do that?
Exporting text data from a table. Suppose I have a table of employees.
In oracle Forms. I make the two column of Hire_date1 and Hire_date2. When I put the Date Into Hire_date1 and Hire_date2 , And press push button. All the data save in text file C: emp folder.
i am generating report from oracle forms using web.show_document .pdf output is coming in seperate url.entire piece of code is working fine.now i want to store this pdf out put in client machine whether path will be specified by user.
After running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!
I am working in Oracle Forms 9i, and I have a requirement to copy or burn a file from hard-disk to CD. This should be automatically done at the press of a button in Oracle Forms.
I have already tried using the following statement:
out_Item := TEXT_IO.FOPEN('F:file3.csv', 'w');
where F: drive represents the CD drive. It threw an ORA-302000 error. How we can achieve burning a file from hard-disk to CD through Oracle Forms.
I want to read and write data from a file in | seprated mode. file READ and WRITE using Oracle Forms6i. I have a knowledge of file handling in C++ but not use it in Oracel Form before this.
Here i have one PL/SQL block which will returns the age of an employee using his id.
SET SERVEROUTPUT ON; DECLARE v_num NUMBER; v_days NUMBER; [code]...
It will returns an output of 27..I tried the same in Forms 6i using a text field and a button with a trigger "when_button_pressed". when i am entering the same id of employee i am getting a totally different answer
DECLARE v_num NUMBER; v_days NUMBER; BEGIN SELECT to_date(sysdate)-to_date(dob) INTO v_num FROM customer_details WHERE application_id=:block3.day; v_days :=floor(v_num/366); MESSAGE(v_days); MESSAGE(v_days); END;
It is giving me a result of -73...i cleared my problem. but i cound not understand the internal work happening inside the forms and pl sql machine.
i'm working on a project right now using Oracle Forms 6.0 and Oracle 9i. after i create a record and save the data in the table, how can i generate/create a text file of that particular record? i need this text file in order to run it in another computer and somehow upload the data in the text file to another database.
i will also need to create the text file for multiple records.
I downloaded Oracle Fusion Middleware11g Forms and Reports (ofm_frmrpts_win_11.1.2.0.0_64_disk1_1of1). When I begin to extract I am getting bogged down with a password message and that is:
File Windows-amd64 is password protected. please enter the password in the box below.
BTW- I downloaded Windows64 based forms and reports on my windows xp pro machine. I am trying to unzip them and burn it on a DVD so that I can install them on my new dell windows 7 professional laptop.
Recently i faced with a situation of redirecting a report output to a particular path in my server, and then opening the output by using web.show_document.
I was successful in redirecting it too a path , however i am not able to open the file using URL. We should setup virtual path in orion-web.xml and proceed further.
I pointed the output to an existing virtual path as below in my orion_web.xml file.
D:OraHome_2 oolswebhtml
and tried opening the output through the url
<<<server_name>/forms/html/filename.extn>>>
however i was not able to add new virtual path here .
I am re-developing some forms which were designed before on some other machine.
I cant able to run the form and not even to compile them. I am getting an error message like THE OUTPUT OF THE FORMS ARE UNABLE TO ADJUST.
I have checked the canvas dimensions like height and width that they are matching with that of windows of the form. I have also checked the values in formweb file. Everything is correct up to my knowledge. I have also ckecked the setting of LCD screen like it is 1024 X 768 resolutions.
after precompiling the cmpre.pc file, i got cmpre.c file. when i try compiling this .c file, am facing the following error...
servername:/.../home/usr/compile-> cc -g cmpre.c ld: 0711-317 ERROR: Undefined symbol: .sqlorat ld: 0711-317 ERROR: Undefined symbol: .sqlcxt ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
