Forms :: How To Pass Menu Parameters In 10g
Aug 5, 2013I'm migrating forms 6i to forms 10g. I have a mune which has parameters ,which are working in forms 6i. But when i try to comile in forms 10g its poping up error's.
View 3 Replies
ADVERTISEMENT
Forms :: Passing Parameters From Menu File
Apr 17, 2012Is it possible to pass parameters from menu file to form when calling a form from menu item?
View 4 Replies View RelatedSQL & PL/SQL :: How To Pass Timestamp Parameters
Sep 13, 2013In my task I am trying to pass a timestamp datatype as one of the input parameter to a procedure in the package.But I am not sure how to give data for it while executing and testing it from anonymous block.
CREATE OR REPLACE
PACKAGE body ac
IS
PROCEDURE ac_ex_wbdb_keycats(
In_Sale_Location_Id IN NUMBER,
In_Start_Datatime IN TIMESTAMP,
In_Stop_Datatime IN TIMESTAMP,
v_refcur OUT sys_refcursor)
[code]....
Pass The Parameters And Run The Nohup Command?
Mar 30, 2012I had a requirement to execute a long running sql query. But the sql query had some parameters to be passed in and at some places i need to press "Enter" . I want to use nohup command and run the sql script using shell script concept. How can i pass the parameters and run the nohup command.
[URL]
I want to keep the sql script in a shell script and run it through nohup command.
how can i keep the above sql in a shell script and run through nohup command
PL/SQL :: How To Pass Changeable Actual Parameters Into Procedure
Mar 29, 2013I am writing a procedure for the front-end. The end-users need to insert multiple rows of data into history tables in the database (11G). My problem is: the multiple actually parameters is not a fix amount, this time, the amount could be 5, next time, it could be 12. I currently used one string and pass the actual parameter (P_id, number) as '2, 4, 5, 7, 8', the procedure was executed successfully, but cannot insert any data into history table.
See my procedure below (the base table has clob data, I have to consider insert ... select *), I tried to use to_number (CONTACT_MSG_ID), it doesn't work well:
PROCEDURE ARCHIVE_XREF_CONT_EMAIL(P_ID IN VARCHAR2) IS
BEGIN
INSERT INTO TRC_XREF_CONT_EMAIL_MSGS_HIST
SELECT *
FROM TRC_XREF_CONT_EMAIL_MSGS
[code].......
Reports & Discoverer :: Pass Parameters In Table Section?
May 31, 2012I have a problem here.Normally, we use &p_where inside a sql script in condition sectione.g :
select name from member where name like 'a%' &p_where order by name;
may i use this kind of parameter in table section?e.g :
select name from &p_table where name like 'a%' and status = 'a' order by name;
the reason i need to do is there are 2 different server. but i need retrieve same info.server ABC have table A but don't have table B and server DEF have table B but don't have table A.
Is there any other method to solve this problem?
Client Tools :: Pass Parameters To Oracle SQL Query?
Oct 9, 2012I am trying to pass the parameters to query and I need to pass few parameters to query. Can I make it like like then I run it, then it come up and ask the parameter like this:
SQL> @text
para1 XXXXX
para2 XXXXX
And then the result of query will come up. I would like to put label for each parameter( likepara1).
Windows :: How To Pass Null Values In OracleCommand As Parameters
Jul 19, 2012How to pass null values in OracleCommand as a parameters
i am doing like this
((OracleCommand)cmdMySql).Parameters.Add(":1" ,Varchar2).Value = DBNull.Value;
Its giving error when dataadapter is going to fill.
Forms :: How To Display Menu Instead Of Default Menu
Apr 19, 2013i have one form name is LOV.fmb and i have one menu name is summit_menu.mmb how to display menu instead of default menu.
View 2 Replies View RelatedSQL & PL/SQL :: Collections Fetch - Pass List As Input Parameters To Procedure
May 11, 2012I have a record type and table of records as follows
type rec is record
(
empid employee.empid%type,
ename employee.ename%type
);
type tab_rec is table of rec;
Suppose data from employee table is fetched into this collection
Can you pls clarify if we can refer to all the rows of empid in the above collection ?
something like tab_rec.empid without using the subscript for referring to the nth row
My requirement isto pass this list as input parameters to a procedure(PL/SQL).
Forms :: Add Scroll Bar On Menu?
Jul 26, 2013I am working on oracle 10g forms.my menu is so long and I want to add a vertical scroll bar to my menu .
View 6 Replies View RelatedForms :: How To Get Menu Item Name
May 5, 2009I have created a Menu in forms 6i,
I want to get Menu Item Name When i pressed any menu item in runtime..
e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3
when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',
how can i get this..?
REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.
Forms :: Report Run From Menu
Dec 7, 2010I am using Developer 10g R2. From menu module i want to check the status of the report server. also when the status is shutdown then reportserver will be start otherwise run the report.
Programatically how can i do this.
Forms :: Menu Not Replacing In 11g?
Jul 25, 2012In forms 11 g, whenever, We did any menu change, and deploy in server, same changes are not reflecting in clients machine immediatly. I even stop forms services and restart.After some time... generally after 1 day, it reflect the new changes.In forms 10G, I never face this issue. As soon as i close the old menu and re-open, new changes reflect.
View 2 Replies View RelatedForms :: Run Reports From Menu?
Feb 14, 2010Recently i migrated all my forms and reports from 6i to 10.I am able to run the reports in the web.But when I am trying to run thru menu it give me error
Invalid report id -frm 41219
(I had already searched the forum for the same but i didnt get any valid answer. )
In the forum some says to add the report in the object navigator The reports node is available for the forms only but not for the menus then how can i add the report? Below is the code i am using in the menu
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
[code]...
Forms :: Creating Menu In 10g
Mar 30, 2011I built a form in 10g and I want to replace the oracle menu with my menu, so I wrote the code
replace_menu('TA_MENU.MMX',null, null);
in the new form instance trigger but when I run the form it gave me this error
"frm-10221 can not read the fiel TA_MENU".
what have I do to fix this error?
Forms :: Navigation Between Forms Via Custom-menu?
May 23, 2011what is the basic workaround to provide to switch from one form to another form via custom-menu at runtime?
I attached a menu-item to every of my forms and I can call them seperately from the forms builder. But I am not able to switch between the forms then. If I am clicking on a menu-item, I get frm-40010.
P.S. I'd prefer to close the current form, if the new form has been opened. Do I have to control this seperately or is the closing of the last form default?
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 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 :: ORA-31640 While Compiling Menu In 6i
Oct 22, 2011I am getting this err ora-31640 while compling a menu in forms6i and when i have searched in oracle it is giving in forms 6i shared submenu's are not supported.
View 1 Replies View RelatedForms :: FRM-10221 / Can't Read Menu
Oct 10, 2010I create a Menu with two Items in it (execute and Exit) .Then i save and compile it with My_Menu name .Then I edit Menu Module Property in Property palette of Module2(file name) .
Menu Module MY_MENU
But at run time its giving me following error message .
frm-10221 can't read menu
Forms :: Put On Form1 Different Menu Then One On Form2
Jan 26, 2013I have 2 forms, form1 and form2.
Form1 calls form2 but i need to put on form1 a different menu than the one on form 2.
Forms :: How To Hide MENU And TOOL Bar
Jun 22, 2012i want hide the content shown in the picture
View 6 Replies View RelatedForms :: Disabling Item From The Menu?
Feb 15, 2012I want to disable the menu item from the menu.
01. Write set_menu_item_property('menu.menu_item', ENABLED, PROPERTY_FALSE); in Startup code of the menu itself
02. Mannually disable the item from property palette but both of these are not working. I have also disabled the Menu Security and removes the roles from the menu itself.
what exactly is the thing which is controlling the menu? Or is there any other way to disable/disappear the menu item?
Forms :: Hierarchical Tree Menu
Nov 30, 2010I need complete source from hartical tree menu using by calling reports and calling forms.
i need related Table ,triggers and Examples.
Forms :: How To Create Icon Menu
May 29, 2010I want to create icon menu.
It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.
Forms :: Creating Menu In A Form
Jul 13, 2010I want to create a Menu in my form .
First i create a form in Form Style using emp data block . Then , I create a Menu with two items . Then i compile and save both of them . But when i run my form , Menu does not appear .
Forms :: Create Menu Role With User
Jul 19, 2010how to create menu with submenu according to user,
For Example :
Menu1 have got 02 SubMenu :
SubMenu1 just user1 see.
SubMenu2 just for user2.
And user3 could access SubMenu1 and SubMenu2.
Forms :: Create Menu Item In Run Time
Apr 22, 2010can i create menu item in the run time ?
View 3 Replies View Related