How is mapping of name of DLL and function done?
The dll can be created using the Visual C++ / Visual Basic Tools and then the dll is put in the path that is defined the registery. Read more »
Archive for May, 2008
What are savepoint mode and cursor mode properties ? level?
Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE data... Read more »
What is transactional trigger property?
Identifies a block as transactional control block. i.e. non - database block that oracle forms should manage as transactional block.(NON-ORACLE datasource) default... Read more »
What is OLE automation ?
OLE automation allows an OLE server application to expose a set of commands and functions that can be invoked from an OLE container application. OLE automation provides... Read more »
What does invoke built-in do?
This procedure invokes a method. Syntax: PROCEDURE OLE2.INVOKE (object obj_type, method VARCHAR2, list list_type := 0); Parameters: object Is an OLE2 Automation... Read more »
What are OPEN_FORM,CALL_FORM,NEW_FORM? diff ?
CALL_FORM : It calls the other form. but parent remains active, when called form completes the operation , it releases lock and control goes back to the calling... Read more »
What are the characteristics of data files ?
A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage... Read more »
What is a datafile ?
Every Oracle database has one or more physical data files. A database’s data files contain all the database data. The data of logical database structures such... Read more »
What are the uses of rollback segment ?
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users. Read more »
What is a data segment ?
Each non-clustered table has a data segment. All of the table’s data is stored in the extents of its data segment. Each cluster has a data segment. The data... Read more »
What are the different types of segments ?
Data segment, index segment, rollback segment and temporary segment. Read more »
What is row chaining ?
In circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs, the data for the row is stored in a chain... Read more »
How to define data block size ?
A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block... Read more »
What is data block ?
Oracle database’s data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk. Read more »
What is network database link ?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies... Read more »