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 want to maximize applet when it is loaded.How is it possible? I have set Width and hight with 100% and separateframe = True in Formsweb.Cfg.
When applet is loaded its size is according to screen but my status bar is not viewing. It appears behind the window task bar. I have to click on Maximize option of applet by mouse to maximize applet.
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
We are using oracle forms 10g, in formsweb.cfg file i gave separeteFrame=true and it works fine also like IE & applet window is opening. But User wants to hide the IE in backegroud and they want only applet window, so using VBScript we are hiding the IE and now only applet window apears this also fine.
I am running the report and displaying the report using web.show_document, report is running fine and displaying in IE with PDF format. But the problem is if i press the run report button report is opening and displaying behind the applet window not infront of applet window and there is no focus on the report IE also. How to display the report output(IE with PDF format) infront of the applet window and current focus on the report window(IE with PDF).
Note: If i use separateFrame=false then report is displaying infront of the IE screen and focus is on the report IE.
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
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;
my purpose is when PRE-INSERT trigger fires validation should be done like date format , primary key in table if validation is ok then a value of text box should be set to sequence no . else it should generate message
I have a form with two text items and one text label fields. The value of the label field is "click here for more help". now i want to show the URL.... if i click the text lable. I also Tried when mouse click trigger...but it shows the website when i click the text items .... it is not working in the label. URL....
I have two forms, A and B and form A is calling form B. And when I am committing form B I am getting this error message. I don't want to commit form A before committing form B. Is their any solution to commit both forms in different session.
I am having an Oracle procedure which return ref cursor. I also want to result one more out parameter result. How Can I call the procedure in SQL. Below is the way I am calling my stored procedure with one parameter.
proc_Test (p_resultset=> My_cursor)
How can I call the procedure when I have one more OUT parameter. Second parameter returns 0 or 1.
declare v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?'; v_connectVARCHAR2 (200) := 'userid=scot/tiger@connect_string'; v_report_serverVARCHAR2 (30) := 'rep_cs-oracle'; -- i make this server name by using this command:C:DevSuiteHome_1BIN wserver server=rep60 start >>when i started it getting to shutdowing directly!!!!! i don't know why [code].....
the error is:
before the browser is opened!! an error is occur is that: javaw.exe -Entry point Not found the procedure entry point kguuseg could not be located in the dynamic link library oraclient10.dll
then the browser is opened ,this error written in it:
REP-52266: The in-process Reports Server rep_cs-oracle failed to start.org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: SUN minor 204 completed: No
In my PLSQL package ...How do I invoke this class file ?
So far I have done this ...
Declare abc ORA_JAVA.JOBJECT; xyz ORA_JAVA.JOBJECT; xxx VARCHAR2(25); value ORA_JAVA.JOBJECT; BEGIN
[code]...
I am getting an error saying the object type is wrong .... I would like to know how to assign a hardcoded value to the JOBJECT just to test before I continue.
