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

Reports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database

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

Reports & Discoverer :: Calling Report From Form Asking Enter Password

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

Forms :: How To Reload Calling Form After Closing Called Form

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

Forms :: Calling Internet Explorer Within Form

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

Forms :: Calling A Website In A Form Using Hyperlink

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

Forms :: Can Pass Data Again To Calling Form

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

Forms :: Frm 40403 - Calling Form Has Not Implemented Changes

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

Forms :: Calling Form From Multi-record Field?

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

Forms :: Calling Form Has Unapplied Changes - Save Not Allowed

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

Forms :: Calling Procedure At (Form / Library And Database) Level

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

Forms :: Calling URL From Modal Window Lock Form Until Return?

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

Forms :: Report Calling From Parameter 6i

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

Forms :: Calling From Other Data Block Into Current Master / Detail Form

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

Forms :: Calling Report In Object Navigator

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

Forms :: Calling Report - Entry Point Not Found

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

Forms :: Calling Report Designer 5.0u (MRD) From Oracle Builder 6i

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

Reports & Discoverer :: Calling Report From Another Report

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

Forms :: Use Of DB Link In D2K Form And Report 6i?

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

Forms :: Call Report From Form?

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

Forms :: How To Pass Parameter From Form To Report

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

Forms :: How To Generate PDF Report From Form Developer 6i

Sep 21, 2010

I want to generate a PDF report from Form Developer 6i.

View 5 Replies View Related

Forms :: How To Pass Parameter From Report To Form

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

Forms :: Running Concurrent Report From FORM

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

Forms :: Builder 9.0.4.0.33 - Call Report From Form

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

Forms :: Call Report From Button In Form?

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

Forms :: How To Pass Parameter From Criteria Form To Report

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

Forms :: Report Through Form - Updated File Not Executed

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

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

Application Express :: How To Make Form With Report And Insert Form In Same Page

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







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