Forms :: Calling Multiple Reports Through Alert
Feb 15, 2011I need code for calling two reports using alerts.
View 4 Replies
ADVERTISEMENT
Forms :: Calling Reports From Oracle 10g
Mar 18, 2012We are facing a problem when calling the reports from oracle forms 10g. following error message appears during report generation
Rep-52266: The In-Process reports server IT_BHARAT failed to start.oracle.reports.RWException:IDL:Oracle/reports/RWException:1.0
Why this error message is appearing and how to solve. Please find attached the image file showing the problem details.
Forms :: Calling Reports 9i - Argument Can't Be Null
Oct 3, 2005I am calling report9i from forms9i. i am getting following error
invalid report id
when i call a report from form in when button pressed trigger. And also giving the following error
argument(1) can't be null.
v_rep varchar2(100);
v_rep := run_report_object('report5',pl_id);
or
rep_object report_object;
v_rep varchar2(100);
rep_object := find_report('report5');
v_rep := run_report_object(rep_object,pl_id);
where pl_id is the parameter list.
Forms :: Create Main Menu For Calling Reports
Dec 3, 2010Application developed in form builder 6i.Now I want to create main menu for calling forms and reports.
Should I use buttons or drop down menu?
Forms :: How To Design Hierarchical Tree Menu For Calling Reports
Mar 17, 2013How to design Hierarchical Tree Menu for calling forms & Reports.
View 2 Replies View RelatedMultiple Alert Log In 10g RAC
Jan 9, 2013We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit RAC in Linux and syslog server also in Linux.
syslog server is a centralize server to monitor all the system and database log.
is there any way to create a multiple alert log file. so that we can keep one alert log file in default location and another alert log file in centralize syslog server for monitoring purpose.
Reports & Discoverer :: Calling Reports From Stored Procedures?
Feb 23, 2011Is there a way to call an oracle report (version 9i) from a stored procedure?
View 2 Replies View RelatedReports & Discoverer :: Calling Program Units?
May 8, 2013How 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
View 1 Replies View RelatedReports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database
May 28, 2011i 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.
View 1 Replies View RelatedReports & Discoverer :: Calling Report From Form Asking Enter Password
Nov 28, 2010I 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.
View 5 Replies View RelatedReports & Discoverer :: How To Merge Multiple Reports In One Report In 6i
Aug 23, 2011How to merge multiple reports in one report in reports 6i.
View 1 Replies View RelatedReports & Discoverer :: Hiding Username / Password When Calling From Hyperlink HTML?
Jun 30, 2010Can 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
View 1 Replies View RelatedForms :: Pop-up Or Alert On Desktop?
Nov 10, 2012i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.
View 4 Replies View RelatedForms :: Alert While Deleting The Record
Mar 20, 2013I want to create one alert while deleting the record from the custom form. So i have written the below code in the when-remove-record trigger.
DECLARE
alert_button NUMBER;
BEGIN
IF :XXWIPRELFRM.PRINTED = 'Yes' THEN
alert_button := SHOW_ALERT ('DELETE_ALERT');
[Code]..
When i click on the delete(X) symbol in the form, it is showing alert but when i click on "No" also its removing the record..what i need to write.
Forms :: How To Display First Canvas Before Alert
Aug 31, 2010I need to display my alert prompt right after I detect the discrepancy on amount. I place my code on POST-BLOCK. The problem is, after the query, the alert pops out right before the new canvas where the block with POST-BLOCK trigger shows.
I need to display first the canvas before the alert but seems like the process of displaying canvas is the last job oracle does. So even if I place my code on post-record or any other trigger it will be the same.
Forms :: Raise Alert When Browser Closed In 11g
Feb 27, 2012I am working on Forms [32 Bit] Version 11.1.1.4.0 (Production). OS is Win 7 (32 bit). Internet Explorer 8. My Requirement is I need to raise an alert when user close the browser window before closing the Form.
View 2 Replies View RelatedForms :: Alert Cancel Button Gives Non Oracle Exception
Jan 20, 2011i've created an alert with 2 buttons and the code for cancel button is as follows:
...
if alert_id = alert_button2
then
raise form_trigger_failure;
end if;
...
this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?
Forms :: Creating Alert After Records Retrieved From Query
Jun 26, 2013I want to raise a alert after the records retrieved from a query. i.e, if the query fetches 0 records then the alert show be displayed. Is is possible? If yes tell me the trigger to be used to raise such kind of alert.
View 4 Replies View RelatedForms :: How To Create Library Functions To Show Alert
May 24, 2010Am using Oracle 10g Forms and Databse.
My form Consists data block blk_user with two items username and password
Both user name and Password are required Fields.
When user left these items Empty To show Alert
I Created Below Procedure and Called in Form_Level ON-ERROR Trigger.
PROCEDURE pcd_io_alert IS
itm_name VARCHAR2(20);
BEGIN
[Code].....
how to call or create this procedure as Library functions and call the created library in form To Show Alert. Actually I want to create library functions to Validate and Show Alert Mesages.
Forms :: Alert Windows Appear To Be Hidden And Application Locks Up
May 6, 2011I have a forms 11g application that of course has several message and alert windows that pop up when various errors or messages need to be displayed. This all works great on the developer machine, but when I try and run the form on another machine using any browser the message and alert windows appear to be hidden and the application locks up with the rolling bar across the bottom. I would guess it is waiting for a response, but I cannot get the window to appear.
Following is an example of an alert to be displayed:
declare
vAlertButton number;
begin
vAlertButton := show_alert('NO_EMAIL');
end;
Forms :: Customize Position Of ALERT Message On Screen As Per Requirement
Mar 19, 2010I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.
View 4 Replies View RelatedForms :: Display Alert When Click On Insert Record In Tool Bar?
Jun 26, 2013I want to display an alert when we click on Insert Record in tool bar. I put allow update->yes and insert->no.
but when i click on the insert record in tool bar it showing message only.
Instead of message I need an alert using triggers. I added the image also.
Forms :: How To Hide / Suppress User Defined Alert Messages
Dec 19, 2011Is it possible to hide/suppress an user defined alert message in Oracle Forms application?
View 1 Replies View RelatedReports & Discoverer :: Calling Report From Another Report
Aug 31, 2010I created two reports separately.
1.pub.jsp
2.serc.jsp
what i need is i want to call the report serc.jsp from pub.jsp .
Forms :: Calling Applet From Oracle?
Nov 16, 2011In 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.
Forms :: Calling Two Different LOVs At Same Textbox?
Jan 10, 2011Is it possible to populate two different LOVs on same textbox?
Textbox : ITEM_DESC
LOV1:
select desc, code from items order by 1;
LOV2:
select code, desc from items order by 1;
Forms :: Report Calling From Parameter 6i
Feb 7, 2012I 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]........
Forms :: Database 10g - Calling Sequence
Jan 26, 2013CREATE 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.
Forms :: IP Or Terminal Name Of The Calling PC On CITRIX
Apr 21, 2004I 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.
View 3 Replies View RelatedForms :: ORA-00933 When Calling Report From A Form
Nov 8, 2011I 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;