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
ADVERTISEMENT
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 View RelatedForms :: Passing Parameters From One Form To Another?
Jun 1, 2009i want to pass parameters from xyz form to abc form when i press a button. how to pass parameters.....
View 5 Replies View RelatedForms :: Passing Two Parameters Between Form A And B
Sep 17, 2010I need to pass two parameters (STUD_ID) and (TERM) from Form A to Form B. I've read a lot but I'm not familiar with terms and oracle jargon yet! So I really need your straight forward clarification
From the Calling form I'm using when_button_pressed trigger...what shall i write in here?! In the Called form, I'm declaring the following under (When_new_form-instance):
declare
p1_id paramlist;
stud_id number(8);
term number(5);
begin
p1_id := get_parameter_list(stud_id);
p1_id := get_parameter_list(term);
:TEST_STUD_CRSE_REG.stud_id :=:parameter.stud_id;
:TEST_STUD_CRSE_REG.term :=:parameter.term;
next_block;
end;
-----------------
on the calling form:when_button_pressed I am using:
DECLARE
p1_id paramlist;
stud_id number(8);
term number(5);
BEGIN
call_FORM('test16SEP',NO_HIDE);
GO_BLOCK('TEST_STUD_CRSE_REG');
set_block_property('TEST_STUD_CRSE_REG',default_where,'STUD_ID=:TEST_STUDENT_INFO.STUD_ID');
execute_query;
END;
Forms :: Create Table From Query With Passing Parameters
Oct 20, 2011I want to create table from query with passing parameters
create table as temp
select * from emp
where hiredate between :sdate and :edate
and deptno = :dpt
when I tried in Toad after passing parameters it gives me error
ORA-01036: illegal variable name/number
Forms :: Passing Parameters To Next Page But Values Not Saved
Jul 6, 2010Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
I have a form which has few textboxes, and few dropdown, and 3 links. Data is entered in few boxes, and then when a link is clicked, it goes to another page, but i want to pass the text in the text boxes, and the selected value from the dropdown also, to be passed as parameters to this link... But since these values are not yet saved, its not getting passed.. like it is something like this in the address bar add_new_event?&event_ id= &event_ name= & event_dt=
SQL & PL/SQL :: Ref Cursors For Passing Parameters?
Mar 20, 2013declare
type ref_cur is ref cursor;
r ref_cur;
enam emp%rowtype;
dno dept.deptno%type;
begin
dbms_output.put_line('The Employee details are');
open r for select deptno from dept;
loop
fetch r into dno;
[code]....
Error at line 1
ORA-06550: line 12, column 28:
PLS-00103: Encountered the symbol "FOR" when expecting one of the following:
. ( % ;
if i need to use ref cursor to send parameters, is it possible? if yes how to use it?
Update A Table Passing The Parameters?
Sep 17, 2008i want to update a table passing the parameters and the updating the table according to it
i trired this
create or replace procedure move
(z1 in game.item_id%type,g1 in game.item%type)
as
begin
update game
set
postion= 'l'
where item_id=z1 or item_id=g1;
end move;
/
SQL & PL/SQL :: Passing Multiple Parameters To Cursors?
Jun 18, 2013How can we pass multiple parameters to cursors?
Ex: Cursor C_employees(C_empid number, C_cityname varchar2) is select emp_name, office_name from employee where employees where empid = c_empid and city = c_city_name;
I know we can pass one parameter to the cursor but I do not know how to pass multiple parameters.
PL/SQL :: Where Condition - Passing Parameters Using IN Clause?
Jul 23, 2013,I have a queryIn my query iam passing parameters using IN clause.The parameters contains in two tablesfor ex..select a.deptno, b.deptnofrom dept1 a, dept2 bwhere a.deptno = b.deptnoand NVL (a.deptno, b.deptno) in (10, 20, 30,.....) is this correct way to use NVL like this.i have a deptno consists in both the tables. How can i use this condition.
View 4 Replies View RelatedReports & Discoverer :: Passing Parameters With Cgicmd.dat?
Feb 14, 2013i try this url: [URL]
with this key in my cgicmd.dat :
url_config: server=ed_url2 report=%1 userid=user/passxd@base destype=file desformat=pdf
and i have this error:
Unable to open file 'my_parameter='.
The rwservlet converts the value of my parameter to 'my_parameter='. It adds a '=' systematically at the end of my parameter.
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 RelatedPrecompilers, OCI & OCCI :: Passing Parameters In A Dynamic Query
Jul 31, 2009I have a Pro*C program, which uses a dynamic query. The dynamic query is opened using result of another static cursor( 5 fields say , :a, :b , :c, :c, :d).
I am modifying the dynamic query and adding UNION for some requirement , which makes this dynamic query exactly double in size. ( means 2 set of prev. queries are joined by UNION, with one extra condition though).
The question is , Do I need to pass 2 set of variable to open the dynamic query now?
Like earlier , program was passed with (:a, :b , :c, :c, :d)
so now i should pass (:a, :b , :c, :c, :d , :a, :b , :c, :c, :d)?
Application Express :: Passing URL Parameters To Form / Page?
Oct 14, 20121. I m building a form in which students will file some data (name, address, etc) but i want to send a parameter on the URL i send them (their student ID number), which will be saved together with the data the end-users save.
e.g the form i m building is [URL]
can i add in the end of the URL the student_id of the end of the URL?
so it will be something like [URL]
So when student #10 will hit the URL on his browser, once he inputs hsi data and press SAVE button, on the database i can save STUDENT_ID=10 and the rest info he just entered?
2. Which is the login URL for end users? i have only the workspace login now..
Client Tools :: SQLPLUS - How To Execute Store Proc When Passing Only 2 Out Of 3 Parameters
Feb 22, 2011I am trying to execute a STORE PROCEDURE from SQL*PLUS with no success:
SQL> execute PACKAGE.PROC(201011,'144792');
BEGIN PACKAGE.PROC(201011,'144792'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'PROC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
In fact, when i do: desc PACKAGENAME . I see that the procedure is waiting for 3 parameters and one of them is a REF CURSOR type:
SQL> desc PACKAGENAME
PROCEDURE PROCEDURENAME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PWEEK NUMBER IN
PCLIENT VARCHAR2 IN
CRESULTS REF CURSOR IN/OUT
After searching a bit, i try the following:
SQL> execute PACKAGE.NAME(201011,'144792','CRESULTS
'=>:C1);
SP2-0552: Bind variable "C1" not declared.
SQL>
This is a preview of the PACKAGE header:
CREATE OR REPLACE PACKAGE PACKAGENAME
AUTHID CURRENT_USER
AS
--
TYPE CurTyp_Supp IS REF CURSOR;
--
TYPE TabTyp_Supp IS TABLE OF VARCHAR2 (10 BYTE);
--
TYPE ObjTyp_Prmt IS OBJECT (p_schemaname VARCHAR, p_filename VARCHAR);
--
PROCEDURE PROC(pWEEK NUMBER,
pCLIENT VARCHAR,
cResults IN OUT CurTyp_Supp);
This what the PACKAGE BODY looks like:
CREATE OR REPLACE PACKAGE BODY PACKAGENAME
IS
PROCEDURE PROC (pWEEK NUMBER,
pCLIENT VARCHAR,
cResults IN OUT CurTyp_Supp)
QUESTION:
HOW DO I MANAGE TO EXECUTE THIS PROCEDURE FROM SQL*PLUS
SQL & PL/SQL :: Passing Location To External File
Sep 16, 2013I have a simple external table
CREATE TABLE xyz
(
UNIQUE_ID VARCHAR2(255 BYTE),
FULL_BUSINESS_NAME VARCHAR2(255 BYTE),
ADDRESS_1 VARCHAR2(255 BYTE),
ADDRESS_2 VARCHAR2(255 BYTE),
CITY VARCHAR2(255 BYTE),
[code].......
I need to make the location parametrized so we don't have to hard code the file name file1. Can I do this in Oracle or do I need to do this in a shell script on the UNIX server?
Windows :: Passing Values / Arguments To Batch File
Aug 26, 2012I have a batch file Menu.bat which should pass accept the input parameters from the end users and pass the entered values to a different batch file.
After entering option 2 the user should be prompted with an option to enter the path. E.g. /shared/folder.
Now '/shared/folder' should be passed to a different batch file named R.bat
Below is the Menu.bat file.
@echo off
color 00
title Security Audit Adaptor
:main
cls
echo //MAIN MENU\
echo.
echo 1. Got to Google
echo 2. Enter path
[code].......
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?
PL/SQL :: NLS Parameters - Exporting Couple Of Views Into Flat File
Jan 11, 2013In one of my projects I am exporting a couple of views into a flat file. The export utility is generic and uses dynamic sql to generate a flat file. We have a test environment and a production environment. On both the code is the same. We noticed that the output is different between the environments although it is supposed to be the same. If I export a view in the production I will get a record like this:
0020110107O0000000001|OTHER|07.01.11 08:06:00,296000|07.01.11 08:04:41,008000||0|0|EUR||NOT_FROZEN|MVOIP||IS_NORMAL_VERSION|MODIFIED|6863475590797607166|8648564326455689103|8011808169304472215|||CCP||||10000580||||DEKA|PS
In the test environment it will be like this:
0020110107O0000000001|OTHER|07-JAN-11 08.06.00.296000 AM|07-JAN-11 08.04.41.008000 AM||0|0|EUR||NOT_FROZEN|MVOIP||IS_NORMAL_VERSION|MODIFIED|6863475590797607166|8648564326455689103|8011808169304472215|||CCP||||10000580||||DEKA|PS
The code I am running is not changing any settings explicitly. It looks like this and it will be run as EXECUTE IMMEDIATE:
DECLARE
v_sql VARCHAR2 (32000);
v_sql_count NUMBER := 0;
v_error VARCHAR2 (4000);
v_new_file UTL_FILE.file_type;
BEGIN
[code]........
I also tried to do the following on production in order to get it equal to the test environment:
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = AMERICAN '
|| 'NLS_NUMERIC_CHARACTERS = ''.,'''
|| 'NLS_TIMESTAMP_FORMAT = ''DD-MON-RR HH.MI.SSXFF AM''';
END;
This would change the formatting for the timestamp columns for almost all files. Almost. Two of those files remain unchanged and still show the decimal separator from the old setting:
0020110107O0000000001|OTHER|07-JAN-11 08.06.00,296000 AM|07-JAN-11 08.04.41,008000 AM||0|0|EUR||NOT_FROZEN|MVOIP||IS_NORMAL_VERSION|MODIFIED|6863475590797607166|8648564326455689103|8011808169304472215|||CCP||||10000580||||DEKA|PSAny
[URL]......
[URL]......
[URL].....
[URL]......
Sqlnet.ora Network Configuration File (parameters Missing)
Dec 18, 2012Just now i create sqlnet,ora through NETCA
My SQLNET.ora contains following informations only..
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES)
*>> Help me >>*
why it did n't display all parameters ? I need to set SQLNET.AUTHENTICATION_SERVICES = NONE
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 Related