Forms :: Getting Error Frm 21011 While Calling From Menu

Jun 5, 2012

getting error frm 21011 , ora -65020 , while calling forms from menu , the forms are also passing parameters between forms 1 and forms 2 .

The following code is in menu item .

declare
uname varchar2(30);
cname varchar2(40);

[code]....

View 1 Replies


ADVERTISEMENT

Forms :: Create Main Menu For Calling Reports

Dec 3, 2010

Application developed in form builder 6i.Now I want to create main menu for calling forms and reports.

Should I use buttons or drop down menu?

View 2 Replies View Related

Forms :: How To Design Hierarchical Tree Menu For Calling Reports

Mar 17, 2013

How to design Hierarchical Tree Menu for calling forms & Reports.

View 2 Replies View Related

Forms :: FRM-21011 - PL/SQL Unhandled Exception ORA-306500

Dec 26, 2006

I am getting the follwoing error at the time of opening the application menu

FRM-21011: PL/SQL unhandled exception ORA-306500.

View 9 Replies View Related

Forms :: After Upgrading To 11g / FRM-21011 - PL/SQL Unhandled Exception ORA-06508

Mar 16, 2012

After our client upgraded to 11g database and application server, they are getting this error while trying to access another form from the option menu (The option menu is generated with a library, the values are taken from a database table). This issue occurs only in one particular scenerio, and only in on form, other forms with similar functionality and same structure are working perfectly fine. The error is written below.

FRM-21011: PL/SQL unhandled exception ORA-06508

I tried in my environment (10G), no error exist there.In 11G environment, I tried re-attaching a library in the form and compiling again, the error does not come after recompiliation. But the client can still see the error even after recompiling the form (after reattaching that particular library).I could find the below info on google:

FRM-21011: PL/SQL unhandled exception %s.
Cause: An unhandled exception occurred while executing a menu trigger.
Action: Examine the text of the exception in this message. If this indicates a cause,
correct it. If the problem persists, contact Oracle Support Services.
Level: 25
Trigger: None

I am using form builder 10G, will compiling the form using Form builder 11G?

View 4 Replies View Related

Forms :: How To Display Menu Instead Of Default Menu

Apr 19, 2013

i 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 Related

SQL & PL/SQL :: Error In Calling Collection Procedure

Jun 4, 2013

In a package I have one procedure "setscores_ram_bulk" with collection varaiavles.And other two procedures are

"UpdateRelatedOrders" and "SetGeoFraudScore"

with out collections.I am calling collection procedure "setscores_ram_bulk" in non collection procedures

"UpdateRelatedOrders" and "SetGeoFraudScore".

I am getting the below error.PLS-00306:wrong number or types of arguments in call to 'SETSCORES_RAM_BULK' .I am sending my code.

CREATE OR REPLACE PACKAGE GAFT_PROG_DIT.INTERNAL_SCORING_setscore_Bulk
IS
TYPE rec_setscores IS RECORD
(
pBUID score.buid%TYPE,
OrderNum score.order_num%TYPE,
ScoreType VARCHAR2(100),
p_Score score.velocity_score%TYPE
);
[code]....

View 19 Replies View Related

Error While Calling External C Function From Oracle?

Apr 7, 2011

I tried to use external C procedure from the database and i did all required steps as below.
1. create a C program
2. compile and link the C program
3. copy it to the Oracle_home/bin directory
4. configure listener.ora and tnsnames.ora files

listener.ora
=======
callout_listener =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP) (HOST = ip_address)(PORT = 1521)

[code]...

View 4 Replies View Related

SQL & PL/SQL :: Error Occurred Calling A Web Service Using UTL_HTTP

Jun 27, 2013

I'm calling a web service with HTTPS protocol from a pl/sql program and i'm using the UTL_HTTP package for do this.

I have a Oracle DB installation 11g Enterprise Edition Release 11.2.0.1.0 on my personal computer with a Windows XP OS, and when i run the code it works fine and returns the result I expect. But, when i run the same code on the Oracle DB of my work (Oracle 10g Enterprise Edition Release 10.2.0.4.0 and OS HP-UX) it fails and give me an error, i think that the error has to do with the configuration of the wallet and the certificates in it, because i consume the WS from Os prompt using the command WGET and works fine and i test consuming a WS with HTTP no secure and works fine too.

This is the code and the result in the Oracle DB 11g on my computer:

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as oe@oRCL

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code]....

PL/SQL procedure successfully completed

SQL>

And this is the code(Is the same, the only difference is the path of the wallet) and the error resultant:

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as gpacheco@acseld

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code].....

View 4 Replies View Related

PL/SQL :: Not Getting Error Code And Message Back In Calling Proc?

Sep 19, 2012

create or replace package body test_exp_pkg as

procedure l_test_exp (errcode out Varchar2, errm out varchar2)
as
l_rec zt574%rowtype;
begin

[code]]....

output:
---------
anonymous block completed
in package init
caught in l_test_exp-1422ORA-01422: exact fetch returns more than requested number of rows
caught in l_test_exp errcode and errm set to -1422sqcORA-01422: exact fetch returns more than requested number of rows
caught in test_exp1User-Defined Exception
caught in others errcode and errm

View 8 Replies View Related

Forms :: Add Scroll Bar On Menu?

Jul 26, 2013

I 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 Related

Forms :: How To Get Menu Item Name

May 5, 2009

I 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.

View 10 Replies View Related

Forms :: Report Run From Menu

Dec 7, 2010

I 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.

View 1 Replies View Related

Forms :: Menu Not Replacing In 11g?

Jul 25, 2012

In 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 Related

Forms :: Run Reports From Menu?

Feb 14, 2010

Recently 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]...

View 1 Replies View Related

Forms :: Creating Menu In 10g

Mar 30, 2011

I 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?

View 6 Replies View Related

Forms :: Navigation Between Forms Via Custom-menu?

May 23, 2011

what 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?

View 3 Replies View Related

Application Express :: Error When Calling Skillbuilder Popup In Edit Record Mode?

Jan 3, 2013

Iam facing another issue with Skillbuilder modal page(for those who have used this plugins). Ive the CREATE part working well the problem is with EDIT part to edit records via the link i applied all the steps and clicking the edit link pops up the page but the issue is for any clicked row the parameter is not being passed and seleceted record doesnt show on the pop up page where could the problem be? though if i set it back to normal link created by the wizard the edit link works well and shows that record on the editable page.

Apex 4.1.1/oracle 11gR2 ; issue happens in FF & IE

View 3 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 :: How To Pass Menu Parameters In 10g

Aug 5, 2013

I'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 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 :: ORA-31640 While Compiling Menu In 6i

Oct 22, 2011

I 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

Forms :: FRM-10221 / Can't Read Menu

Oct 10, 2010

I 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

View 3 Replies View Related

Forms :: Put On Form1 Different Menu Then One On Form2

Jan 26, 2013

I 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.

View 2 Replies View Related

Forms :: How To Hide MENU And TOOL Bar

Jun 22, 2012

i want hide the content shown in the picture

View 6 Replies View Related

Forms :: Disabling Item From The Menu?

Feb 15, 2012

I 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?

View 4 Replies View Related

Forms :: Hierarchical Tree Menu

Nov 30, 2010

I need complete source from hartical tree menu using by calling reports and calling forms.

i need related Table ,triggers and Examples.

View 4 Replies View Related

Forms :: How To Create Icon Menu

May 29, 2010

I want to create icon menu.

It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.

View 3 Replies View Related

Forms :: Creating Menu In A Form

Jul 13, 2010

I 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 .

View 1 Replies View Related







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