Forms :: How To Call VB Or NET DLL From PL/SQL
Feb 2, 2010Is there any way to call a VB or .NET dll from olsql or forms ?
View 14 Replies
ADVERTISEMENT
Forms :: Call Report From 10g
Feb 1, 2012I 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.
Forms :: Call A Block From Another?
Jan 16, 2013I 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]
Forms :: Call Report From 11g
Dec 26, 2010i need call report from forms 11g..Example or Code I have a forms11g and system XP.
View 7 Replies View RelatedForms :: How To Call C++ Code In 6i
Jan 27, 2012how 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
);
Forms :: How To Call Any Application (EXE) From Menu
Oct 1, 2012I 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?
Forms :: Call Another Canvas In Same Window?
Feb 22, 2013I want to call another canvas in same window.using this code /it not work show_view('canvasname');
View 1 Replies View RelatedForms :: Call From Through Menu With Parameter
Feb 3, 2010how 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]....
Forms :: How To Call Canvas From Menu
Mar 25, 2013How 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.
Forms :: Call Reports Using Parameter
Mar 25, 2013i 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 RelatedForms :: Call Report Using RUN_PRODUCT On 6i And 11g
May 4, 2012I 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.
Forms :: How To Call Canvas From Module A To B
Mar 29, 2013How 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?
Forms :: How To Call Bat File From Oracle
Nov 1, 2007how to call batch file from Oracle froms 10g
View 18 Replies View RelatedForms :: Call Report From Form?
Jun 5, 2013i 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.
Forms :: Report Call Paper Or Web Layout
Jan 14, 2010Can 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?
Forms :: How To Call Procedure From One To Another Object Library
Jan 29, 2013I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.
View 1 Replies View RelatedForms :: Call PDF File Without Specifying Reader Path?
Apr 27, 2011I 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
Forms :: How To Call Dll File In Oracle Developer 10g Or 6i
Aug 19, 2010How to call dll file in oracle developer 10g or 6i form
View 1 Replies View RelatedForms :: Call Function With Parameter In Oracle
Jul 17, 2012i 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
Forms :: Call Batch File From Oracle 10g?
Jun 25, 2010I 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
Forms :: Call A Function On Key-next-item Trigger?
May 20, 2011how to call a function on key-next-item trigger. atlst the syntax.
View 2 Replies View RelatedForms :: How To Call A Java Function From Oracle
Sep 5, 2007I 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?
Application Express :: How To Call Apex From Forms Without SSO
Feb 6, 2013We'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?
Forms :: How To Call Database Package From Oracle 6i
Apr 23, 2013I'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 RelatedForms :: Builder 9.0.4.0.33 - Call Report From Form
Nov 11, 2011I 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
Forms :: Call Report From Button In Form?
Feb 27, 2012i 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 RelatedForms :: Oracle 10g Key Combination To Call Form Trigger
Nov 11, 2009I 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.
Forms :: How To Declare Global Variable And Call Same In Other Form
Oct 6, 2008I want to call a value from one from to another form in d2k forms 4.5. I think this can be done only by declaring a global variable. I don't know how to declare global variable and also calling the same in other forms.
View 14 Replies View RelatedForms :: Call Associative Array In Oracle Procedure?
Apr 25, 2013I've one package in which one record is created. associative array is craeted on that record.create procedure on associative array.using forms 6i i want to call this procedue.(package_name.procedure_name(paramerters)). but my problem is what paramerter shuld i provide to excute the procedure?like PK_EXCEL_TO_DB.PR_DO_INSERT(LIST_ROUTE); but i am getting error while doing this.
CREATE OR REPLACE PACKAGE PK_EXCEL_TO_DB IS
TYPE ROUTE IS RECORD (COL_ROUTE VARCHAR2(255), VAL_ROUTE VARCHAR2(4000));
TYPE LIST_ROUTE IS TABLE OF ROUTE;
PROCEDURE PR_DO_INSERT(i_lData IN LIST_ROUTE);
[code]...
Forms :: Call Oracle Form Using Stored Procedure?
Mar 14, 2011How to call Oracle Form using a Stored Procedure?
Under
create or replace procedure ........
Begin
.......
End
Inside such procedures , is it possible to call a form ?