Topic: SQL*Plus and PL/SQL >> triggers and procedures and functions and packages
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: triggers and procedures and functions and packages |
| maneesh |
Posted: Aug 13, 2007 08:57:55 AM |
Total Post: 13
Joined: Aug, 2007
|
hi all
i am posting some questions plz give the ans somebody knows any one of them
1. schema A has some objects and created one procedure and granted to schema B, schema B has the same objects like A . schema B executed the procedure like inserting some records. in this case where the data will be stored whether in schema A or schema B?
2. can we create procedure procedure to fetch more than one record?
3. in exception handeling we hav not_found and others. in inner layer we have some not_found and others. while executing which one whether outer layer or inner layer will check first?
4. suppose while executing procedure or functions power gets failure or other problem occures and proc or function is not completely run. then what will happen with the dml operations that hav been done by the proc or function.
will the dml operation be committed and remain in the database or they are in the database and can be rolled back or committed or they r automatically rolled back.
|
|
|
 Nehru |
| Posted: Aug 14, 2007 12:29:42 AM |  |
|
Total Post: 45
Joined: Jul, 2007
|
Hi Maneesh,
I am trying to solve your questions,
1.what ever records are inserted by schema B are stored in schemaB itself
2.ya,you can get more than one record from procedure by using CURSORS & RefCursors
3.I think exception handling goes from inner layer to outer layer.so,first inner layer next outer layer.
4.While executing DML stmts if power gets failure or other problem occures then they are Not Saved
Any one Let me know if am wrong.
Take Care,
Thanks & Regerds,
Nehru
|
|
|
|
|
| maneesh |
| Posted: Aug 14, 2007 07:26:22 AM | |
|
Total Post: 13
Joined: Aug, 2007
|
hi nehru
thanx for valuable answers
thanx & regards
maneesh
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 21, 2007 12:42:02 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
yes Nehru, you right.. When ever power goes or any such things happen, database will be rolled back to last commit point
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
