Forms :: FRM-40733 - PL/SQL Built-in DBMS_ERROR_CODE Failed
May 28, 2011
I have a client who is facing the above error. Everything used to work perfectly but since a week, he gets this error message on a specific FORM. No updates have been made to the FORM.
The FMXs are stored on the database server(10G R3, Windows 2003 R2) and the Client terminals access them through a network drive.When executing the conflicting FORM on the server, no error.
I call the DBMS_ERROR_CODE routine from a FORM-LEVEL ON-ERROR trigger :
DECLARE
ERR NUMBER;
BEGIN
IF DBMS_ERROR_CODE=-1 THEN
MSG('Client existant',ERR,'E');
ELSE
[code]....
Code for procedure MSG :
PROCEDURE MSG(TXT_MSG IN VARCHAR2 , RET_REP OUT NUMBER , TYPE_MSG IN CHAR DEFAULT 'I' ,
LABEL_BUT1 IN VARCHAR2 DEFAULT 'OK' , LABEL_BUT2 IN VARCHAR2 DEFAULT NULL ,
LABEL_BUT3 IN VARCHAR2 DEFAULT NULL) IS
VL_ALERT ALERT;
BEGIN
[code]....
View 6 Replies
ADVERTISEMENT
Jun 19, 2012
I have one form in which there are master detail blocks. I am entering one record in master block and corresponding entry in detail block. If again I am entering a new record in master block, of course the corresponding entry is getting erased since the block is getting changed.
After entering the data in master block I want to pop a message as 'whether you want to duplicate the same entry in detail block '. If yes, then how can I copy the same details which i have entered for previous record? Can I use duplicate_record built in? If yes, How?
View 1 Replies
View Related
May 7, 2010
I have been testing out a form using 10.1.2.0.2 on a v10.2.0.1 db and in my local env. the form works correctly i.e. if I make a change and 'post' it and then exit and press NO (when asked to save changes) then it correctly leaves the value in the database as it originally was.
The process works by the user pressing a button in form A (read only form) and this opens form B (using open_mode,session,activate) and the user makes their change(s) in form B (a 'post' command is issued in a When New Rec Inst trigger on a db block when the user navigates to a new record within the same block if it is determined that the block status <> 'QUERY') before returning to form A and pressing 'NO' when prompted to save changes.
However, if I run the same process in the TEST env. using the same executable against the same database then it actually updates the database value.
I have tested this by adding a debug message at the end of form B to retrieve the db value back AFTER having issued a clear_form(no_commit) just for the sake of the test and it still returns me the 'new' i.e. amended value - which is obviously incorrect. From what I can see it would appear that the commit occurs straight after the 'post' has been issued and well before the user even exits the form.
Is this a known bug with the 'post' built-in or could it be that a parameter is set to act in this way (i.e. is there an 'autocommit' setting that is 'ON') within the application server?
View 8 Replies
View Related
Mar 4, 2010
Is there anyway to speed up the performance of the go_record built it or is there an alternative way to do it.
I have a table with nearly 30,000 rows and I would like to implement a text field that will allow the user to jump to a specified record. The only problem is if they try to jump too far away it will take a long time to load (beginning to end of 30,000 takes over a minute).
This problem doesn't arise if all the records, or up to the one they are jumping to, have been fetched already, but even if I fetch all records at the beginning it will still take a long time to initially load them.
View 10 Replies
View Related
Jul 21, 2012
I still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
View 11 Replies
View Related
Feb 16, 2013
How i can to built form (oracle 6i) that connect with report builder ?
View 2 Replies
View Related
Mar 18, 2011
How to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.
View 2 Replies
View Related
May 4, 2011
I have several forms developed in Oracle forms builder 10g version 9.0.4.0.19. It contains Hierarchical Tree items. when i run this form on this version of oracle, it's running properly. but when i compile and run it on oracle forms 10 version 10.1.2.0.2, it shows an error message stating Assertion Failed!, if I click on the Tree item. I cant find out what and where the problem is. If I build a new form with tree item, it is working properly.
View 1 Replies
View Related
Jul 1, 2010
This error occurs while trying to print a report in a PDF format using Oracle Application Express 3.0. I'm not sure what this means and how to fix it. I'm running Oracle 10g on Windows Vista.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1186
ORA-12570: TNS: packet reader failure
This is the first time I'm attempting to print to a PDF. I did follow configuration according to the Oracle documentation. I selected the Standard configuration that uses the built-in Apache FOP or another standard XSL-FO processing engine.
View 6 Replies
View Related
May 30, 2012
saw in one procedure using host function in below manner.
v_status:= host(v_cmd);
But i searched for the host function it is not available.
My question is --Is there any pre defined built-in function "host" in oracle 10g.
View 1 Replies
View Related
Feb 13, 2007
know if there's a built-in function to covert an Oracle CURSOR to VARCHAR? Or how about a XMLType to VARCHAR?
View 1 Replies
View Related
Nov 19, 2012
Is it possible to have query rewrite using MV's built from remote tables?
11.20.2
View 1 Replies
View Related
Oct 15, 2010
I have a pb went i can access on my forms server:
FRM-92050: Failed to connect to the Server: ://127.0.0.1/servlet/oracle.form...enerServlet:-1
java.net.ConnectException: Connection refused
View 1 Replies
View Related
Jun 27, 2012
I was wondering if there is a substitution string ( or something else) that could be used to 'return' the name of a Form item that has cursor focus?
View 3 Replies
View Related
May 27, 2010
Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes.
When I try to open Oracle form builder I am receiving 'FRM-18103:Failed to initialize the Development Environment' error.
View 5 Replies
View Related
Jul 30, 2013
After I moved my servers (application and db) into a VPN network I am facing this error "REP-51002: Bind to Reports Server failed".
Product-Oracle Forms and Reports 11g
Servers(app and db)- Windows 2008
View 5 Replies
View Related
Feb 14, 2013
I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.
(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)
Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.
View 2 Replies
View Related
Oct 18, 2011
i have a form based on tab canvas. for some values(on form) i am hiding some fileds or a complete frame on the form using stack canvas. it works fine but if a user enters a wrong value in some field i.e enters character in number field the stack canvas hides(showing the hidden fields).
I tried to use on error trigger at form level and when validate item trigger to show the canvas but it first hides the canvas once right value is entered it just shows canvas again. following is the code i wrote
IF MESSAGE_TYPE = 'FRM' AND MESSAGE_CODE IN ('40209','50016')
AND :SYSTEM.TRIGGER_ITEM IN (some field)
THEN
IF other_item_value = 'E' THEN
SHOW_VIEW('STK_CAN_ARL_INFO');
END IF;
I need not to hide the canvas in any case whether any other field on the form is validated or not.
View 4 Replies
View Related
Oct 14, 2011
CODENAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
college=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
[code]...
This is my tnsnames.ora but when i try to tnsping college it gives me following error CODE[oracle@localhost 10.2.0]$ vi tnsnames.ora [oracle@localhost 10.2.0]$ tnsping college
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2011 14:37:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
View 1 Replies
View Related
Apr 12, 2011
i am trying to create the ASM diskgroup means it's giving the below error.
[root@racdb3 ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb6
Marking disk "VOL1" as an ASM disk: [FAILED]
View 4 Replies
View Related
Aug 23, 2011
I have laptop by this specification:
1) Operating System: Windows 7 64-bit
2) Virtual Machine: Windows XP Service Pack 3
3) DB: Oracle 11.2
4) Oracle Form Designer 4.5
i try to connect to SQL*PLUS 3.3 i got this error after defining in TNSNAMES.ORA in this folder c:orant networkadmin nsnames.ora
SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 18 19:49:12 2011
Copyright © 1982, 2010, Oracle. All rights reserved.
SQL> SHO USER
USER is ""
SQL> CONN SYSTEM@LOC
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
View 24 Replies
View Related
Apr 29, 2013
There is a stored procedure to which i am trying to schedule, but getting error as below:" Failed to process SQL command
-ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at line 2 "
I am not getting where issue is, as i am new to ORCL SQL Dev.
View 5 Replies
View Related
Mar 19, 2012
A am new in RAC configuration.I configuring RAC with ASM diskgroup with the external redundency. So now i am facing problem to mount the ASM diskgroup. I am giving the the RAC configuration description below.
1. using two node rac1 and rac2
2. asm disk configuration 3 drive
/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
on both node
3. and i am using vmware to configure the both node asmdisk group
after configuring the os level and oracle clustring , i run dbca to configure asm disk group..so in the create disk screen i have found my previous create 3 disks
/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
so first two disks
/dev/raw/raw1
/dev/raw/raw2
i named it "dg1" then press ok , when i pressed ok a warring is appear that is "could not mount the diskgroup on remote node on rac2 using the connection service rac2:1521:+ASM2. Ensure that the listener is running on this node and the asm instance is registred to the listener. Receive the following error:
ORA-15032 : not all alterations performed
ORA-15063 : ASM discovered insufficient number of disk for diskgroup "DG1"
as the same way i create another diskgroup "fg" for flash recovery area using disk /dev/raw/raw3
so after creating the two diskgroup i saw the two diskgroup is appere in the "diskgroup appere screen" an saw that only one diskgroup is mounted but not second node i.e. rac2 diskgroup is not mounted . What should i do no .
View 2 Replies
View Related
Aug 3, 2010
Long running data extract executed from SQL SERVER into Oracle.Process runs long time then chokes. What breaks after the process is running ?
03-AUG-2010 05:00:10 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4498)) * establish * MyDB * 0
03-AUG-2010 05:00:11 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4500)) * establish * MyDB * 0
03-AUG-2010 05:00:12 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4502)) * establish * MyDB * 0
03-AUG-2010 05:00:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)
(SERVICE=LISTENER)(VERSION=153092864)) * status * 0
[code]....
View 1 Replies
View Related
Jul 29, 2013
when i install a db using the Assistant Configuartion Database i get no error exept this:
Enterprise manager configuration failed due to the following error - Listener is not up. Start the listener and run EM configuration again. Refer to the log file at C:\Oracle\cfgtoollogs\dbca\emConfig. Log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\Oracle\product\11.1.0\db_1\bin\emca script.
So I try lsnrctl start and i get:
C:\Windows\system32>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:26:25
Copyright © 1991, 2010, Oracle. All rights reserved.
TNS-01106: Il listener con nome LISTENER � stato gi� avviato
So I try lsnrctl status and i get:
C:\Windows\system32>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:23:34
Copyright © 1991, 2010, Oracle. All rights reserved.
Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
[code]...
The file "server.xml" in E:\app\Andrea.Rimoldi\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\ does not exist...
Is there any way to retrieve or recover this file?
View 11 Replies
View Related
Aug 23, 2010
I Am unable to login in SIM 12.0.
I did nothing in server.
Should i do anything in LDAP..?
SIM user name and password is stored in LDAP. Its also running...
View 5 Replies
View Related
Nov 22, 2006
Trying to execute the following pl/sql block as user SYS in a Oracle10g v.2 database...
DECLARE taskname varchar2(30);task_desc varchar2(256);task_or_template varchar2(30);task_id number;wkld_name varchar2(30);saved_rows number;failed_rows number;num_found number;BEGINtask_id := 0;saved_rows := 0;failed_rows := 0;taskname := 'SQLACCESS6026890';task_desc := 'SQL Access Advisor';task_or_template := 'null';wkld_name := 'SQLACCESS6026890_wkld';/* Create Task
[code]...
What can I get rid of these errors??
View 5 Replies
View Related
Nov 30, 2004
I am cloning a database from a cold backup in archivelog mode using the control file script but failes:
STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD NORESETLOGS ARCHIVELOG
:
:
:
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORADATA\PROD\TEMP01.DBF'
[code]...
Tried again with RESETLOGS:
STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD RESETLOGS ARCHIVELOG
:
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00344: unable to re-create online log 'D:\ORADATA\PROD\REDO01B.ORA'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
View 3 Replies
View Related
Sep 13, 2011
I have developed a report and deployed it to the oracle apps and it was working fine and now the developed object is migrated to the test environment (testing database) and tester ..
Now the report when i test it the devlopment evnironment...It throws error saying "Authentication Failed".
View 3 Replies
View Related
Nov 15, 2011
I am using the below code to capture all important logs when user failed to login on database , but i cant capture the username which are failing to connect on database.
CREATE OR REPLACE
TRIGGER failed_logon_notifications
AFTER SERVERERROR ON DATABASE
[Code].....
View 3 Replies
View Related