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

Forms :: How To Use Duplicate Record Built In

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

Forms :: Post Built-in Commits Changes In The Database?

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

Forms :: Anyway To Speed Up Performance Of Go_record Built It

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

Forms :: Test Legacy Apps Built Using Reports 6i On Windows 7?

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

Forms :: How To Built Form (oracle 6i) That Connect With Report Builder

Feb 16, 2013

How i can to built form (oracle 6i) that connect with report builder ?

View 2 Replies View Related

Forms :: How To Hide Oracle In-built Message Which Appears At Bottom Of Window

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

Forms :: Assertion Failed Error On Oracle Forms 10g?

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

Standard Configuration That Uses Built-in Apache

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

Any Built-in Function (HOST) In Oracle

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

Built-in Function To Covert CURSOR To VARCHAR?

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

Getting Query Rewrite Using MV's Built From Remote Tables?

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

Forms :: Failed To Connect To Server

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

Application Express :: Is There A Built-in Substitution String For Item With Cursor Focus

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

Forms :: FRM-18103 / Failed To Initialize Development Environment

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

Forms :: REP-51002 - Bind To Reports Server Failed

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

Forms :: Creating Domain Failed While Configuring Oracle Instance?

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

Forms :: Stack Canvas Hides While Validation Of Any Item Is Failed On The Form?

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

TNS-03505 / Failed To Resolve Name?

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

ASM Diskgroup Creation Failed

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

SQL & PL/SQL :: Login Failed To Database 11.2 From SQL*PLUS

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

PL/SQL :: Failed To Process SQL Command

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

ASM Diskgroup Creation Failed Using Two Node

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

TNS-01153 / Failed To Process String

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

Enterprise Manager Configuration Failed

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

Security :: 12.0 - Oracle SIM Login Failed

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

Server Administration :: SQL Advisor Job Failed?

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

Creation Control File Failed?

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

Reports & Discoverer :: Authentication Failed?

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

SQL & PL/SQL :: Capture Log For Failed Login Attempts?

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







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