Forms :: ORA-00933 When Calling Report From A Form
Nov 8, 2011
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;
View 1 Replies
ADVERTISEMENT
May 28, 2011
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.
View 1 Replies
View Related
Nov 28, 2010
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.
View 5 Replies
View Related
Jul 15, 2007
I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
View 13 Replies
View Related
Oct 4, 2011
is there any way to call internet explorer with in form.i want to provide net fascility to the users using 10g forms.
I have tried some beans but some restrictions are there.it is not properly displaying page.
View 3 Replies
View Related
Apr 29, 2013
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....
View 2 Replies
View Related
Jul 26, 2010
I want to send data back to calling form
1. is it possible? if so how?
2. How much length/byte data we can send?
View 3 Replies
View Related
Jul 29, 2011
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.
View 13 Replies
View Related
Apr 29, 2013
i have one multiple record field in frm....contain 5 field.....now i display the values...3 fields have values and two are empty...
the value of 1st field is A
2nd field is B
3rd field is C
i want if i click B it will open another form,
i want if i click c it will open another form,
View 9 Replies
View Related
Sep 4, 2012
Iam facing a problem while calling a form.
iam opening a form,inserting data in empty columns of an existing record and with out saving iam calling another form.Inserting and updating data in the called form and again coming back to old form and then saving the form.
while doing this, when i am trying to save on the called form its giving an error
FRM-40403 CALLING FORM HAS UNAPPLIED CHANGES,SAVE NOT ALLOWED.
View 5 Replies
View Related
Mar 17, 2011
I've a procedure let us say SALES_PROC on Form Level and same procedure in Library and in Database also.
-How to call SALES_PROC created at Form Level?
-How to call SALES_PROC created at Library Level (.PLL)?
-How to call SALES_PROC created as stored procedure in Database?
View 5 Replies
View Related
Mar 25, 2010
We are in the need of calling Mapping Software from with in Forms, most likely Google Maps, and keep the form locked until selections are made. The attempt was to call the URL from a Modal Window that would in turn lock the form until return.
The attempts were using WEB.SHOW_DOCUMENT, this process releases the form as soon as the call occurs. Then the desire to use UTL_HTTP, but with this process it would cause the DBA to setup a Wallet_Path for Certification of the call. This one has not been explored as yet.
View 2 Replies
View Related
Feb 7, 2012
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]........
View 3 Replies
View Related
Jun 10, 2013
I got the following scenario.
- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-
Begin
go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......
When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.
View 1 Replies
View Related
Feb 22, 2010
Created a report object "REPORT62" in Forms Objectnavigator
Trigger on When Button Pressed
DECLARE
rep_id REPORT_OBJECT;
rep_result VARCHAR2(200);
BEGIN
rep_id := find_report_object('REPORT62');
rep_result := RUN_REPORT_OBJECT(rep_id);
END;
Report is called in the property
Filename C:DevSuiteHome_1forms est.rdf
When button is pressed error is raised
There was a failure in the Form server during startup. This could happen due to invalid configuration.
View 5 Replies
View Related
Jun 7, 2010
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
View 2 Replies
View Related
Dec 2, 2010
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
View 10 Replies
View Related
Aug 31, 2010
I 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 .
View 6 Replies
View Related
Sep 16, 2010
how to use of Database link (DBLINK) in D2K form and report PL/SQL.When I Use the DB Link in Pl/SQL of any form6i or report 6i, On compilation forms and reports are automatically closed.
View 3 Replies
View Related
Jun 5, 2013
i have one report with one parameter name is :description the data of the description is
ALL 1" MD
UBS 2" MD
MNC 23 MSD
LKT 11" WIP
LLP 2 MC
and my question is when i call a report from form it shows the syntax error or command line.if i give the value MNC 23 MSD (or) LLP 2 MC in forms it run good.But if i give UBS 2" MD (or) ALL 1"MD (or) LKT 11" WIP in forms it through REP-159 Syntax error or command line.
View 14 Replies
View Related
Feb 23, 2011
I have created a simple form & report based on 2 tables Cust & cntry.I just want to display all customers of region selected in the criteria form. I am uploading the files.
Other than selection criteria report is fine.
View 4 Replies
View Related
Sep 21, 2010
I want to generate a PDF report from Form Developer 6i.
View 5 Replies
View Related
Jan 23, 2013
How can i pass the parameter from reports to form. means how can i open particular form from my report. means if i write query
select * from emp
this emp table report open now i just want open only emp no 10 form from this report so which parameter i have to pass.
View 2 Replies
View Related
Oct 26, 2010
My requirement is:
I want to run multiple Reports Concurrently, being called from my Form.
Suppose I have 10 Reports Say Report1, Report2, ....Report10.
I am using "RUN_PRODUCT" to call these Reports from my Form. But it's taking too long time to run all the Reports one after another. Can I run all these Reports Concurrently at the Same time.
View 4 Replies
View Related
Nov 11, 2011
I used Report Builder 9.0.4.0.33, and i want to call 1 report name is "DOCK_RECEIPT.rdf" from Form when click into button name is "Print". I write code in When-button-press follow: This is code call report from Form.
Declare
pl_id paramlist;
Begin
pl_id := get_parameter_list('tmpdata');
[code]....
On report "DOCK_RECEIPT" has parameter same parameter on Form. But when i click button "Print" then can't call report,while form and report that together folder.Now, i want to question, how must configure report builder for call report from form that? example: about directories,path, etc
View 4 Replies
View Related
Feb 27, 2012
i need to call report from button in form but when i call the report which have parameter in it ,it run direct without show me the parameter field to be entered now i need to do the following run report normally as when i press in the button the parameter filed appear.
View 1 Replies
View Related
Dec 21, 2011
have a customer table with following columns.
1 - Cust_ID
2 - Cust_nam
3 - Cntry_id
I have another table country.
1 - Cntry_id
2 - Cntry_nam
3 - Region
Now I want to view report for all customers of a certain region selected by user in criteria form.How can I do this?
View 1 Replies
View Related
Apr 7, 2011
I am using Forms / Reports Developer Version 6. When I run the report through form the Report runs but updated file was not executed. The path from which I run report through form contains updated report name. When I run report by using Report runtime shortcut then updated report will run. The report path mention in form using run_product also contains the updated file but didn't execute the updated file.
View 1 Replies
View Related
Feb 16, 2013
How i can to built form (oracle 6i) that connect with report builder ?
View 2 Replies
View Related
Dec 14, 2012
how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.
View 6 Replies
View Related