amoldiego
Last Activity: Aug 23 '07, 11:14 AM
Joined: Jun 12 '07
Location:
-
Thanks buddy .... thanks for ur help ... -
Tablespace error:ORA-01536
Hi
I have encountered the error ORA-01536 .
I have earlier grant sysdba to SCOTT &
then I revoked the sysdba role from SCOTT a couple of days later. After that, I encountered the error ORA-01536 when trying to create a table as SCOTT
My question is once the dba role has been assigned then revoke, will it affect the quota assigned? I have no clue what caused the error ORA-01536 .
Also... -
I have tried both posibilities ie commit inside the loop and outside the loop ..
I have one table emptest with 8214 rows...
i ve created one cursor for update sal of emptest and place commit inside the loop ..
declare
cursor c1 is select empno from emptest ;
begin
for r1 in c1
loop
update emptest set sal =5000 where empno=r1.empno and rownum<=200;
commit;...Leave a comment:
-
Thanks for Ur reply ...
Could u plz tell me how it will improve the performance if i palce commit inside the loop ..
ThanksLeave a comment:
-
Commit outside the cursor
Suppose I create one for loop for update statement . That updates arround 1000 rows .
So please tell me where i should place commit .
Inside the loop or outside the loop .
and how that improve the performance.
Please reply -
diff between ref cursor and cursor
Please tell me diff between ref cursor and cursor with examples
Thanks -
ya ur correct ..thanks ...actually there is mismatch between IN parameter ...Leave a comment:
-
ORA-06502: PL/SQL: numeric or value error
Hi ,
I created one procedure ...When i called that procedure ..I get ORA-06502: PL/SQL: numeric or value error error...
All the in parameter and there datatype passed are correct ,,,,still I got this (ORA-06502: PL/SQL: numeric or value error) error.
I am using ORACLE 8i ...could u plz tell me why this error has occured. -
deadlock situation
Hi,
I am updating same row of the Same Table in 2 diff session, i.e, for deadlock situation
In 1st session
declare
a number(5) := 123;
begin
update ba_bank_mast set COD_BANK=a;
end;
/
In 2nd Session
declare
a number(5) := 456;
Deadlock_detect ed Exception;
Pragma Exception_init( Deadlock_detect ed, -60);
begin
... -
Thanks buddy ... thanks for ur help.Leave a comment:
-
Thanks .... how overloading has advantage for Version management....Leave a comment:
-
Advantages of function overloading
Could you please tell practicle advantages of function overloading. -
That anonymous block i want ..cud u plz send it for given package .Leave a comment:
-
Thanks for the answer ... But cud u plz tell me how to execute the given package ....I created Ref cusor type inside the package...
How to open that ref cursor inside the calling procedure ......
plz helpLeave a comment:
-
how to execute package
Dear all,
1)
I have created package ref test for declaring ref cursor as shown .....
create or replace package ref_test as
type empty is ref cursor;
end;
2)
created package ref_use and used the reference of that ref cursor .....
create or replace package ref_use as
procedure ref_pro (p_empno number,P_result out ref_test.empty) ;
end;
... -
Blob
Hi,
Could u please send information about BLOB datatype. I searched in Google but couldnot able to find out what i required.
Please send some coding related to BLOB datatype means from starting(create directory onwards)...
Also mentioned how to handle BLOB ...how to insert in BLOB datatype
What is DBMS_LOB.INSTR ,DBMS_LOB.READ
Thanks .Leave a comment:
-
Thanks buddy ...Thanks for ur helpLeave a comment:
-
Oracle spatial
Hi ,
Could u please send me pdf or doccument related to oracle spatial. -
Blob
Hi,
Could u please send information about BLOB datatype. I searched in Google but couldnot able to find out what i required.
Please send some coding related to BLOB datatype means from starting(create directory onwards)...
Also mentioned how to handle BLOB ...how to insert in BLOB datatype
What is DBMS_LOB.INSTR ,DBMS_LOB.READ
Thanks . -
EXISTS is More faster than In OperatorLeave a comment:
No activity results to display
Leave a comment: