the code as follows
create or replace
procedure Country_sel(key in varchar2)
as
cc Res_RelcountryLan.countrycode%type;
len Res_Language.langname_en%type;
lid Res_Language.langid%type;
ab Res_Language.Abrivation%type;
[code]....
when i am running this code im getting
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RASOOL.COUNTRY_SEL", line 11
ORA-06512: at line 6
in below program,i have to pass column name to cursor at runtime..but this giving error.
DECLARE
TYPE EmpCurTyp IS REF CURSOR;
v_emp_cursor EmpCurTyp;
emp_record hr.employees%rowtYPE;
v_stmt_str VARCHAR2(200);
colname varchar2(10):='Last_name';
BEGIN
[code]....
dbms_output.put_line(emp_record);
*
ERROR at line 13:
ORA-06550: line 13, column 1:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
ORA-06550: line 13, column 1:
PL/SQL: Statement ignored
How To Display Runtime Calculation in cursor for example in loop i define xyx number then add + 1 in xyz and move its value to block item until loop valid but in display no value shown but if i apply message(xyz) then it also shown the answer is correct but with message style i click every time in message but i want that with some delay form automatically show the value of xyz in block field.
View 3 Replies View RelatedOracle Version: 11.2.0.2.0. I have two explicit cursors and I would like to choose at run time which one to run. Here is a simplified code snippet of what I am doing today:
DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';
[code]....
I want to avoid maintaining the same long list of transformations. I also want to avoid, if possible, an explicit FETCH INTO, because there are hundreds of fields in both tables. I'm looking for something like this (and I know this doesnt work):
DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';
CursorToRun IS REF CURSOR;
[code]....
I'm having a problem with null values. I want to display old student in a display item if subjects text item has records. Otherwise, display new student if it has null values. This is the code that i tried so far..
IF :block2.subjects IS NULL THEN
:block3.type := 'NEW STUDENT';
ELSE
:block3.type := 'OLD STUDENT';
END IF;
But i got logic error during runtime.
I am trying to install the 11GR2 on HPUX 11.31 U ia64 with silent option.while tried to launch runinstaller, I hit the below issue.
dfltest> ./runInstaller -ignoreSysPrereqs -force -silent -responseFile > /db/dfltest/oracle/product/11.2.0/database/db_install.rsp.mainStarting Oracle Universal Installer... Checking Temp space: must be greater than 240 MB. Actual 475 MB PassedChecking swap space: must be greater than 150 MB. Actual 23189 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-17_12-01-18PM. Please wait ...oradev1 oradflts /db/dfltest/oracle/product/11.2.0/databasedfltest> Error: could not find libjava.soError: could not find Java 2 Runtime Environment. ----extracted from following files -----p10404530_112030_HP64_2of6.zipp10404530_112030_HP64_1of6.zip
Environment is CentOS 6.3, 64-bit OS
I get the following error when I use the universal installer (runInstaller.sh)
OUI-10150: Error: A runtime execution error occured while setting s_digcfgnaminglabel isidnull in compnent oracle database 11g 11.2.0.1.0. Installation cannot continue for this component.
I have check my /etc/hosts entries and I believe my jre paths are correct since I get the JAVA windows.
My task has more lines of code,so i tried to present here only few lines of code where i am getting the error.The following cursor needs to select data from two tables with some conditions that are included in cursor and place those in other table.I used BULK collect.
CURSOR c_arch_trk (p_run_date DATE,
p_nbr_days_arch1 NUMBER,
p_nbr_days_arch2 NUMBER )
IS
SELECT a.SIS_PGM_START_DATE,a.SIS_PGM_END_DATE,a.PGM_MSTR_NBR,a.PGM_TRK_NBR,a.CNTL_LOCN,a.CMPNY_VNDR_NBR,a.AGRMNT_MSTR_NBR,
a.SLS_CONT_NBR,b.PGM_NAME,b.PGM_BASIS,b.AGRMNT_CNTL_LOCN
[code]....
I have this stored procedure as part of package.
PROCEDURE XCOM_X060_UPDATEOHBFAILURE( in_CALL_ID IN NUMBER,
in_SPLY_REORD_NO IN CHAR,
in_OHB_QTY_CARTONS IN NUMBER,
in_OHB_QTY_UNITS IN NUMBER,
in_SPLY_TOT_OHB_QTY IN NUMBER,
in_OHB_INPUT_CTNS_MIN IN NUMBER,
in_OHB_INPUT_CTNS_MAX IN NUMBER,
in_UNITS_PER_CARTON IN NUMBER,
in_OHB_INPUT_UNIT_CONSTANT IN NUMBER,
in_TOTAL_CARTONS IN NUMBER,
out_ALLOW_OHB_INPUT_FLAG OUT CHAR,
out_ERR_CODE OUT NUMBER,
out_ERR_MESSAGE OUT VARCHAR2)
When the stored procedure is executed it is throwing following exception OTHERS EXCEPTION in XCOM_X060_UPDATEOHBFAILURE - SQL -1001 SQLERRM: ORA-01001: invalid cursor
Here is the execution script
DECLARE
IN_CALL_ID NUMBER;
IN_SPLY_REORD_NO VARCHAR2(32767);
IN_OHB_QTY_CARTONS NUMBER;
IN_OHB_QTY_UNITS NUMBER;
IN_SPLY_TOT_OHB_QTY NUMBER;
IN_OHB_INPUT_CTNS_MIN NUMBER;
[code]...
There is no cursor used in the procedure. It just inserts records in the table for given input values.
I am writing a cursor and inside that cursor I am checking record exists or not and based on that I am doing my operation.But I am getting error that i can not use exception inside cursor see the below sample code (syntax may not be correct)
sample code------------------
cur c1
is select * from T1;
open c1
loop
fetch c1 into cur_id;
select name into var_name from t2 where id = cur_id;
exception
when no_data_found then
continue with next cursor value
end
update t3 set name = var_name where t3.id = cur_id;
commit;
end loop;
end;
create or replace procedure upd(name in varchar2) is
cnumber number;
cursor c1(name in varchar2) is select sid from student where sname=name;
begin
open c1(name);
[code]....
it has no errors . .. . but when i try to execute it is displaying as cursor hanged . . .
I have the following code for a Apex(Application Express) project I am developing.
declare
mail_id varchar2(100);
min_skill_cnt number;
skill_cde varchar2(30);
total_leave number;
toal_emp number;
cursor cur is
select S_EMP_EMAIL
from EMP_SKILLS_INFO where SKILLCODE='MGR' and S_EMP_EMAIL = lower(:APP_USER) ;
cursor minskill is
select skill_code,MINRQMT_AM
from skills_code_info
where skill_code in (select skillcode from emp_skills_info where S_EMP_EMAIL = lower(:APP_USER));
cursor leavecnt(v_skill IN VARCHAR2) is
select count(*) from emp_leave_info
where leave_date = :P24_LEAVE_DATE
and emp_email IN (select S_EMP_EMAIL from EMP_SKILLS_INFO where SKILLCODE = v_skill);
cursor empcnt(v_skills IN VARCHAR2) is
[code]...
Ideally this should send email to managers when a particular skill is running short when employee applies for leave. I am getting error that cursor is already open when I run this code. I am not sure which cursor or where it is picking open cursor command.
I am using windows 7 and running report from report builder 6i. I got this message error report builder has stopped working. And when i press on show problem details i got this info
Problem signature:
Problem Event Name:APPCRASH
Application Name:RWBLD60.EXE
Application Version:3.0.0.0
Application Timestamp:39c93f24
Fault Module Name:UIW60.DLL
[code].......
Read our privacy statement online:
[URL]........
If the online privacy statement is not available, please read our privacy statement offline:
C:Windowssystem32en-USerofflps.txt
My cursor went to the exception when its got the error " ORA-01403: no data found"
But my cursor need to run even though it got the error " ORA-01403: no data found"...This is my exception part
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (c1rec);
DBMS_OUTPUT.put_line (SQLCODE);
DBMS_OUTPUT.put_line (SQLERRM);
-- RETURN NULL;
-- code change added as part of GCA642 -- END
END get_geo_test1;
I want to pass a damn long query(which includes a lot of column names, tables, joins, union, where clauses etc. and whose length is more than 120000) in a Ref cursor (that's length is more than 32767). Query is stored in a LONG type variable V_QRY in stored procedure, and I am opening that ref cursor like below-
OPEN P_RPT_TEST FOR V_QRY;
at run time its giveing string buffer too small error.
While reading data from collection variable using ref cursor . I am getting the below two errors.
PLS-00382:Expression is of wrong type
ORA-22905 Cannot access rows from a non-nested table item.
CREATE OR REPLACE PACKAGE APPS_GLOBAL.GIIOMEGAORDERLIST
AS
TYPE BU_LIST_TYPE IS TABLE OF VARCHAR(50);
TYPE OFFER_DETAIL IS RECORD
(
GII_BU VARCHAR(50),
GII_OFFER NUMBER,
[code]........
I have one table employer. It has column loginid, password, address, regdate, fullname, identno.
So i want to clear all data before 1 June 2011 in regdate. What command i need to use? I quite new with command prompt.
In a master and detail relation ship block..When a cursor is placed in the details and enter some thing and giving back space..once value is cleared a empty record is saved in the database with the header values , but in details customer didn't enter anything.
how to clear the detail record in pre insert or when validation ?
I Require to Fetch the Group of Value in Item Block Selected through the User Selected LOV Value in Master.
Through Loop i Fetch the Records in Item Block.
When User Change the Selected LOV Value Require to Clear the Item Block.
BEGIN
FOR NRM IN (SELECT MTRLTYPE,STATUS,
MTRL_NO,MTRL_ID FROM JAWOADMIN)
LOOP
GO_BLOCK('NRMTRL_ITEM');
:NRMTRL_ITEM.NRMTRL_TYPE := NRM.MTRLTYPE;
:NRMTRL_ITEM.REMARKS := NRM.STATUS;
:NRMTRL_ITEM.NRMTRLREF_NO := NRM.MTRL_NO;
:NRMTRL_ITEM.NRMTRLREF_ID := NRM.MTRL_ID;
NEXT_RECORD;
END LOOP;
END;
How to Clear the Block before the above loop.
i got many audit file in a dump it is on hp-ux linux normally in linux i use to give
find -name "*.aud" -mtime +20 -exec rm {} ;
what to give in HP-UX linux ?
i have 4 blocks in one form.my requirement is this that can i user the clear_block or any other built-in for clear the specific block....
View 2 Replies View Relatedi have created form with table page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use
LOV FORP1_MON STATIC2:;1 MONDAYP1_TUE STATIC2:;2 TUESDAYP1_WED STATIC2:;3 WEDNESDAYP1_THR STATIC2:;4 THURSDAYP1_FRI STATIC2:;5 FRIDAYP1_SAT STATIC2:;6 SATURDAYP1_SUN STATIC2:;7 SUNDAY
i have one more column operating days where i have use computaation to keep operating days.
:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN
these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute) Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor.
I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.
how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.
When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.
What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.
I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.
I have a problem in my form. In my form there are 4 blocks and in one of the block i have a button. In which i put a code same as below:
BEGIN
IF NAME_IN('SYSTEM.FORM_STATUS') = 'CHANGED'
THEN
CLEAR_FORM(NO_VALIDATE);
END IF;
PROCEDURE ABC;
END;
So as per code i want to clear all the changes in form for current session and want to call the procedure ABC after that. But it is not calling the procedure ABC. And what would i do to perform the same?
I like to create an expdp parfile that would not expose my password in clear text.
PARFILE:userid=MyAccountName/$MYPASSWORD <-----this substitution does not work in a parfiledumpfile=xxxxxlogfile=xxxxtables=xxxx
I am working on form builder 6i.I have FIND widnows and MAIN window.
FIND Window: contains field1 and field2, FIND Button.
block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.
If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.
:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2
In Block B--> When-New-Block-instance(Block Level)
select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;
and populating data in block B.It's working fine.
REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)
CLEAR_BLOCK('NO_VALIDATE');
But it's not working.In which trigger i have to write code to clear block.
I am working in form 6i, EBS 11i. I have below requirement to achieve.
I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.
i am testing a proc after tuning it but the problem is, it is taking a very very less time which it shouldn't. I know that it is because of the buffer cache and the shared pool. that why i need to clean the cache to retest it.
I cannot bounce the database as other schemas are part of it. so is there any way to clean the cache for that particular schema i.e bouncing any particular schema(i know that the term is not appropriate).
APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.
View 2 Replies View RelatedI found there is clear password in the xml file in the process of Oracle instance creating. The process like below
1, when using the following process to create the instance
Login as user Oracle
/home/Oracle11home/bin/dbca -createDatabase -silent -templateName /home/Oracle11home/assistants/dbca/templates/Small.dbt -gdbName testDB -sid testSID -sysPassword [b]testpwd[/b] -systemPassword [b]testpwd[/b]
2. Found the file in $ORACLE_HOME/checkpoints/dbca/OraDb11g_home2_oracle_creation_checkpoint.xml , it listed the sys and system passwd (like testpwd for sys and system password) directly.
<CHECKPOINT LEVEL="MAJOR" NAME="db_oracle" DESC="db creation checkpoint" STATE="FAIL">
<PROPERTY_LIST>
<PROPERTY NAME="command" TYPE="STRING" VAL=" -silent -createDatabase -templateName Small.dbt -gdbName testDB -sid testpwd -sysPassword testpwd -systemPassword testpwd"/>
</PROPERTY_LIST>
</CHECKPOINT>
I hope to confirm :
1. what is the purpose for oracle to genate the checkpoint.
2, can we remove the file safely ?
3, if there is configuration that we can avoid to show clear password in checkpoint file?