Forms :: Oracle 6i Exiting Automatically?
Mar 31, 2013After compiling in few minutes My Oracle Forms 6i Form is exiting automatically ... How to solve this problem.
View 1 Replies
ADVERTISEMENT
List Exiting Databases In Oracle Server Using SQL Plus Command?
Feb 14, 2013I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?
View 1 Replies View RelatedForms :: How To Generate Numbers Automatically In Multirecord Table Using Oracle 6i
Sep 28, 2013I have two control block i.e. class_register and student_info. In which student_info is multi-record block which contains stud_id, stud_name, stud_roll_no. Based on the class_register block, stud_id and stud_name is generated in the student_info table. Now I want to generate stud_roll_no automatically until the last record is present.
View 4 Replies View RelatedForms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table
Dec 25, 2011when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies View RelatedForms :: Commit Record Automatically?
Mar 15, 2010I have a master detail form based on two tables and i want to save the record automatically when the user exits the last field.how i can do it.which trigger is appropriate and what is the code.
View 8 Replies View RelatedForms :: How To Change Tab Page Automatically
Jul 23, 2011How to change tab page automatically?I have two tabs.in first tab i have placed one button if i press this button first tab should be changed into second tab?
View 1 Replies View RelatedForms :: How To Remove Message That Come Automatically
Mar 2, 2010How can I remove (record asved) message that come automatically after commit??
View 5 Replies View RelatedForms :: Inserting ID / SYSDATE And USER Automatically?
Aug 5, 2010 I have created a datablock and set up the user interface to allow the users to insert all the data they need, however my table has some fields which should be generated automatically and are not done through user input:
id - which is uniqe to each entry to the table so is gernerate by a sequence (which I created on the database) but when i put seq.nextval into the initial value on the datablock it says i cannot do this, so how do I use the sequence to insert the value into that field in the database. This is my primary key in my database whichobviosuly my users cant input data to, instead it is generated automatically.
User - similarly in the datablock is a user field which states the user that inserted that record, I know on the database i can put DEFAULT user for that field , but how do I make the user insert automatically through forms.
Date - Similarly again how do I set SYSDATE to be automatically input to the date field when the user submits the record?
SQL & PL/SQL :: To Run Procedure In Oracle Automatically At 5 Daily
Sep 17, 2011i want to run the salary posting procedure automatically at mid night every day. i have created a job in toad and defined the required information but it is not working.
View 13 Replies View RelatedOracle 10G Listener Stops Automatically
Mar 8, 2011We have installed Oracle 10G in windows 2003 server. Oracle is working fine when oracle services are running in local system account, when we change the option �Log On As� from local system account to an domain id the oracle listener stops automatically.
I tried the below mentioned options, We created a new listener it did not worked . we are able to connect the db through command prompt but not through SQL plus or TOADWhen we add the domain id to the local administrator group the oracle is working fine. But we cannot have the domain id in local administrator group since GPO will automatically remove the domain id from local administrator group.
Forms :: Insert Date And Time Automatically In Table
Apr 29, 2013i have emp table of 5 columns empno,ename,dept,sal,edit_timing(edit timing datatype is timestamp).and my form contains empno,ename,dept,sal. is if i insert a record into forms it automatically insert the date and timing into edit_timing columns.
View 2 Replies View RelatedForms :: SUBMIT Buttons Which Is Disabled / Gets Enabled Automatically
Apr 3, 2012I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.
View 4 Replies View RelatedReplication :: Oracle 9i - Does Not Push Transactions Automatically
Jun 7, 2002I have problem with my Replication using oracle 9i.It does not push transactions automatically when refresh time comes but it works fine when pushed manually.I have two sites:
1- Master
a-Master group
2- Materialized view site
a- Materialized view group (Asynchronous)
b- Materialized view with refresh occur automatically on future date every 5 minutes
c- refresh type FORCE.
SQL & PL/SQL :: Oracle Jobs Not Start Automatically As Per Interval?
Dec 20, 2010My Oracle jobs are not running. I can run them manually but they don't start automatically as per interval. The job_queue_processes=100 and CJQ process is not running. I started CJQ0 process by resetting it to 0 and then to 100. But as soon as I enabled a job this background process stopped.
The job also did not execute in its next execution time. I have created the database manually without using DBCA. Is the problem because of this? I have set crontab immediately to get rid of it.
Forms :: Upload Data Using 6i While Compiling Form Automatically Closed
Dec 6, 2010i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this
begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....
Forms :: Organization Chart - Generate Automatically Without Opening Any Program
Apr 11, 2007I need is to generate this chart automatically from the form builder without opening any program like visio (for instant). that's mean when I select the wanted department the chart will be generated automatically .
View 9 Replies View RelatedALL Scripts Which Automatically Get Run By DBCA In ORACLE 11G Enterprise Edition
Jan 19, 2013which are ALL the scripts which automatically get run by DBCA in ORACLE 11G Enterprise Edition.
View 2 Replies View RelatedEnterprise Manager :: Oracle 11g Console Not Starting Automatically And Manually?
Jun 10, 2011When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.
'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.'
In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and
The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
SQL & PL/SQL :: Will Oracle Automatically Deallocate Memory Occupied By Records In Cursor Area
Feb 25, 2013i have a ref cursor and i have used 'open cursor for' statement:
CREATE OR REPLACE PACKAGE aepuser.pkg_test
AS
TYPE cur1 IS REF CURSOR;
PROCEDURE get_empdetails (p_empno NUMBER, io_cur OUT cur1);
END;
[code]...
then i want to know that- will oracle automatically deallocate the memory occupied by records in cursor area?if yes, then when it will be free , in case of 'open cursor for' ?
Forms :: Expiry Date To Automatically Show A Date 15 Years After Initial Date
Apr 12, 2010I have a two date fields in my form; valid from date and expiry date.
Currently my valid from date has an inital value property of $$date$$ which automaitcally brings up todays date.
I need my expiry date to automatically show a date 15 years after this date?
SQL & PL/SQL :: Get End Date Automatically?
Mar 24, 2012I have these table :
create table mvt
(
id number(1) ,
dat date
)
/
insert into mvt values (1, '2.10.1999');
insert into mvt values (1, '1.08.2005');
insert into mvt values (1, '24.09.2008');
commit;
I want to build a query for id = 1 that retrieves this :
START END
-------- --------
02/10/99 31/07/05
01/08/05 23/09/08
24/09/08 {sysdate}
{sysdate} represents the current date.
I've tried with these query :
select
old.dat
, next.dat - 1
from mvt old, mvt next
where 1 = 1
and old.id = 1
and old.id = next.id
and next.dat in (select min(dat) from mvt where id = old.id and dat > old.dat)
/
But it delivers only this :
DAT NEXT.DAT
-------- --------
02/10/99 31/07/05
01/08/05 23/09/08
Is there a way to retrieve all what I want in one query (without unions or functions that gives the last date for id) ?
How To Bounce Database Automatically
Aug 11, 2011I want to write a script and schedule it in crontab, if it is ebs I have scripts addbctl.sh and addlnctl.sh to stop database and listner. But in another application (not ebs) these scripts are not available and I have to manually bounce database, giving commands SHUTDOWN IMMEDIATE and STARTUP after logging in into sqlplus, Is there any way to do this.
I tried a script to test whether it is connecting to database or not, but it is not working. This is the script I have written in invalids.sh
sqlplus apps/pwd
select count(*) from dba_objects where status='INVALID';
exit
echo "test ran at $(date)"
When I run this script in crontab , it is not working
04 12 * * * SCRIPT_PATH/invalids.sh >> SCRIPT_PATH/logs/test.txt
Also I tried whether crontab is working or not with this line
08 12 * * * echo "crontab tested at $(date)" >> SOME_PATH/tested.txt
In tested.txt, it is printing that output properly like this
crontab tested at Thu Aug 11 12:08:01 IST 2011
Dbms Job Is Not Executing Automatically
Aug 11, 2011Database 1(sm01):
=============
oracle, 9.2.0.6
there are 4 jobs scheduled in oracle dbms_job. 3 jobs will run everyday at 4.00AM. 1 job will run at every hour.Daily jobs are running fine. But hourly job is not executing automatically. If forced (exec dbms_job.run(<enter here job number>), this execute fine.
job_queue_processes=5
total jobs in schema=2503
total jobs in db = 2614
Even there are many jobs scheduled, next_date for 2234 jobs are lesser than the sysdate. Again in 269(2503-2234) jobs, 2265 are having NULL in the interval column.
Database 2(sm02):
=============
oracle, 9.2.0.6
there are 4 jobs scheduled in oracle dbms_job. 3 jobs will run everyday at 4.00AM. 1 job will run at every hour.All the jobs are not running automatically. If forced (exec dbms_job.run(<enter here job number>), these execute fine.
job_queue_processes=5
total jobs in schema=7
total jobs in db = 7
I planning to follow the below steps to avoid the above issue.
1.) Restart the job queue process by executing alter system set job_queue_processes=0
2.) Increase the value for the job_queue_processes.
3.) Restart the database
But I got stuck in the 2nd step. what value I need to put for this job_queue_processes parameter?
Automatically Create Many Tables From 1 Big Table?
Aug 30, 2007I have a table with over 100000 records.
The format and data is something like this:
Region Code,Name,Surname,ID_Number
1,John,Doe,67
1,Sarah,Jason,45
2,Bob,Marley,69
3,Steven,Johnson,900
2,Harry,Potter,890
3,Sandy,Bay,567
3,Else,Taylor,789 .....
I have about over 100 region codes and each region would like to get their own data. I can manually do the extraction and create a new table for every region, but it's going to take too long.
Send CLOB Data Automatically Using CDC?
Jan 5, 2012I want to know whether is it possible to send CLOB data automatically using CDC...i usually have to run a procedure manually to send such data to remote locations.
View 1 Replies View RelatedHow To Kill Inactive Connections Automatically
Apr 26, 2011i was gone through the below link
[URL]
so when i changed my idle_time value in profile and the when the user exceeds the idle_time value the user still i can see in-active state in v$session.
and when i was tried to execute any query on inactive session that time i got an ORA- error and then session was not visible from v$session.
in my environment inactive session was not getting used afterwards so is there any way to kill that sessions automatically once reached idle_timeout value.
lets say i have 50 max sessions, out of which 10 are inactive state and 40 in active state .what if i created one more sessions will that give me ORA- error stating max sessions reached or it will kill the one session which are in-active state.
TNSListener Service Stops Automatically?
Apr 7, 2011In our production server, TNSListener Service stops automatically, atleast (once in a day). No alert in alert log file.
View 1 Replies View RelatedSQL & PL/SQL :: View - How Grants Are Revoking Automatically
Nov 5, 2010We have two schemas(sdt & sdm) in one database.
We have base tables in "sdt" ,
Views are created in "sdm" schema based on the "sdt" schema tables We have granted privileges on the base tables of "sdt" schema to "sdm" schema.
Sometimes views are not able to access by sdm schema.Again we are granted privileges on the base tables of "sdt" schemathen views are able to access.How grants are revoking automatically.
Tools That Erases The Logs Automatically?
Nov 19, 2006I have Sap r/3 system which runs on Oracle 9 database. The problem is that the sql queries produces an awful lot of logs thus my disk is full after very short time.
I do not need the logs since its development environment. Are there any tools that erases the logs automatically?
How To Kill Invalid Sessions Automatically
Jul 3, 2013On the oracle 11g, we see too many invalid sessions. Because of which, login is getting restricted. What do i need to do to kill those invalid session periodically, which will avoid of restarting of system.
View 4 Replies View Related