I have problem writing condition to exit the for loop..How can I exit after finish printing
PROCEDURE find_stu_age_given_id(s_sid number)
is
cursor c1 is select * from student where sid=s_sid;
age number;
begin
For i in c1
LOOP
age :=to_char(SYSDATE -i.dob);
dbms_output.put_line(i.sid ||' age is '|| age/365);
END LOOP;
end find_stu_age_given_id;
I have received a service ticket from QA regarding one of the application forms does not close out even after the exit button is pressed. Instead, it goes to the previous record and continues to do so if there are multiple applications created and then exits at that point.
The end users are not liking that feature and I am unable to detect this error.. What kind of trigger should i apply and what do i write in this trigger.
How can we tune our RMAN Duplicate as it was taking 10+ hours to finish. Current production database size is 800GB. Approx duration of rman online backup (FULL, including archived logs) is 4 to 5 hours.
Here's the rman backup script we used: sql 'alter system archive log current'; list archivelog all; run { show all; report schema; backup database plus archivelog delete all input; } exit
Here's the rman duplicate command we used: run { set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 02:30:00', 'Mon DD YYYY HH24:MI:SS')"; allocate auxiliary channel ch1 type disk; duplicate target database to testdb; } exit
I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
Suppose have the following condition in my procedure :
IF var_count = 0 then 'stop processing' --EXIT PROCEDURE ELSE 'continue processing' END IF;
How do I stop futher processing if var_count= 0 . I think about raising an exception...but is there another way out..like a command 'exit' to stop further processing ?
I had used a When-Validate-Item trigger against an text item.
Also i had a push button (EXIT) for Exiting from the Form with code : Exit_Form(no_validation);
But if an invalid text is entered in the Text-Item and after that if i use the EXIT push Button then it doesnot exit from the Form till a valid text is entered inside the Text-Item.
how to Exit from Form even if the Text-Item has Invalid Value.
This Is My Code ------------------- Declare obutton number; begin
obutton := Show_alert('ALT_EXIT'); clear_block(no_validate); If obutton = ALERT_BUTTON1 Then -- commit; exit_form(no_validate); else exit_form(no_validate); end if; end; -------------------- But When I pressed Yes Or No the database is not update. Why ? I have save My data with save button already no problem but why i close this form The data is'nt save?
So i have to put "summit;" in it when ALT_EXIT pass another warning* appear how do i exit program without the second warning
*it say about"2 record i already updated" about this but i can't remember exactly.
I have created one master detail form where on master i have one field with name status and if the status is changed to A it will prompt me to another detail block where i will fill the details and in case after i entered the details and then i decide it not to save and come back to main form without saving...how i can do it . I used go_blok In detail to go to master it goes to master but when i am saving the master the details get saved along with it.I dont want to save the detail and go to master block.
I have a series of sql files that I need to execute via sqlplus. What I do need is to immediately exit the sqlplus instance upon completion of the script. Now, I am not using a batch file, nor a file containing script files where I can add the EXIT command.
I have to effectively run each script from the command line as such:
Now this works, but once it runs the SQLPlus window is still open. Now I have an event handler (in a c# wrapper) that is supposed to fire once the process terminates...but of course, this even never fires since the sqlplus process doesn't terminate after running the script.
Is there any any any any way to get sqlplus to run this script and then self-exit??
I have no control of the sql script and cannot edit them to include an EXIT command. I need to run them as is.
I would like to exit from a cursor loop based on certain conditional checking. I am checking for a lot of different parameters and if they fail, I want to bypass it and fetch the next record in the cursor. I tried just putting an 'Exit' statement in the logic, but it fails. An example of my code is below:
For Row1 in cursor1 Loop If amount < 0 then balance := 0; Else
I am running 3 for loops in continuation. These loops retrieve me 63 values. I need to insert 1 single row in a table and then exit from the same. Moreover when i run the same loop again I need to insert 2nd value fo the second row in the table. The table is having a unique key which does not allow me to load redundant data.
In this scenario(within procedure) 1st cursor return data but 2nd cursor showing error like ORA-00942: table or view does not exit.
declare cursor r1 is select table_name,table_partition_name from abc where table_partition_name like 'NORMAL_P%' and base_table_name like 'NORMAL' and date_column_name like 'C_DATE' and to_date(to_char(from_date,'dd/mon/yyyy'),'dd/mon/yyyy') between '25-jun-2010' and '27-jun-2010' order by substr(table_partition_name,19,4); [code].....
We are using Oracle APPS. Currently We develop the Separate Responsibility in it.
In a Entry Screen, it contains three Blocks. During the Close through the Close Button in Top(Like (X)), It move to Another Block after close that window then only the form Closing.
In the same form when we press the F4 it Exit Without that Operation.
I have all my tables populated but for one table in particular everytime i shut down the command prompt the rows i created erase themselves. Even when i try to bring up that same table in TOAD while the command prompt is still open all the other tables besides that one in particular wont show my rows. What is going on? I was previously messing with some functions and triggers for that table but i can't remember what exactly I was trying to do. Could that have something to do with it?
I am using the notification from COM.ORACLE.APEX.GRITTER_NOTIFICATION but i am trying to make the exit button/icon be displayed all time. By default the exit / close button only appears when mouse over it what about if i want the icon to be displayed all time?
I have a script which connects to Oracle and return 2 date value. few days back the database was down and when the script execute and return same garbage value in the spool file.
I added a exception handler WHENEVER SQLERROR EXIT 1 befor the connection start and after connection start. But in both the case it is also writing to the spool file.
I would like to exit the connection with a value <> 0 if any connection issue happens like (user id, password, database down error type of issue.) No information should go to the spool file
Iam using Oracle DB 10g on HP-UX and accessing reports from windows based server as pdf format , After generating report i can save a copy only no exit option from reports and force to exit with shift+f4.
I am trying to xcom the file from Linux server location to Windows server location through shell script. When i execute my DBMS_SCHEDULER to trigger the shell script i am getting the below mentioned error.
Error report: ORA-27369: job of type EXECUTABLE failed with exit Exchange full ORA-06512: at "SYS.DBMS_ISCHED", line 150 ORA-06512: at "SYS.DBMS_SCHEDULER", line 441 ORA-06512: at "CUSTDOMAIN.TSC_041_REPORT_PRC", line 50 [code]....
I am facing a problem while installing Oracle11gR2 in my laptop having windows 7 basic edition. Initially i reached till step 16 which is "Prerequisite check" after giving the schema password . But then suddenly the installer got excited. After that when i again tried to run the installer at the 3rd stage of installation when i am clicking the next button the installer is getting excited.
How to reslove this issue and get oracle 11gR2 installed in my laptop.
I have created a simple external job to run export (expdp) job to be run from PL/SQL. When I create a job as SYS user, the job runs good but the same fails when I execute it as application user. I am certain that I am missing some privileges.
In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit.
Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .
I am currently printing from a DOS window to a Zebra printer as follows:
-Start, Run -ftp to the print server -enter userid and password -type in put <filename>.zpl
However, at the supplier site, I am being asked for a simple print command that would send the .zpl file to th printer that would print the label (Open a file, click on print).
Here are the printer details that I am using:
Model: Zebra170XiII Host: sfezebra Version: V18.7.1 Serial Number: 716314
I have table data in which we are entering Visitor's information.We need a monthly report with the count .There are some months which dont have data .So Names of month are not coming .Can i Print Month Name with 0 visitor.
Sample Data
Quote:ID Name Visit_date 1 ABC 01/02/2011 2 DEF 03/04/2011
im using query
Quote:SELECT count(ID) Nos ,TO_CHAR(visit_date,'MONTH') Month FROM DELEGATE_DETAILS WHERE visit_date BETWEEN '01/02/2011' AND '01/04/2011' GROUP BY TO_CHAR(ARR_DATE,'MONTH') ORDER BY TO_CHAR(ARR_DATE,'MONTH'); Output Quote:Nos Month 1 February 1 April
Desired Output:- Quote:Nos Month 1 February 0 March 1 April
I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.
but when using the Cleint_ole2 on the application to invoke an object on the client machine.
but nothing happend, while i have tested the webutil configaration and its working fine.
i use this code to print any word document without openning it. and here is the code in when_button_pressed
DECLARE application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE begin application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters -- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block