Forms :: How To Run Oracle Form Server 10g From IPhone

Sep 27, 2013

How to Run Oracle Form Server 10g From IPhone

View 3 Replies


ADVERTISEMENT

Forms :: SQL Server And Oracle In A Single Form

Apr 23, 2011

can I query sql server and oracle in a single form

View 1 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

Sep 23, 2011

I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.

Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.

View 5 Replies View Related

Forms :: 10g Server - Access Each Form Via Button

Mar 30, 2011

i am building a system and have created some forms, but when i view them on 10g server online i only want each form to be accessed via a button of which i have placed code to go to that block. not be able to use the arrows to skip.

View 1 Replies View Related

Forms :: Removing / Changing Form On Server Does Not Affect Anything?

Sep 15, 2011

Actually, i found that some forms if they are changed (like some buttons/text fields/code added to them) and this change can be saved and there is no errors in compilation. but when this form is run from the application, the change is not visible.

Even if the form with the image is removed from the directory, it still runs from the application link. Is there some memory issue or anything else.

View 2 Replies View Related

Forms :: Migration Of Oracle Form 10g To 6i?

Apr 19, 2011

Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.

View 1 Replies View Related

Forms :: Matrix Form In Oracle

May 20, 2013

Is there any possibilities to make matrix form just like matrix report.

one is the month column which increase horizontally other is emp_name column which increase vertically and sal column which show the salary of each employee in each month.

View 1 Replies View Related

Forms :: Why Other Browser Cannot Run Oracle Form Without IE

Oct 9, 2012

Why Other Browser cannot run oracle forms without IE.

i want to use other browser for oracle form like firefox,google chrome etc not IE.

View 11 Replies View Related

Forms :: How To Convert Oracle 10g Form To 6i

Oct 24, 2013

How to convert Oracle 10g Forms to Oracle 6i Forms ?

View 2 Replies View Related

Forms :: Oracle Form Entry?

Feb 25, 2010

i am new to oracle form , i am using orcale 10g forms, i have following requirements.

1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).

i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form

View 3 Replies View Related

Forms :: Parametrized Cursor In Oracle Form

Dec 7, 2011

I am creating a button , on this button i call a procedure

e.g. excel

on this procedure i call parametrized cursor ...but i give me error i dont know what is this ..my code is like this

Quote:
PROCEDURE excel IS
CURSOR C2(v_link_nm varchar2) is
select alt_loc LOC, alt_inv_no INV_NO, alt_inv_dt INV_DT, alt_amt AMOUNT, alt_rvc2 ALT_RVC,
alt_doc_no DOC_NO, alt_doc_typ DOC_TYP, alt_authid AUTH_ID, alt_authdt AUTH_DT
from v_link_nm
[code]......

when i compiled i get error v_link_nm not defined...

View 1 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related

Forms :: Possible To Alter A Session Within Oracle Form

Sep 3, 2010

Is it possible to alter a session within Oracle forms as I get the following error when trying to compile the following block.

BEGIN
EXECUTE IMMEDIATE ( 'alter session set nls_date_format = 'DD-MON-YYYY''');
END;

Error: Encountered the symbol "IMMEDIATE" when expecting one of the following

The basic requirement is to validate a date field on the form against the current system date, but as the form is in format DD-MON-YYYY and the Database on M/D/YYYY I am struggling to compare dates successfully.

View 5 Replies View Related

Forms :: Remote Form Debug In Oracle 10g

May 12, 2010

I am trying to debug a remote form ( on AS) in Oracle forms developer 10g . I had done everything as told and attached the port name and number to my local form builder, but debugger window doesn't popup at the time of break point. Also, i don't have any firewall installed on my application server.

View 1 Replies View Related

Forms :: Draw Diagram In Oracle Form?

Jan 27, 2012

I want to draw a diagram in oracle, how do i do?

View 4 Replies View Related

Forms :: Oracle 10g Key Combination To Call Form Trigger

Nov 11, 2009

I need to fire the KEY-DUPREC trigger as I click on the key combination Shift+P therefore; I added the following line of code in the frmweb.res file.

80 : 1 : "Shift+P" : 64 : "Duplicate Record"

It worked iff no error was raised. So, if I have a raise form trigger failure in the KEY-DUPREC trigger, a capital P will appear in the text field that called the trigger.

View 2 Replies View Related

Forms :: Display Image On Oracle Form Through Backend

Dec 17, 2011

I am successfully insert image in DB now...now my task is i want to retrieve this image on my oracle form.

my structure on table like this..

CREATE TABLE temp_image
(
ID NUMBER,
image_filename VARCHAR2(50),
image BLOB
);

i inserted 2 images on that... now i want to retrieve it , how to achieve this.

View 6 Replies View Related

Forms :: How To Send Automated Email From Oracle Form

May 10, 2011

I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,

View 1 Replies View Related

Forms :: Tab Page Text Color In Oracle Form?

Jul 19, 2013

i have the two tab pages in canvase...one is for the personal page and other one is the education. now i want to change the color of the text like personal and education.

i want only change the text color of label not the background color...

View 4 Replies View Related

Forms :: Running Form On Oracle Developer Suite 10g

Jul 2, 2011

i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890.

View 20 Replies View Related

Forms :: How To Get Current Cursor Position In Oracle 10g Form

Feb 25, 2010

I want to get current mouse cursor position dynamically,what should i do.

View 3 Replies View Related

Forms :: Consume A Webservice And Use In Oracle Form Developer 6i

Dec 26, 2011

I write a Function in PL/SQL to consume a webservice and its working fine when i run in TOAD or SQL terminal. But when i try it from oracle form developer 6i , it gives me the following error :

ORA-00600: internal error code, arguments: [26599], [1], [211], [], [], [], [], []

View 16 Replies View Related

Forms :: Call Oracle Form Using Stored Procedure?

Mar 14, 2011

How to call Oracle Form using a Stored Procedure?

Under

create or replace procedure ........

Begin
.......

End

Inside such procedures , is it possible to call a form ?

View 4 Replies View Related

Forms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop

May 20, 2010

We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.

My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:

Failed to load the following objects: APPSTAND, etc etc.

Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?

View 2 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If 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]......

View 14 Replies View Related

Forms :: Oracle Form Login - No Warning Message After 5 Minutes

Nov 11, 2009

Is there any way to make a form timeout.

After login into form if there is no transaction/event happens I want it to throw one warning message after say 5 minutes.

View 9 Replies View Related

Forms :: How To Create Browse Button In Oracle Form Builder

Mar 19, 2010

I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?

View 1 Replies View Related

Networking And Gateways :: Oracle Forms 6i Call Form Via Static IP?

Sep 6, 2011

I had a query related to call_form function in forms 6i.How can I call a particular form via static ip(outside LAN),but the actual forms are stored in a server called "MAIN_SERVER" which resides in internal LAN domain.That is I have stored location of all my forms path(fmx)in my database table called "FORMS_LOCATION" in the MAIN_SERVER system under the directory "FORMS".From here only users can call all the forms by call_form function.To understand see the example below,

In the table FORMS_LOCATION,there is a column call "forms_path" which holds the value like,

//MAIN_SERVER/FORMS/EMPLOYEE.FMX;
(server_name,foldername,form_name)

In application the call_form just uses the column "forms_path" to call the form.like CALL_FORM("forms_path",no_hide) this statement will call the form from the main_server.

Here 1.MAIN_SERVER is the name of the server system where forms fmx is actually stored under the folder name "FORMS".When the users access the particular form the call_form function call the form from the MAIN_SERVER.Now there are no problem inside the LAN.Incase if I access the database and call the form outside LAN via internet through STATIC IP what happened was database was connected but call_form function failed and not calling the form because which does not know the MAIN_SERVER/FORMS/ path.

Because my user want to access the form outside lan via internet,so I tried replacing the above statement like //192.54.67.98/FORMS/EMPLOYEE.FMX' with static ip in the prefix instead of local server called MAIN_SERVER.But its not working again.How can I do this?.

View 1 Replies View Related

Forms :: How To Built Form (oracle 6i) That Connect With Report Builder

Feb 16, 2013

How i can to built form (oracle 6i) that connect with report builder ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved