Forms :: What Is Exactly System.cursor_record
Sep 1, 2010what is exactly system.cursor_record?? actually i read documentation on that...but i still not getting..
View 2 Replies
ADVERTISEMENT
Forms :: Difference Between System.current_item And System.cursor_item?
Apr 1, 2012We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
Forms :: How To Know Operating System Current Path In Oracle 10g Forms
Apr 19, 2011How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedCPU System Time (percentage) For Multi Core System?
Aug 21, 2012couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
Forms :: Meaning Of System Message_level
Jul 3, 2010what is mean by system.message_level..
View 2 Replies View RelatedForms :: How To Stop System Message
Nov 3, 2010I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
View 3 Replies View RelatedForms :: System Date Change
May 18, 2013after change the system date form not working. (after enter value in a text field ,cursor not moving)
View 4 Replies View RelatedForms :: SYSTEM.BLOCK_STATUS Remains On Query
Feb 23, 2013The form is used to insert new customers into a table on the database, but also, it is used to QUERY the table, by using a customer_id entered by the user to see the details for a customer.
The scenario is that for a particular field on the table, CUSTOMER_ID, I want to conceal the data on this field ONLY when I do a QUERY.I got this to work by using the below in the POST-QUERY trigger on the block.
IF :SYSTEM.BLOCK_STATUS = 'QUERY' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
END IF;
However, after I do a QUERY, and I decide to INSERT a NEW customer into the table, I click on the button to do a NEW insert into the database, and when typing in the CUSTOMER_ID, it is still concealed and I cannot see what I am typing.
This shouldn't happen as I only want the data to be hidden/concealed when doing a query, but I do want to see the data I am typing into the field when I am doing a new Insert.
Forms :: Retrieving Images From File System
Sep 15, 2010I am trying to retrieve images from the file system, but the open dialog box is not popping up for me to choose which file i want. It does nothing gives no error. Just says record 1/1 on the message bar at runtime.
I have two blocks on the module. One is the lobs_table block and the other is the control block. On the control block i have a when-button-pressed trigger on an item. And here is the code below.
Declare
jpg_image_dir VARCHAR2(100) := 'C:UsersajayiaDesktopMe_pics';
photo_filename VARCHAR2(100);
BEGIN
:System.Message_Level := '25';
[code]......
I don't know the code to use to get forms to bring up the open dialog box.
Forms :: Picture In Database Or System Folder
Oct 5, 2010Where should one store pictures in database or read it straight from a folder stored in hard disk and why (performance talking)?
View 4 Replies View RelatedForms :: Get The Current User Login On System?
Jun 19, 2011How can i get the Current user log in on my system using global variable.
View 6 Replies View RelatedForms :: Trigger That System Generate Position Against Total Marks?
Aug 26, 2011i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
Forms :: Uploading Image Which Is Not Database Item From Operating System?
Sep 13, 2010uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.
I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;
But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.
Forms :: Replica Of Windows Explorer - Read UNIX File System
Jun 14, 2011I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.
Forms :: Write Trigger To Insert System Clock Time In Oracle?
Jan 4, 2013how can i write a trigger to insert the system clock time in the oracle form?
View 15 Replies View RelatedForms :: Hierarchical Tree - Make Information System Of Subjects And Corresponding Section?
Jan 26, 2012 I want to make an Information System of Subjects and its corresponding sections.Below is my desired output:
+ Sections
- Section 1
- Advanced Algebra
- Physics
- Section 2
[code]...
I wanna do it in a hierarchical tree, since I don't know how to do it,
Migrating To Newer System
Dec 21, 2011My manager has a couple of 2-proc dual-core Opteron servers with 8GB of RAM and RAID controllers. These servers currently run Solaris 8, but he wants to migrate them to a newer Linux systems.
View 4 Replies View RelatedSystem Generated Constraints
Jul 5, 2012I was wondering with dba_constraints and i found unexpected result shown as below
select constraints_name, constraint_type from dba_constraints
constraint_name constraint_type
SYS_C00141 c
SYS_C00142 c
SYS_C00143 c
SYS_C00144 c
SYS_C00145 c
SYS_C00146 c
SYS_C00147 c
SYS_C00148 c
SYS_C00149 c
i jst want to know that what is this system generated constraints ?
Importing Dmp File From One To Another System
Jul 23, 2013I have a dmp files of one table . the dmp files are from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
I want to export into my oracle db. i have not create any db or tables . i just installed oracle 11g.
System Tablespace Is Growing Up
Aug 19, 2010On one of our systems, the system tablespace ist growing up fast. The largest objects are:
SYS.C_OBJ# 3 GB (CLuster)
SYS.I_COL1 2,8 GB (INDEX)
SYS.I_COL2 1 GB (INDEX)
SYS.I_COL3 980 MB (INDEX)
why theses objects are going so big? Is it possible to shrink these objects? Table of the three index ist sys.col$ and part of CLuster sys.c_obj#
Windows :: Oracle 8i On XP System
May 12, 2002i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.
I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.
SQL & PL/SQL :: Field Keep On Getting Updated By Other System
May 20, 2011I have a promotion table which is having 3 columns.
PROMOTION_ID
display_name
ASSET_VERSION
This ASSET_VERSION
field keep on getting updated by other system where they may update the display name of the promotion_id.The main concept of this table is there will be a unique combitination of asset_id and promotion id.
Promotion_idDISPLAY_NAME ASSET_VERSION
123 1ST VERSION 1
123 2ND VERSION 2
123 3RD VERSION 3
456 1ST VERSION 1
456 2ND VERSION 2
456 3RD VERSION 3
789 1ST VERSION 1
789 2ND VERSION 2
789 3RD VERSION 3
So,my requirement is that i have the fetch promotion_id ,display_name that is having highset asset_version.
The OUTPUT SHOULD BE:
Promotion_idDISPLAY_NAME
123 3RD VERSION
456 3RD VERSION
789 3RD VERSION
I need a single sql for this .
Driver used: oracle.jdbc.xa.client.OracleXADataSource
Orcale version: 11G
Connecting Using SYS Or SYSTEM Sqldeveloper
Jan 4, 2011When I attempt to connect to the DB as SYS, SYSTEM using sqldeveloper I get:
ORA-01017:invalid username/password; logon denied
Now I am certain the username and password are correct, I think it has something to do with remote login of SYS account. Are DBA accounts not allowed to connect via network? I get the same error when I try to sqlpython wrapper which I believe uses TCP
[oracle@oracle ~]$ sqlpython sys as sysdba
which: no gedit in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
which: no kate in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
Password:
Connection failure.
Opens the DB connection. Some sample valid connection strings:
[code]....
SQL & PL/SQL :: Filter The System Grants?
Jun 3, 2010As per my req, i need to get the system grants of one user (GRANTEE) using DBMS_OUTPUT API. The requirement get completed using 'SYSTEM_GRANT' as parameter for OPEN function in the metadata api. Please look into part of code which works.
v_meta_handle := DBMS_METADATA.OPEN('SYSTEM_GRANT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'GRANTEE','SCOTT');
When using above piece, i get sys grants granted to SCOTT user. But i need to use 'DATABASE_EXPORT' as a parameter to my 'OPEN' function.
v_meta_handle := DBMS_METADATA.OPEN('DATABASE_EXPORT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'INCLUDE_PATH_EXPR','IN''SYSTEM_GRANT''');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'NAME_EXPR','IN''SCOTT''','GRANTEE_EXPR');
The second set filter doesn't work to get SYS GRANTS of one user. It does not throw any error. Simply the filter doesn't work. 'GRANTEE_EXPR' is not a correct value in the 2nd set filter. What parameter need to pass in object_path_expr ('GRANTEE_EXPR')?
Database Versus System Statistics
Aug 26, 2011In the article regarding gathering CBO Statistics, it states: QUOTE When an Oracle database is created, a job will be scheduled that will generate the database statistics for you. You will still need to collect system statistics however, as these are not collected by the automatic statistics gathering mechanism.
what is the difference between "database statistics" and "system statistics"? In other words, do I need to run this script for each schema owner in my 10g/11g instance?
variable whoami varchar2(20);
begin
select user into :whoami from dual;
end;
exec dbms_stats.gather_schema_stats( -
ownname => :whoami, -
options => 'GATHER AUTO', -
estimate_percent => 15, -
cascade => true).
Create System Generated Values?
May 14, 2007Lets say you're making upa school database and you awnted to give the students each a unique student number generated by thesystem.
View 2 Replies View RelatedSystem Error Code 14001
Jun 3, 2011We need to connect to an Oracle database from an ASP web page and I downloaded and installed ODAC112021.zip to a Window 2003 server; can connect OK I sent the zip to co-worker in another state and he installed it on slightly older build of 2003 server and we get the following error
"The setup routines for the Oracle in OraClient11g_home1 ODBC driver could not be loaded due to system error code 14001"
Only saw one post on OTN discussion and msot mention another error (998) [URL]
Server Administration :: System TableSpace Is So Big?
Sep 26, 2011Today I see my system tablespace is 98%, 480 MB used. Why the system tablespace is so big?
View 5 Replies View RelatedWindows :: System Admin Log In Error
Feb 6, 2013i want to log-in my local machine database as a system administrator , but it is giving an error:
C:Windowssystem32>sqlplus /@myprodb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-01031: insufficient privileges
Enter user-name:
C:Windowssystem32>sqlplus /@myprodb as sysoper
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-01031: insufficient privileges
Enter user-name:
but
C:Windowssystem32>sqlplus sys@myprodb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
and i have run cmd as administrator
SQL & PL/SQL :: Possible To Get Exact Name Of Constraint From Any System Table
Sep 1, 2010There was one constraint define on the column of table that the value of column should be in range of 100 to 200. Some one has deleted the constraint. Is it possible to get the exact name of constraint from any system table.
View 7 Replies View Related