| Objective Question reg autonomous transaction [message #169321] |
Wed, 26 April 2006 04:55 |
ssrividhya
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
User MILTON issues the following code block in his SQL*Plus session:
CREATE OR REPLACE PROCEDURE upd_tran
( PVAL1 IN VARCHAR2) IS
PRAGMA AUTONOMOUS_TRANSACTION;
MY_VAL2 NUMBER(10);
BEGIN
SELECT COL_1 INTO MY_VAL2
FROM TAB_2 WHERE COL_2 = PVAL1;
UPDATE TAB_1 SET COL_1 = PVAL1
WHERE COL_2 = PVAL2;
COMMIT;
END;
Later, another procedure called my_tran( ) is defined by user GOETHE,
which calls upd_tran( ) as part of an application. Which of the following
statements is true about this application?
A. Any transaction in progress in my_tran( ) when upd_tran( ) is
called will be committed when upd_tran( ) completes.
B. Any uncommitted changes made to table TAB_2 by my_tran( ) will
not be seen by upd_tran( ).
C. Procedure upd_tran( ) has no problem updating TAB_1 if my_tran(
) has already done so without issuing a commit
before the call to upd_tran( ).
D. User GOETHE needs to have update privileges on TAB_1 to execute procedure upd_tran( ).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
