For ex:-
CREATE OR REPLACE FUNCTION PROC1
(Num IN NUMBER)
RETURN NUMBER
IS
BEGIN
INSERT INTO Table1 SELECT * FROM SCOTT.Table2 WHERE ID = Num;
END;
PL/SQL: ORA-00942: table or view does not exist
SQL> select * from table1;
select * from table1
*
ERROR at line 1:
ORA-00942: table or view does not exist
1. The table name or view name spelled wrongly
2. The table or view doesn’t exist
3. The user doesn’t have required permissions
In some cases users have select access and able to query data but when running from a procedure they still receive “ORA-00942: table or view does not exist”
The reason for this error is the access granted trough a ROLE not directly. In order to access another user table from a procedure you need to have SELECT privilege granted directly.
The reason for this error is the access granted trough a ROLE not directly. In order to access another user table from a procedure you need to have SELECT privilege granted directly.
Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
ReplyDeleteHire Best Packers And Movers Mumbai for hassle-free Household Shifting, ***Office Relocation, ###Car Transporation, Loading Unloading, packing Unpacking at affordable Price Quotation. Top Rated, Safe and Secure Service Providers who can help you with 24x7 and make sure a Untroubled Relocation Services at Cheapest/Lowest Rate @ Packers And Movers Mumbai
ReplyDeleteOur client can choose any of them as per their convenient. We are also open to send our angels any other place of your choice. Escorts Service in Gurgaonare waiting eagerly to meet you. You need to decide whether you want to meet them at home or at any hotel. If you are facing any challenges in arranging any place, let me inform you that we have tie-ups with 3 start hotels as well as 5 start hotels. Check our other services...
Russian Escorts in Faridabad
Call Girls in Gurgaon
Female Escorts in Gurgaon
Russian Escorts in Gurgaon
Packers and Movers Pune Provide High Quality ***Household Shifting, Home/Office Relocation, Insurance, Packing, Loading, ###Car Transportation Service Pune and High experiences, Top Rated, Safe and Reliable, Best and Secure Packers and Movers Pune Team List. Get ✔✔✔Affordable Rate Charts and Compare Quotation and Save Money and Time @ Packers And Movers Pune
ReplyDeletePackers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
ReplyDeleteLocal Packers And Movers Bangalore
Hi! Nice blog. We are also offering Quickbooks Payroll Support. If you need any help regarding QuickBooks issues, dial (877) 606-0004 for instant help.
ReplyDeletePackers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai
ReplyDeleteGet Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔✔✔Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur
ReplyDeleteThanks for sharing! It's really helpful to me. I will follow and support you. word unscrambler
ReplyDeleteDolby Atmos Crack uses the long-standing surround sound home theater concept, but adds additional height channels to create an enveloping sound effect in your room.
ReplyDeleteAlien Skin Blow Up Crack
Adobe Indesign CC Crack
Bittorrent Pro Crack
I believe the things you whatever you have enclosed, all the way throughout the post are peaceful striking, good job and great hard work. I found it very striking and enjoyed reading all of it...stay it up, good-looking job. Thanks. andrey belyakov
ReplyDeleteDoes the architect mean to utilize experts for this task and provided that this is true, how are they paid? I want to start a credit card processing company
ReplyDeleteI am incapable of reading articles online very often, but I’m happy I did today. It is very well written, and your points are well-expressed. I request you warmly, please, don’t ever stop writing. North American Bancard Agent Program
ReplyDeleteI think this is often associated with informative and knowledgeable posts. However, I prefer to thank you for the efforts you have created in penning this blog. Visit here: SEO Company.
ReplyDeleteJKBOSE 9th class Model Paper 2023 JKBOSE 9th Previous Question Paper 2023 JLBOSE 2023 9th class Model Paper 2023 according to Syllabus declared, JKBOSE 9th class Model Paper 2023, JKBOSE 9th class Question Paper 2023, J&K 9th Question Paper 2023 JKBOSE 9th Previous Question Paper 2023, JKBOSE 10class 2023 Model Question Paper 2023, Jammu Kashmir 9th class Model Paper 2023, Jammu Kashmir 9th Previous Question Paper 2023, J&K 9th Previous Question Paper 2023, Annual Regular 2023 Summer Zone Jammu Division Class 9th Model Question Paper 2023, JKBOSE 9th class Model Paper 2023
ReplyDelete