In a form in Order Management, I need to use some information on the page and send it to an applet, currently a JFrame. That applet will then call out to do some credit card work and then return an approval code. At that point I have to update a field on the form with that approval code.
Okay, that is it in a nutshell. Basically, how can I call out to an applet from within an Oracle form? If I can get all the information to the applet I can easily update the database.
i tried to call Report Designer 5.0u Editor (MRD) it is not supported Oracle tools products from form builder Ver6i i try to use RUN_PRODUCT built-in but is not work, how i can call products not supported by oracle like Crystal Reports XI , Report Designer. I located my file in my local PC C: empVD.mrd
How to call program unit(procedure/function/package) in to report is it like formula column & placeholder?if not, how to call external (procedure/function/package) in to report
i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.
I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.
Can we hide the username/password@dbname from hyperlink html, so that when ever we change our user password we should not change in each report calling from another report
Currently i use Oracle Forms & Reports 6i on an Oracle Enterprise Edition 10G. Now there is a requirement to change the technology and WEBify the application.
Say something like .NET, ASP etc... Some links from where i can understand the different option i have.
i am trying to upgrade my existing system (6i) to 11g. I have installed Weblogic 10.3.5 with forms and reports 11.1.2.1.0 on windows 7 32 bit. I can connect to my database (10g) from Form builder.
But when I try to open a form/pll of 10g or 6i, it says PDE-PLI018 could not find library and it shows the path of my earlier folder, which now does not exist.
I have made changes in registry FORMS_PATH, FORMS_BUILDER_PATH, UI_ICON And in default.env file FORMS_PATH and CLASSPATH
I have added entry to tnsnames.ora, through which I can connect to DB. And have followed below site to configure weblogic and FM forms and reports;
[URL]
1) Do we have to connect (create a bridge) to DB from weblogic except tnsnames.ora.
2) For library error I think I am missing some settings to be done.
3) If I am able to rectify above error then can I directly use [URL] and access the system from another pc, or still there are some modifications needed.
We have oracle application built in Oracle D2k forms and reports and run in client server mode. We want to run our application in touch screen kiosk to view reports and forms.is possible or any changes to be done in our existing application to run on kiosk.
I am getting a problem I use lexical Parameter but When I call that through Form my parameter forms didn't call that on report parameter. My query is below as well I have attached all Jpg files to understand. I Didn't getting where I am mistaken.
DECLARE pl_id PARAMLIST; BEGIN pl_id := GET_PARAMETER_LIST('TMP'); IF NOT Id_Null(pl_id) THEN DESTROY_PARAMETER_LIST(pl_id); [code]........
CREATE SEQUENCE hyd1_seq START WITH 2100000 INCREMENT BY 1 NOCACHE NOCYCLE;
this is how i created a sequence in database 10g.
if :SHIP_MSTR.PLACE_FROM = 'hyd1' then SELECT hyd1_seq.NEXTVAL INTO :SHIP_MSTR.BILL_ID FROM dual;
this is how iam calling sequence in form.my problem is once the sequence is generated in form and even if i am not saving a form its generating next value next time.what i want to do is if i am not saving the form that sequence number should again come in bill_id.
I need the IP address and/or Terminal name of the calling PC on CITRIX server. My application(forms) is installed on CITRIX and after calling of any form I want to check IP/Terminal in WHEN-NEW-FORM-INSTANCE trigger.
I have added a text field on forms 6i which calls reportAfter adding the new field called "appeal_name" it gave me the desired result for two three times and somehow after that it started to throw this error
ORA- 00933. I did try to find solution on the web and was given the hint that this occurs due to space or indentation in the coding. I have used Ltrim and Rtrim to remove any space when I added the text field "appeal_name", Following code has been added
if upper(ltrim(rtrim(:appeal_name)))!='ALL' then where_cond:=ltrim(rtrim(where_cond))||' and upper (tbl_donation.appeal_code)='''||:blk_hsbt.appeal_code||''''; elsif :appeal_name is null then where_cond:=ltrim(rtrim(where_cond))||' and tbl_donation.appeal_code is null'; end if;