daogu

What EXECUTE IMMEDIATE() does?
Answer:What pages did you read after you googled for it?
What exactly did you not understand?
Answer:PL/SQL User’s Guide and Reference
Application Developer’s Guide – Fundamentals
Regards
Michel
Answer:

azamkhan wrote on Mon, 14 July 2008 07:42

What EXECUTE IMMEDIATE() does?

What this question has to do with Forms?
Answer:If this procedure can run SQL statments then I have a requirement that [...]

Hi
The datablock have their own insert and query using thru commit_form.
The same, can delete using thru commit_form without explicitly using delete statement. But I fix the record which want to delete.
kanish
Answer:I’m sorry, but I don’t understand what you are talking about. Could you try once again, please?
Answer:I have [...]

hii all
how can i get the name of the current tab page name
Answer:Here’s one way to do that:

First step is to detect current item (which is, of course, on the current tab) using the :system variable :system.cursor_item.
Once you know the item, use GET_ITEM_PROPERTY built-in and search what ITEM_TAB_PAGE property returns.

Or, you might use [...]

Hi
How to align the object at very much center even maximize the form too.
kanish.

Answer:As far as I know this is impossible (unless you reformat your entire form in a form-trigger; not advisable).
I think the form-layout is defined and independent of the size of the window.
Answer:By the way, why did you add all [...]

hi ,
I’m trying to create a form for user privileges
with two tables :
at WHEN-NEW-RECORD-INSTANCE I use the following code to set a button enabled or not :
My question is how to get only one value for previous select statement.
thanks
Answer:Normally, if a select returns more rows than you wish/need, especially if the rows are [...]

hello all,
im using global variable to get the username in global.abc .
but when im try to use that global.abc from another form it does nt work.
can u advise me how to overcome this problem ??
login form
when button pressed trigger

enrollment form
when button pressed trigger

thanks in advance

Answer:

Quote:

it does nt work.

Meaning … what, exactly?
Did you check value [...]

From my form with a single button i need to display a report with a paramter. Report is displaying fine but the parameter is not getting passed. I did the following behined my button i add this code:
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
vParamValue number := 20;
BEGIN
plid := Get_parameter_List(’tmpdata’);
IF NOT Id_Null(plid) THEN
[...]

i have using forms4.5,reports2.5 in windows xp sp2.when i run in a particular report i got this error in particular computer only.
REP-3301:Error occurred in Error Checking(RXGLER)
Answer:You get an error in your report, so you thought "Let’s post it in the Forms forum"?
I have FireFox installed on my computer. Does that mean that I can post [...]

I have a project for school that I’m having a difficult time trying to complete. I’m working on creating a form with login canvas that requires a username and password. Once confirmed, the login should disappear and a tabbed canvas comes up. Note: the person has to be a manager that can [...]

The single sign on user application has been locked after 4 tries of unsuccessful password.
Now the account is locked how to release the lock.
Any idea how to resolve this.
Answer:I am SO sure that this can be found in the manual for the SSO-product..

How to store pdf or text file in oracle 9i and how to retrieve those file in forms 6i ?
Answer:I don’t know how you can do in Forms.
But i have done this in .Net.
The approach i took is that i converted PDF file in bytes and stored that in BLOB column.And then again while retriving [...]

Helloo
I need some help
actually have a table having attribute Citizen_id as primary key.
My citizen_id is of the form D001B001CTZ1,D001B001CTZ2,D001B001CTZ3,etc.
Now i want to arrange them in ascending order using order by clause.
It works fine until D001B001CTZ10 is reached.
AFter that it arranges as:
D001B001CTZ1
D001B001CTZ10
D001B001CTZ2
and so on…
please can suggest me how to prevent this and arrange to ids as [...]

I want to Migrate my forms from versions 6i to 10g . Is there any Patch or any other method like compiling all the forms one-by-one in Forms 10g.Plz Help
Thanx in advance
Answer:Visit Oracle Technology Network site and check Migrating Forms Applications From Forms 6i document.
Also, use OraFAQ Forum’s Search facility and search for appropriate keywords; [...]

Hi everybody!
I use the function web.show_document for calling a report in my form.The fact is i want to send my report to my printer.
In order to get that result i’ve setted in web.show_document the the following parameters like that:
REPORT_DESTYPE = Printer
REPORT_DESNAME= name_of_my_printer
When i run my form which calling the report on local host after creating [...]

I get this error. I dont understand why this problem occurs because I use SET_GROUP_CHAR_CELL, SET_GROUP_DATE_CELL and SET_GROUP_NUMBER_CELL Builtins and argument used in this BuiltIns correctly
Please Explain and Guide me what will be the cause of this error and what will be the solution
Answer:Unfortunately, I can’t help much. This is what Oracle says:

Quote:

FRM-40733: PL/SQL built-in [...]

I’m using forms 6i client/server, What is the best and rapid solution to migrate a lot of forms from 6i to 10g version?
Is there any tools for this issue or not? If yes,would you please send it to me?
Thanks,
MMRZ
Answer:Convert all the object libraries in batch, then all the PL/SQL libraries, then the menues, and [...]

hai all,
i have a form, in which there is a button called browse,while clicking this button, i have to get the same open dialog box.to accomplish this task, i used the win_api_dialog.open_FILE(’OPENFILE’,’$WINDIR$’,
[...]

Hi All,
I’m new in developing program.
As my company is using Form & Report Builder 6i. I would like to install the same program as practice.Otherwise I can continue my job at home.
But I don’t know how to get the software and how to install it.
Can somebody out there help me in to this problem?
Thank you
Answer:Oracle [...]

Hello,

I am getting this error while accessing the Oracle database through VB6.0.

Please help me out of this issue.
Thanks in advance.
With Best Regards,
Kumar.
Answer:Hi,
The error is
Error: ORA 3115
Text: unsupported network datatype or representation
——————————————————————————-
Cause: A user bind or define, or an Oracle function, is not supported by this
heterogeneous SQL*Net connection.
Action: Upgrade the older version of Oracle and try [...]

Hy,
I am using forms 6i 10g DB. In master detail form, in detail part, i am showing 10 records. Based on certain condition i want to make update property false for LINE (whole line , not item not all lines , only one line) .How can i do that.
I tried with set-item-instance-property [...]

I created that table :-
and in forms 6i ….. I determinate col1 as the value for "Synchronize with Item" .

and when I test it in runtime , it work correctly and after I saved the data and get out of forms and went to database to ensure the data existing … I surprised that the [...]

hi
how can i see files/folders with for example browse button in form
and access to they ?
Thanks …
Answer:Hi
You can use
DECLARE
N VARCHAR2(100);
BEGIN
N:=GET_FILE_NAME (NULL,NULL, NULL, ‘OPNE’, OPEN_FILE, TRUE);
END;
.For more information search for GET_FILE_NAME..
Regards
Sinida

Hi freinds,
I have three radio buttons in form. muslim, non muslim and all. While i am querying , if i seletected
muslim radion then religion muslim only should be come. Non muslim means except muslim should come. (that is hindu,christian)
radion button all means , all religion should come. How i can achieve this?
Thanks
Manohar
Answer:Depending on the [...]

hi
i must execute form project on, for example standalone client or customer pc but form project
is fmb | fmx how can i convert it to exe or execute application please help me ?
Thanks …
Answer:I assume from your other questions that you have solved this problem and can now run your forms.
David

Hi,
I am trhying to change the look and feel of my forms10g,but for that according to the document attached i need laf.jar and laf.pll.where can i find all these files.
I checked and downloaded from the document link but i couldn’t find the jar file.
Can anybody help.
Thanks,
Srinivas
Upd-mod: Please don’t post documents that are under copyright. [...]

I have oracle form 6i on my laptop and I connect to the oracle 9i data base through the network to the server.
I wanna load a java file to the data base by using the following command:
loadjava -u username/password@netservice name resolve ‘ava file name’
but I face with the following error:
loadjava is not regognised as [...]

I m using Oracle 10g forms in windows XP now i want to show icons on my buttons can anyone guide me the whole procedure to show icons
thanks
Answer:Please search this forum for ‘icon button’. There are numerous threads.
David

Hello,
I am currently learning D2000. I just want to know if PL/SQL is capable of "macro substituion" wherein a command/literal can be manipulated dynamically during runtime? For example, an SQL statement for a CURSOR that can have various "WHERE" clause depending on satisfied conditions.
Answer:Yes, use dynamic SQL.
Regards
Michel
Answer:Hi Michel,
Dynamic SQL was great! However, when I tried [...]

Hi,
I need your help, I need to know all the tables that use in a form, and not manually, tables use in a Datablocks, procedures, triggers,recordgroups, eixste any automatic way that I can obtain that information? maybe in an xml way?
thank you for your help and Sorry for my english
Answer:Yes, convert to ‘xml’ and use [...]

We are having an issue with a custom form which is causing locking problems in the database. The scenario is this:
We have a form which allows the user to edit a simple table, there is a system defined numeric field, two varchar2 fields and a CLOB.
When using the form for one thing like pulling [...]

Hi to all,
i have a form it is cheque form we need if we paid multiple bills against the single cheque then these bills must be deleted from the other table like entry table,vendor table etc.
how it is possible. give me any suggestion.
i am waiting for reply.
Answer:WHEN-BUTTON-PRESSED trigger, in its simplest form:Of course, you’ll have [...]

Hello,
Any suggestion on how to convert (downgrade) a forms built using Forms version 10.1.2 to version 9.0.4, without corrupting the form?
Regards,
Eric
Answer:What message are you getting at the moment when you open a 10g form in 9i?
Perhaps try converting 10g to ‘xml’ or ‘fmt’ and see what happens when you do the conversion into 9i.
David

i have a problem. i am working with forms builder and report builder. how do i link a button a form to a report?
Answer:Search this forum for ‘button form report’.
David
Answer:hi shell,
try it u will get the answer hint is add a push button in form and attach a when-button-pressen trigger
Ashu
Answer:I thought he was after the [...]

Hi
I am trying to calling REPORT from FORM using 9iDS but recieving error message "FRM-41219 cannot find report : invalid ID".
I am using following code to call report.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT(’proposal’);
v_rep := RUN_REPORT_OBJECT(repid);
END;
while proposal report is located at "C:\GLIS_PROJECT\REPORTS".
I have also set Reports_path parameter according to this path.
please somebody tell me how [...]

why bevel not working on button but in text box any way to use bevel on button

thanx in advanc
Answer:A button is always ‘raised’. There is no option.
David
Answer:thanks for reply
but in when we bulled a form then all buttons of toolbar are
looking like bevel property none
i do’t know more can u explain this [...]

hi,
i want ro read an html file using text_io and replace a particular text with a new text
eg: i want to replace a text called "data.js" and with "maps.js"
how do i do this?
Answer:You read the old file, do an ‘instr’ to find the text, use ’substr’ to build the new line, then write it to [...]

i have made a horizontal toolbar canvas can_tool in form too_bar
and after that in new form canvas subclass property object as can_tool of too_bar and property class property of can_tool
and chage form property form horizotal toolbar property as canvas
inherited but it not working mean item button not coming in this form
i want same tool [...]

hi
i want create this picture with form developer
i think,must use 3 canvas.
can anybody create it for me ?
Thanks …

http://img2.freeimagehosting.net/uploads/f035592a96.jpg
Answer:The site on which you placed your ‘jpg’ is ‘restricted’ for me. Please post the image against your thread.
David

Hi all
I have enabled the default&smartbar in my form…but i wanted to know if i could disable the print button on the smartbar or make it password protected…is there a way i can do that???
pllzz help.
Regards
Answer:Have a look at http://www.orafaq.com/forum/m/87656/67467/?srch=smartbar disable#msg_87656
Look at the online help for ’smartbar’. Look [...]

Hi,
When I run the form, it is creating *.(i)htm, i will be randomly generated.
Please anyone suggest how to configure forms servlet, so that it creates an html file and directly run from there.
The text in the file is as follows
<html> <head> ORACLE FORMS.</head>
<body onload="document.pform.submit();" >
<form name="pform" action="http://murali:8889/forms90/f90servlet?config=sepwin" method="POST">
<input type="hidden" name="form" [...]

Hi Friendz,
Do anyone used MICR Font included in work.It will be a favour some one replies . Urgent!!!!!

Thanks In Advance..
Govardhana
Answer:I’ve never heard of the "MICR" font; is it a font name, such as Arial, Tahoma, Courier etc.?
Even if someone did use it, what about it? What would you like to know (i.e. what’s the question [...]

Dear all experts,
I have a form which make use of the WEBUTIL_HOST.HOST command to call up a VB application, it is successfully done. However, the VB apps need to be closed before the focus can go back
to the Forms application.
My question is : Can I start up the VB [...]

Hi,
How to apply the format mask to give the output like the below:
Eg: data is like 1234567890, output should be 1234.567.890.
As per American standards we can use ‘NNNNGNNNGNNN’. It will give output like 1234,567,890, but i want to give the output like 1234.567.890.
Please help me to solve this problem.
Regards,
Rajesh
Answer:It is about decimal and group characters; [...]

Dear All,
I have 4 fields in my form ,all of them LOV’s.What I want is that when i give empty spaces in the 1st lov field and then type the correct values(i.e one of the correct value of the Lov), i dont want want the lov to pop up. It is working for the [...]

hi all..
can you help me alter my form.i want to key the card no after select the card type.but when i wrote the next_item it still can’t work.
the existing form is key the card no during correct / view mode.
but now i want key in the card no during add mode after key in card [...]

i have entered a value in the text box of a form
and i want to get that value at another form
[MERGED by LF]
Answer:hi
how i can get a variable in different form / where it have to declare & how
badal
Answer:The most common way to do that is to use GLOBAL VARIABLES or form PARAMETERS.
Answer:Hi [...]

Dear Techies……..
I am using Exec_SQL to update main table from remote site, the problem is that, to increase the performance there is no select statement included in the code, it straight away updating the main table without any checking, but we want to know the success of the update statement, we used EXEC_SQL.LAST_ROW_COUNT [...]

I’ve finished a form design and clikced the RUN FORM button. The IE 7 window appeared for several seconds and then shows "Internet Explorer has stopped working".
Anybody has any solution to the problem ? Thanks very much !
Answer:The message is:
fault address:6D440B58 01:0004FB58
C:\PROGRA~1\ORACLE\JINITTI~1.22\BIN\HOTSPOT\JVM.DLL
Answer:It seems that JInitiator has problems; did you try to reinstall it? (Looks like [...]

I am developing a database using oracle 10g, and an application using Developer/2000 6i.
What should I do at the server side and the client side to be able to enter data using three languages: Arabic, English and Russian?
Answer:Search this forum for ‘nls arab’ and ‘nls arabic’. There are a number of good threads.
David

Anyone have the concept how to create Reminder in Oracle forms?
please can someone give me detail explanation, how to design the reminder in oracle forms.
Regards
Answer:Have you solved your problem?
David
Answer:Hi dj,
No i didnt solve can you help me to solve this problem. if u have any sample or how to work on this please give me [...]

hi
please help
i have problem with FILE_OPEN_DIALOG
can anybody create a sample fmb for me ?
Thanks a lot;
Email : m_redford2236@yahoo.com
FILE_OPEN_DIALOG (DIRECTORY_NAME IN VARCHAR2, FILE_NAME IN VARCHAR2, FILE_FILTER IN VARCHAR2, TITLE IN VARCHAR2)
RETURN VARCHAR2;
Answer:Search this forum for ‘FILE_OPEN_DIALOG’.
David

Dear All
I have a sno (seriel no) column and weekday column in z1 table that contain 1000 records ,I have one more empty table name as "cust_info" that contain the same field sno (serial no) and weekday.(same datatype of sno and weekday between both table)
I want to insert "weekday" column data from z1 [...]

Hi all,
I have 3 blocks namely block1, block2, block3
block1 is the master of block2 and block2 is the master of block3
block1 = 1 record
block2 = 2 records
block3 = 2 records
relationship is cascading
i am trying to delete record in bock1 so that i also delete record in block2 and block3 automatically
i can delete record in block1 [...]