 Related Questions How to run a curser for update "with hold2 in PL/SQL ?Example:declarecursor CSRtest is select * from emp for update of lastname;beginfor i in CSRtest loop...do something...call procfedure with "commit"update emp set lastname = "..." where current of CSRtest;endloop;Results in "ORA-01002: fetch out of sequence" because curser is closed after "Commit"How to "save state of curser" ?Any workaround? Read Answers (1) | Asked by : Stefan we have a PRIMARYKEY field with auto generation in sequence of a table of records. If we delete any one of records from the table, how can we update the table implicitly using Trigger? Latest Answer : which table u want to update ,in case if it is the same table then write after delete trigger on the table and select values from destination table. ... Read Answers (1) | Asked by : Pranab Jyoti Deka Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode Latest Answer : I checked the code it's working fine. ... When we insert new values into the table using loops. Is it going to be auto commit or do we need to commit manually? Latest Answer : All the DML statement requires manual commit where as DDL statements are autocommitted. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
