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
ADVERTISEMENT
Dec 26, 2010
i need call report from forms 11g..Example or Code I have a forms11g and system XP.
View 7 Replies
View Related
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
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
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
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
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
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
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
Feb 2, 2010
Is there any way to call a VB or .NET dll from olsql or forms ?
View 14 Replies
View Related
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
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
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
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
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
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
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
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
Nov 1, 2007
how to call batch file from Oracle froms 10g
View 18 Replies
View Related
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
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
Aug 19, 2010
How to call dll file in oracle developer 10g or 6i form
View 1 Replies
View Related
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
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
May 20, 2011
how to call a function on key-next-item trigger. atlst the syntax.
View 2 Replies
View Related
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
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
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
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
