daogu

Hi Experts! I want to display calendar on my form. i attached calendar.pll library. remove path confirmation if i remove path it generate error i.e. FRM-40039, but if i dont remove path it run welll on my computer but it cant run on any other system in network. my forms and calendar.pll and .plx file [...]

Hi,
I had created a PL/SQL library with 1 function then I had a need to add another function but it does not allow me to do that.
Attached is the screen shot. Calculations was the first library in which there was one function (calc_sln). Then I had to add another function (calc_pmt) to it but could [...]

I have a control block wherein i have a text field
PO_NUMBER, I want to enter a value here, and populate data
…
its database item – No
query allowed – yes
insert allowed – No
update allowed – No
it is under one control block, whose properties
database datablock [...]

Hi,
Below are the codes I tried in the WHEN_BUTTON_PRESSED trigger on the CONSULTANT button (screen shot attached) but the form (RDC_CONSULTANT) is not opening. Would you know the reason why?

RDC_CONSULTANT form is in the same folder where the form with the consultant button is (RDC_MAINPAGE).
Answer:Hi,
I could open the form, surprisingly with the same command

Quote:

open_form(form_name);

I don’t [...]

Hi,
I am trying to create mailers for customers from forms (using MS Word) but not able to integrate it properly.
Attached is the error which occurs when I try to open the template for the mailer. As seen I have mentioned the template name (template.doc – kept in the MSOffice home) in the text box (Template [...]

Does anyone know if Developer 6i is compatible with Windows Vista ? Are there any issues out there ? I’m about to install Developer on a Laptop w/Windows Vista, but i’m still shy with the compatibility thing. Any comments ? What do you think ? Any tips or helpful answers ?
Answer:As far as I can [...]

I want to upload excel data in my application frequently.
so pl. give solution for this. give me a example for emp table.
i am using form6i.
Answer:Have you solved your problem? Have you worked out how to search this forum for ‘excel’? Have you read the documentation for your database which shows how to [...]

Dear all,
I have desire to attach flash files in oracle 9i form,
Pls help me to do this….

Thanks in advance
Answer:Search this forum for ‘flash’.
David
Answer:Dear David,
I did search the forum but got nothing.
Can you please help me?
Regards
Sultan
Answer:Perhaps you should look at using a Java based flash player. Googling ‘java flash’ returned http://www.flashmagazine.com/tutorials/detail/getting_across_to_flash_with_java/ and http://www.jpackages.com/jflashplayer/
Try [...]

Hi,
I have a Multi item From clause block.I want to relate it to a Multi Item datadase block(from table). I have created an isolated relation between them. I have removed copy value item from the item of the database block.
Now the problem is say i have 20 records in the From clause block and [...]

Dear all,
I need to open a excel file on web by using DDL (forms10G)
i have written a code like below it is working fine in local meachine but not in web please help me to do this
Declare
M_APP_ID pls_integer;
M_CONV_ID [...]

Hi Guru,
I want to use Microsoft Winsock connect between VB.NET and Oracle Form6i.Anyone has a sample source of Oracle Form6i? or any advice.
Thanks a lot
Pitiporn
Answer:Did you find anything by searching this forum or google?
David
Answer:Hi David,
Found nothing.But I can make Socket in VB.net and Socket in Oracle Form 6i listen to [...]

Hello! I am telling my problem, Please help if anybody know the solution.
My oracle 10g database is located on remote PC. (Application server is not present) Person on client PC, generates excel sheet. I want to develope the client server application or web application (if possible because application server not present.) which will have GUI [...]

hi, all
I’m using the following procedure to call Reports within form
and define the report path within the NODE REPORT within the module ,
please, how could I use MENU to call the report
thanks
Answer:Have you tried writing code that calls this procedure from a menu?
David
Answer:

djmartin wrote on Thu, 07 August 2008 01:55

Have you tried writing [...]

I am adding to a global variable in a form everytime a button is pressed, when the global variable gets to a certain number it gives me an error ORA-06502, is there a maximum length on global variables:
:global.old_emp_no := nvl(:control_x.empl_num_view, 0)||’, ‘||:global.old_emp_no;
:global.old_emp_no:= vnum;
when I am finished adding to the global variable I use it [...]

hi
can anyone write me a procedure to run any report from a menu or from button and to hold parameter or not??and where to place that procedure??
many thanks
I’m using developer sute thanks
Answer:What version of Forms are you using?
David
Answer:Sorry for late
I use developer 9i
Answer:Search this forum for ‘web.show_document’. There must be close to thirty [...]

Hi dear
i am getting problem in forms6i. i Have three block 1.asg_tas_temp,2.asg_tas_abs,3.asg_tas_emp_class.
i am getting data in asg_tas_temp in asg_tas_temp id employee is abesent then it also come in asg_tas_abs block but in this block i am not geeting all absent data only i am gettin last record data please help me.
i have written this [...]

Hi Guyz,
can anyone help me to change the visual attribute of the window.
i wanna to change the color of this windows please find attach example.
Waiting for replies….
regards
Answer:Looks like a scheme in a windowmanager to me. Don’t all your windows look like that, also for other programs?
Answer:Change your appearance at Display Properties , and you won’t [...]

hi I am having pdf file in client machine.I want to store it in the database. I am using Oracle 9i and Forms 6i.
Answer:Search this forum for ‘blob pdf’. This is a common question.
David
Answer:I am searched but not yet succeed.please help me.i need coding for that one.
Answer:What’s wrong with http://www.orafaq.com/forum/m/338000/67467/?srch=blob pdf#msg_338000
David

Friends,
We have oracle forms developed by developer 6.
I have installed Oracle application server 10gR2 (10.1.2.0.2) in RHEL AS 4 Update 5.
I have installed Oracle Developer Suite 10g in Windows XP.
I created a simple form with a single button in developer 6. then i compiled that form in 10g compiler and i tested it in windows [...]

hi all,
i need some feedback of my problem. When i run forms, the Explorer 7 shows me java.lang.class notFoundException:oracle.forms.engine.main
how could i run oracle forms successfully? Regards, i have local database and i check form path.
Answer:Here is what we know.
1) You have a problem
2) You are using IE7
You’re On Your Own (YOYO)!
Answer:yes, i use IE7. what [...]

Dear Sir,
I am using this trigger on NEW_FORM_INSTANCE
logout;
logon(’scott@local’,’tiger’);
execute_query;
where scott is username , local is my DB string and tigger is password.
I want to perform two different tasks on
either successful log on or failure.
if logon is succcess then
execute_query;
else it must show some cuomize message….(you are not logged on)…..
how is it possible?????
regards.
Answer:try [...]

I read the BOOK web_util.pdf from :-
http://www.oracle.com/technology/products/forms/htdocs/webutil/webutil.htm
and after I attach the webutil.olb , webutil.pll to WEBUTIL.fmb ……. like in this image :-

and in the beginning Run Time this message appear to me :-

, I want to know what’s went wrong here ?
– I attach the Fmb file ….. and for webutil.olb , webutil.pll they exist [...]

Mr Martin,
I had a simple open_form query if you could help me out

Quote:

http://www.orafaq.com/forum/t/123107/117164/

I have not received any reply for sometime and thought you may have the answer to this one
- Thanks
Answer:Durgadas,
Please do not hijack another person’s thread.
David
Answer:Would take care…

please correct me if i am wrong
cust_po_number is a varchar column….so i am trying to
build the where clause here…..i know for sure that
one single quote should be replaced by three if we want
to include a varchar colunmn..so is the above condition
valid one?
Answer:try this

Answer:Why not simply
Answer:Dear Littlefoot,
I Think your code will not work as CUST_PO_NUMBER is [...]

Hi guyz,
Hope everyone is well here…..
guyz is there any way to get system hardware information in oracle forms?
like i want to take the system inventory may be system on network or locally connected
Inventory like
RAM
CPU Type
NIC Card
VGA Card
Sound Card
like the devices attach in Device Manager in my computer properties
Waiting for good replies from Guruzzzzzzzzzzzz……
Regards
Answer:come on guyz [...]

hai,
I have a problem of going to specified record in a block which contains some 600 records.now i want to go to a particular record
for example
my block is like

partno partname type
1001 sample 1
.
..
.
3000 sample 3000
I HAVE ONE TEXT ITEM,IN WHICH I WILL GIVE INPUT(PARTNO),THEN THE CURSOR [...]

Hi,
I am creating form that will print resumes of candidates. I have created a table (RESUMES) which will store the candidate name and their resume in the database.
The attached form (character_display.gif) displays one record of the table. As seen the name column (varchar2(50)) displays the name ‘Durgadas’ but the resume column (clob) does not [...]

DECLARE
CURSOR COUNTRY_CURSOR IS SELECT COUNTRY_NAME,CNTRY FROM COUNTRY;
BEGIN
FOR COUNTRY_REC IN COUNTRY_CURSOR
LOOP
ADD_LIST_ELEMENT(’COUNTRY’,(COUNTRY_CURSOR%ROWCOUNT) 1,
COUNTRY_REC.COUNTRY_NAME,COUNTRY_REC.CNTRY);
END LOOP;
END;
I want to populate the list items at run time. I wrote the above code in when-new-form-instance trigger. But when I run the form I recived a error
FRM-30085: Unable to adjust form for output.
Answer:And what happens when you run the program when [...]

HI EVERYBODY
I HAVE WRITTEN THIS CODE IN POST-SELECT BUT IT IS GIVING ERROR
DECLARE
CUR_ITEM VARCHAR2(80);
CUR_BLOCK VARCHAR2(80):= :System.Cursor_Block;
BEGIN
CUR_ITEM := GET_BLOCK_PROPERTY(CUR_BLOCK,FIRST_ITEM );
WHILE (CUR_ITEM IS NOT NULL )
LOOP
CUR_ITEM := CUR_BLOCK ||’.’||CUR_ITEM;
SET_ITEM_INSTANCE_PROPERTY (CUR_ITEM,CURRENT_RECORD,VISUAL_ATTRIBUTE,’DISP_ONLY_LOOK’);
CUR_ITEM := GET_ITEM_PROPERTY( CUR_ITEM, NEXTITEM );
END LOOP;
END;
I AM NOT COMPILING IT IT GIVES ME ERROR
PLEASE HELP ME.
Answer:If only we [...]

Hi, i can´t activate shortkeys f7,f8 and f10 on forms 9i.
Please help me.
thank’s
Answer:What happens when you press them? Do you have a ‘key-others’ trigger defined? What does ‘Ctrl-k’ show when you press it?
David
Answer:I pressed ktrl-K, but the shortkeys is congurate for others functions.
How to modified this keys ?
Thank´s
Answer:What does F7, F8, and F10 [...]

Hi every one ,
I want to remove the window menu from the default form’s menu.
can anyone help me in this regard.
Thanks in anticipation.
Answer:I don’t think you can. See http://www.orafaq.com/forum/m/170139/67467/?srch=window menu#msg_170139 where a similar question was asked about the ‘help’ drop-down menu.
David
Answer:Try this method:
Create menu item with label WINDOW and set the property to Magic [...]

Hello all,
Can anybody have oracle form builder 10g release 9.0 advanced tutorial ?? please?
Answer:Yes.
David

have a OCX that run correctly in Vbasic.NET and VBasic 6.0. I want to implement this OCX in Oracle Forms 10g .
How can developer my own OCX to Oracle Forms 10g import all methods?
i read OCX Calendar Control 9.0 but i dont know how can convert method in vb to oracle.
this program with vb [...]

I want to open the attached library to a form for review and edit. I am working Oracle 10 form tool. The libraries are present in the forms90_path and have no problem in opening the form. Please let me know how to open the library for viewing and editing. Thanks.
Answer:Press ‘open’, select the ‘pll’ file, [...]

I have developer 2000 installed, and i have a server a 8i database installed.
I install 10g form in my pc, a problem occured the sql plus can not connect the database on the server, either sql plus on the developer 2000.
How i can do that i can connect the 8i database? without uninstall the developer [...]

Hi
i am using 10g form builder and charting by bean item.
i want to show y-axis values in header of bar like the picture attached.
Thanks
Answer:Did you solve your problem?
Which bean item are you using for graphing?
David
Answer:Thanks
i am using BI Bean Graph version 3.2.0.25. and my problem it solved but i need miner modification.actualy i want [...]

on Exit ,
i write exit_form ,
but this close the form inside the window but not the browser in which it is opened.
kindly tell how to close the window.
Regards
Imtiaz
Answer:Search this forum for ‘close browser’. [...]

Hi dear All Gurus
i need one solution.
i have three block in in block i have got data and i need
when if user want record post so user click the recod after that he click the button after that record post another block
i have written this query it works but i need if record [...]

please
i am using oracle forms 6i and using bcd32 ocx and write the following code
x1 := BCD32_DBcd32.OpenComm(:ITEM(’Bcd32′).interface, ‘COM7′);
x2 := BCD32_DBcd32.ReadNow(:ITEM(’Bcd32′).interface);
x3 := substr(x2,3,7);
:sin_load.QTY := x3;
commit;
x1 := BCD32_DBcd32.CloseComm(:ITEM(’Bcd32′).interface) ;
the code work fine and very good when i run the form in the debuger (:sin_load.QTY := value) but [...]

I am using oracle 9i and forms 6i.I want to store client side pdf file into oracle database.i am searched but not yet succeed. If anybody know please tell how to do this.
Answer:I would say try writing a function that stores clob datatype in the table. Call the function from the client form (6i) and [...]

hello all
when we use subclass attribute i general? how can i put 3 canvases inside main one canvas?plz
Answer:What is "subclassing" can be read in Forms Online Help System. Search for "About Subclassing" (and, possibly, follow links you can find at the bottom of this section).
How to put 3 canvases into another one? You can not. [...]

look for this image :-

when I press >> or > for clear columns like ( INSTNAME , FAX ) no problem happened ….. but when I press >> or > for unclear columns Like ( Mobile Number , Home Number , E-mail ) nothing happened , just didn’t pass , and I don’t know what’s [...]

HI Guyz
I m haveing some problem anyone could solve my problem
i have four tables whic 1 is master and the rest is details and the common field is systemid.
example
Table A (system_master)
1) systemid primary key
2) empname
3) dept_id
Table B
1) systemid (ref from table a )
2) pc_name
3) dept
Table C
1) systemid (ref from table a )
2) hardware_info
3) pc_hard_info
Table D
1) [...]

i have downloaded some demo(forms library icons) and the tables i have already with me in my local database. But when i run the form, the compiler doesn’t identify the names of each tables which wrote you must declare the name first of course in my pl/sql blocks.
should i change physical path of something? [...]

Hello all,
There is an idea requested by my manager and i wanted to check whether it could be handled or not and how..
I am working in oracle forms 10g… and you can say that i am a begginner. I have a date input field, when the user double click on it, the calendar should be [...]

HII
I am using oracle developer10g relase 2 , the icon is not
apperane in tree ???
the all configration is true and the picture is apperance
in button but in tree no .

you can check that in attach file ( exam of tree )
– change the extension attach to zip

you can help me …
Answer:Search this [...]

Dear forum,
I am a DBA and have to told to convert an existing form into another language and chacracterset.
My existing form is in english and i have to esign a form in local language(HINDI-iNDIAN LANGUAGE)
The goal is to check that i am able to send the data in a form which is written in hindi [...]

Hi,
I have a procedure that contains a varchar2 variable,now i need to create a text file in from procedure and move varchar2 content into the file.
Can any one help?
Thanks in advance
Answer:
You Can use Text_Io package to create text file in front end. In Stored procedure we can use utl_file package.
Ex:
Answer:Thank you [...]

Hi All,
I have some mess in my Jinitiator options. When I’m working on Oracle Ebs forms they’re behaving really strange.
First of all when I’m opening my java console I can see many posts with "WARNING: Unable to cache https" on the top of the window I have:
Oracle JInitiator: Version 1.3.1.18
Using JRE version 1.3.1.18-internal Java HotSpot(TM) [...]

Friends,
when i type….
http://appsworld.ncc.com:7777/forms/frmservlet?config=nmsapplication&form=test.fmx
it says….
The requested URL /forms/frmservlet was not found on this server.
formsweb.cfg contents……
and default.env is….
what to do? where iam making mistake?
thanks
Answer:Have you solved your problem?
David

hello, im kinda new to oracle 10g and i have a problem when i assign firefox in the preferences tab of forms builder in the runtime.
i get the error
Telenet
Network Error (dns_unresolved_hostname)
Your requested host "pc_van_gerrit" could not be resolved by DNS.
For assistance, contact [...]

Hi !
I have a problem with fonts. One of my reports need a font to display correctly. This font is on the AS. From Forms, I call the report and I use the procedure "WEBUTIL_FILETRANSFER.AS_To_Client", "C:\windows\fonts" (AS side) to "C:\windows\fonts" (client side), but there’s no file transferred. In fact, when I use "C:\", it works [...]

Hi,
how i can shift some part of text to next line in a text item or in alert message text.
Thanks in advance
Answer:the Character of Ascii Code 39 allow is for new line. You can use CHR(30) to shift text on new line, this may be done in alert message but you cannot shift a text [...]