Forms :: Call Report From 11g

Dec 26, 2010

i need call report from forms 11g..Example or Code I have a forms11g and system XP.

View 7 Replies


ADVERTISEMENT

Forms :: Call Report From 10g

Feb 1, 2012

I have a form and i want to call report name is " DOCK_RECEIPT". I already create parameter report on this Form name is " REPORT82" and set property this parameter report contain {Name is REPORT82, filename is DOCK_RECEIPT.rdf, execution Mode is Batch, Communication Mode is Synchronous}. I also create a procedure name is F_PRO_PRINT follow:

PROCEDURE F_PRO_PRINT IS
pl_id ParamList;
rep_id REPORT_OBJECT;
V_rep VARCHAR2(100);
rep_status VARCHAR2(20);
rep_job_id varchar2(100);
v_mine_type varchar2(50);
v_palletid NUMBER(10):=0;
[code]...

Now i have button and in trigger when-button-press add this code call procedure above

F_PRO_PRINT;

When i click button call report and appear error.

FRM-41214: Unable to run report

Now, i want to call report from form 10g.

View 1 Replies View Related

Forms :: Call Report Using RUN_PRODUCT On 6i And 11g

May 4, 2012

I have a form which calls a report. We are maintaining form's source code in FORMS 6i but the form has to be compiled and executed by FORMS 6i and 11g. We have to maintain source code in FORMS6i as we have clients running multiple version of FORMS. The report calling mechanism uses RUN_PRODUCT which is not supported by FORMS11g. suggest a method (other then RUN_REPORT_OBJECT) to support report calling simultaneously on FORMS6i and 11g.

The reason for not using RUN_REPORT_OBJECT is that we don't want to attach report to form.

View 2 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 :: Report Call Paper Or Web Layout

Jan 14, 2010

Can we apply both below methods to call paper layout or web layout

1. WEB.SHOW_DOCUMENT()
2. RUN_REPORT_OBJECT()

Or else web layout reports call only from one of them?

View 1 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

Reports & Discoverer :: How To Call A Report From A Report

Aug 17, 2012

How to Call a Report from a Report?

Not from a form but a Report from a Report?

View 3 Replies View Related

Reports & Discoverer :: How To Call Report Automatically

Sep 3, 2012

Is it possible to automate the execution of some reports build with Oracle report builder? Like I want to run such and such report to run daily at 2:00pm or at the end of every month/year.

View 5 Replies View Related

Application Express :: Dynamic Action Call From An Interactive Report?

Jul 6, 2012

I’m on APEX 4.1, 11gR2, Windows 7 and the latest version of Firefox. I have an interactive report. I want the end user to have the ability to click on a row level link and launch a modal pop up view of another page. Ideally, I'd like to be able to use the Skillbuilders plug-in. I can get it to work if I just go the full page route but I cannot figure out a way to get it to work as a modal pop up. I’ve tried various methods, none of which work, but the one I believe I should be following is by using a page level Dynamic action that fires when a JQuery Selector found item is clicked. The problem I’m having is that I cannot find the correct JQuery Selector syntax for the column. My report has a static ID of IDN and my column a header of PARTS. The best I can manage is not to see anything happen other than a page refresh (when the link is set to the same page). I do not see and firebug console errors.

I’ve replaced the dynamic action modal page call with an alert, which is not showing, to make sure that it's not the plug-in configuration that is causing the problem.

what I should be filling in in the JQuery Selector field of the DA and what the link attributes should be? Given that I wish to redirect from page 1 to page 2, what do I put in the other link fields?

View 2 Replies View Related

Forms :: How To Call VB Or NET DLL From PL/SQL

Feb 2, 2010

Is there any way to call a VB or .NET dll from olsql or forms ?

View 14 Replies View Related

Forms :: Call A Block From Another?

Jan 16, 2013

I have a main interface that contains 3 buttons (emp, dept, mgr) I want when I click on the button 'emp' interface opens in the main interface(the buttons must remain in the main interface)

see the picture : [URL]

View 7 Replies View Related

Forms :: How To Call C++ Code In 6i

Jan 27, 2012

how to call this c++ code by using forms 6i To open and configure the COM port:

HANDLE hCom;
COMMTIMEOUTS lpTo;
COMMCONFIG lpCC;
char str_com[10];
unsigned short no_com = 0;
sprintf( str_com, "\\.\COM%d�", no_com+1);
hCom = CreateFile(str_com,GENERIC_READ|GENERIC_WRITE,0,NULL,

[code]...

To close the port :

CloseHandle(hCom);

To monitor communications events :

SetCommMask(hCom, dwEvtMask );

dwEvtMask is logical or with :

EV_BREAK, EV_CTS, EV_DSR, EV_ERR, EV_RING, EV_RLSD , EV_RXCHAR, EV_RXFLAG, EV_TXEMPTY values

and used WaitCommEvent function

BOOL WaitCommEvent(
HANDLE hFile,
LPDWORD lpEvtMask,
LPOVERLAPPED lpOverlapped
);

View 1 Replies View Related

Forms :: How To Call Any Application (EXE) From Menu

Oct 1, 2012

I called an application from Oracle forms using: Client_Host('cmd /c START "" "\localPathmyApplication.exe"'); This works fine on local as well as server.

But when I use the same command to call the application directly from the MENU ITEM, it gives error alert: "WebUtil Error: oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work."

I even tried using DDE.App_Begin(). This gives error: ORA-106561. How can I call any application (.exe) directly from the menu item on the server?

View 3 Replies View Related

Forms :: Call Another Canvas In Same Window?

Feb 22, 2013

I want to call another canvas in same window.using this code /it not work show_view('canvasname');

View 1 Replies View Related

Forms :: Call From Through Menu With Parameter

Feb 3, 2010

how can i call form through menu bar with parameter...

i made a log-in form in which i take user name and i send it to called form in and which forms is called there i create a parameter of that name which i called log-in form...

but when now i reached it on second form there is i use menu.. than how can i send this user name to other forms which i called through menu bar....

I Use this code for calling form through log-in form...

but what can i do for call form with parameter through menu..

DECLARE
ALRT NUMBER;
T_REC NUMBER;

[Code]....

View 5 Replies View Related

Forms :: How To Call Canvas From Menu

Mar 25, 2013

How to call the canvas from the menu module on which the form linked to the menu items.

The canvas lies in the same form where menu is attached.

View 4 Replies View Related

Forms :: Call Reports Using Parameter

Mar 25, 2013

i have one report.the report name is emp and i have 3 user parameters in that report. i want to call report from form. in form i have 3 text fields date ,name ,empno and one button runport..code to call the report from form using this parameter.

View 3 Replies View Related

Forms :: How To Call Canvas From Module A To B

Mar 29, 2013

How to call the canvas from FORM A to FORM B . Form A contains canvas 'can_test'

Form B contains canvas 'can_sub'

I want to call 'can_test' from 'can_sub'

How to achieve this one?

View 1 Replies View Related

Forms :: How To Call Bat File From Oracle

Nov 1, 2007

how to call batch file from Oracle froms 10g

View 18 Replies View Related

Forms :: How To Call Procedure From One To Another Object Library

Jan 29, 2013

I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.

View 1 Replies View Related

Forms :: Call PDF File Without Specifying Reader Path?

Apr 27, 2011

I need to call pdf file in oracle form 6i without specify the path of adobe acrobat reader. how to do that?

i.e.:
AppID := DDE.App_Begin(<path where you have winword.exe in your system> <path of the document you wish to open>,DDE.APP_MODE_NORMAL);

i dont need to write ths part
<path where you have winword.exe in your system>

that because in our company we have several virgins of acrobat reader and i really need to call pdf file and make the call statement public

View 4 Replies View Related

Forms :: How To Call Dll File In Oracle Developer 10g Or 6i

Aug 19, 2010

How to call dll file in oracle developer 10g or 6i form

View 1 Replies View Related

Forms :: Call Function With Parameter In Oracle

Jul 17, 2012

i have this function

create function xxx_sal (p_number in number)
return number is
v_sal number;
begin
select sum(sal)
into v_sal
from emp
where empno = p_number;
return v_sal;
end;

how can called it in oracle forms

View 8 Replies View Related

Forms :: Call Batch File From Oracle 10g?

Jun 25, 2010

I want to call .bat file from oracle froms 10g.

I tried given below code but failed.

---------------------------------
declare
v1 varchar2(200);
begin
v1 := 'D:FolderLogicalbackup.bat';
HOST('cmd /c start'||v1,no_screen);
--HOST(v1);
end;
-----------------------------

The Logicalbackup.bat file contains:-

Cd d:oracleproduct10.2.0db_1in
d:
exp mw6/mw6@mw file=d:mw6ackupackupRGLHR.dmp log=d:mw6ackupackuplogRGLHR.log

View 4 Replies View Related

Forms :: Call A Function On Key-next-item Trigger?

May 20, 2011

how to call a function on key-next-item trigger. atlst the syntax.

View 2 Replies View Related

Forms :: How To Call A Java Function From Oracle

Sep 5, 2007

I am having Oracle 9.2.0.1.0 client in my PC and jdk version is 1.6

I had configured below tools in my PC. (windows 2000) I am having Oracle 9.2 with Oracle Developer Suite 10g (10.1.2.0.2) which contains Oracle JDeveloper 10g (10.1.2.1) also.

How to call a java function from Oracle forms? code samples and how to integrate those thing?

View 13 Replies View Related

Application Express :: How To Call Apex From Forms Without SSO

Feb 6, 2013

We'll soon start an upgrade of our Forms / Reports 6i Application to 11g. I was wondering, maybe, it would be nice to add some value for the upgrade process as a whole, using some of Apex new features like web mobile interface or maybe an integration between Forms an Apex, for example to provide users with the powerful features of Interactive Reports, just to name one.

I have found this interesting link: URL.... (not a 100% clear for me, but at least it is a start).Obviously, to make it attractive, one would expect automatic login between the two Apps. As far as i know, this could be done like this:

1) Using SSO. With that a Portal / Forms / Reports/ Discoverer/ version would be mandatory (too expensive for some clients).

2) Oracle Access Manager? Not sure, can Oracle Forms connect to Access Manager? or LDAP? How about the licensing costs?. Not a clue.

3) Make all Apex pages public? Not feasible.

4) Now this one: in our forms application, every user authenticates within the application and we internally map that application user to an actual database user. At all times we hold metadata info about the current user (app, and DB), as well as application context. So this is my question:

It is possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting?

View 0 Replies View Related

Forms :: How To Call Database Package From Oracle 6i

Apr 23, 2013

I've created a database package which is having record type and one procedure. I want to execute or call this package from oracle 6i form. How to do this.

View 7 Replies View Related

Forms :: Oracle 10g Key Combination To Call Form Trigger

Nov 11, 2009

I need to fire the KEY-DUPREC trigger as I click on the key combination Shift+P therefore; I added the following line of code in the frmweb.res file.

80 : 1 : "Shift+P" : 64 : "Duplicate Record"

It worked iff no error was raised. So, if I have a raise form trigger failure in the KEY-DUPREC trigger, a capital P will appear in the text field that called the trigger.

View 2 Replies View Related







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