How to debug a procedure in SQL Prompt
Latest Answer: You can debug the procedure. Oracle gives a util programme DBMS_DEBUG by which you can debug a procedure.the full detail you can see at http://www.oracleutilities.com/wiki/index.php?title=Dbms_debugand also you can find out the good material athttp://www.unix.org.ua/orelly/oracle/prog2/ch26_01.htmplsss ...
Latest Answer: autonomous transaction are independent transaction exCREATE OR REPLACE PROCEDURE a1ASPRAGMA AUTONOMOUS_TRANSACTION; BEGININSERT INTO table1 VALUES('autonomous transaction');COMMIT; END;DECLAREa NUMBER:=1;BEGININSERT INTO table1('a');proc_a;ROLLBACKEND;after ...
While i compiled my code , it got compiled but while running my application i got the Oracle error "Could not find the Program unit ? "Can any one tell exactly why this happens.I had validated
Latest Answer: This error can occur in the following scenario also. The application has a constant connection with the database and a package which the application uses gets recompiled. And the recompiled package contains package variables. Solution :- Restart the application ...
Latest Answer: Yes thats true...It will be private. ...
Latest Answer: Pragma is a compiler directive. It passes information to compiler. These are processed at compile time not at runtime. Types of PRAGMA1.AUTONOMOUS_TRANSACTION2.EXCEPTION_INIT3.RESTRICT_REFERENCES ...
Latest Answer: ORA - 01426 is associated with Numeric overflow Cause : Evalution of an value expression causes an overflow or underflow.Action : Reduce the operand ...
Latest Answer: This will delete Collection (eg index by table ) in the range 6,3 ...
Latest Answer: A collection can be loosely defined as a group of ordered elements, all of the same type that allows programmatic access to its elements through an index. Commonly used collection types used in the programming world include arrays, maps, and lists. Probably ...
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. ...
Latest Answer: Collection is an ordered group of elements all are of same time. Each element in the collection has unique subscript to identify its position in the collection.Pl/sql offers three collection types.1. Nested table2. Varray3. Index by table Use collection ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
