Oracle Forms
Oracle Forms
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Integrate this dialog fonts to work in Oracle forms 12c
I have created this one but need some updates! to get the values back and use them in oracle forms 12c.
I have created this one but need some updates! to get the values back and use them in oracle forms 12c.
See lesscalling report from formbuilder 6.0 in menu to run in web server
Hi @elhamkoockak what is the error message exactly and share your code to be able to help you. thanks
Hi @elhamkoockak
what is the error message exactly and share your code to be able to help you.
thanks
See lessHow to to check old and new values for item in Oracle Form ?
to get the database value there is one property (database_value) and here is the example to achieve this: [code] BEGIN IF :BLOCK.ITEM = GET_ITEM_PROPERTY('BLOCK.ITEM', database_value) THEN RETURN; END IF; END; [/code] sometimes this property return value (0) if so you can use another way : -take theRead more
to get the database value there is one property (database_value) and here is the example to achieve this:
[code]
BEGIN
IF :BLOCK.ITEM = GET_ITEM_PROPERTY(‘BLOCK.ITEM’, database_value) THEN
RETURN;
END IF;
END;
[/code]
sometimes this property return value (0) if so you can use another way :
-take the value in the pre text item trigger and keep it in global
– as about this value in when validate item trigger and so on
hope this may help you 🙂
See lessHow to validate phone number with specific format and fixed length ?
hello, you can use Format mask item property, it will handle the length along with format validation. you may enter this format mask ex: [code] 9"-"999"-"999"-"9999 [/code]
hello,
you can use Format mask item property, it will handle the length along with format validation. you may enter this format mask ex:
[code]
See less9″-“999”-“999”-“9999
[/code]
Repeat same previous record or item in oracle forms ?
You can use DUPLICATE_RECORD built-in
You can use DUPLICATE_RECORD built-in
See lessHow to pass date parameter to oracle reports from oracle forms
your code looking good but let me ask you some questions : 1- is your report exists in the directory you provide it to your code ? 2- is your report compiled and working fine itself ? then please share full error message and number with when this error is throwing. thanks.
your code looking good but let me ask you some questions :
See less1- is your report exists in the directory you provide it to your code ?
2- is your report compiled and working fine itself ?
then please share full error message and number with when this error is throwing.
thanks.
FRM-47001: Cannot create parameter list myparam : list with this name already exists
just you need every time to check if the parameter list exists.... If so , delete it before you try to create it. DECLARE pl_id ParamList; BEGIN pl_id := Get_Parameter_List('tempdata'); IF NOT Id_Null(pl_id) THEN Destroy_Parameter_List(pl_id); END IF; END; hope this helpfull :)
just you need every time to check if the parameter list exists…. If so , delete it before you try to create it.
hope this helpfull 🙂
See lessLoad image
firstly, try to read more about the webutil library.second, find below a basic code snippet to do the job: --this code to open uploading dialog box V_CLIENT_PATH := CLIENT_GET_FILE_NAME(DIRECTORY_NAME => NULL ,FILE_NAME => NULL ,FILE_FILTER => 'ALL FILES (*.*)|*.*' ,MESSAGE => 'Open a fiRead more
firstly, try to read more about the webutil library.
second, find below a basic code snippet to do the job:
--this code to open uploading dialog box V_CLIENT_PATH := CLIENT_GET_FILE_NAME(DIRECTORY_NAME => NULL ,FILE_NAME => NULL ,FILE_FILTER => 'ALL FILES (*.*)|*.*' ,MESSAGE => 'Open a file' ,DIALOG_TYPE => NULL ,SELECT_FILE => NULL); -- create directory on local machine at client server HOST ( 'cmd /c mkdir'||' "'|| 'C:tempapplication' || '"',NO_SCREEN); -- this code to show uploading progress to user V_SUCCESS := WEBUTIL_FILE_TRANSFER.CLIENT_TO_AS_WITH_PROGRESS (CLIENTFILE => V_CLIENT_PATH ,SERVERFILE => V_SERVER_PATH ,PROGRESSTITLE => 'Uploading file in progress' ,PROGRESSSUBTITLE => 'Please wait' ,ASYNCHRONOUS => FALSE ,CALLBACKTRIGGER => NULL);hope this may help 🙂
See lessHow to remove blank line when you create list item in oracle forms 10g ?
as per oracle forms online help: Forms maintains an additional NULL element in a list item List Items and Null Values ... Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if itsRead more
as per oracle forms online help:
See lessForms maintains an additional NULL element in a list item
List Items and Null Values … Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if its current value is Null or if its effective Required property is false.
CLEAR_LIST Built-in Clears all elements from a list item. After Oracle Forms clears the list, the list will contain only one element (the null element), regardless of the item’s Required property.