473,324 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

PLS-00201 Error

Hi,

I am getting the following error :-
----------------------------------------------------------
PLS-00201: identifier '<schema>.ABC_DROP_INDEX_PRC' must be declared
----------------------------------------------------------
Can anyone guide me on resolving this issue??

Thanks.
Mar 27 '07 #1
6 1307
MMcCarthy
14,534 Expert Mod 8TB
I'm guessing this question belongs in the SQL Server forum. If not the moderators will move it to a more appropriate forum.

ADMIN
Mar 27 '07 #2
iburyak
1,017 Expert 512MB
I need more info on it. What did you do? What statement was executed when you recieved this error? Which program and as much as possible.


Thank you.
Mar 27 '07 #3
iburyak
1,017 Expert 512MB
It looks like it is an Oracle error involved right limitations.
Mar 27 '07 #4
MMcCarthy
14,534 Expert Mod 8TB
It looks like it is an Oracle error involved right limitations.
Send me a PM if you need it moved again.
Mar 27 '07 #5
iburyak
1,017 Expert 512MB
Let's see his respond first.
Sometimes they never come back to view respond at all .... :)
Mar 27 '07 #6
Hi,
Thanks to all for the suggestions provided, specially the last one!!
Wel, the answers was needed a little bit urgently and so i thought that i could get a reply from this forum.
I was able to fix the problem occuring. As stated earlier, it was a problem related to the access only...
"The rules for accessing other users objects are different when COMPILING
procedures/functions/packages.
Grants must be given directly, not through a role, to the compiling
usercode
(DBA is a role).
Normal rules apply when executing"
.....
So i had to Grant privileges to one of the access_role to be able to execute procedure so it should work now.
--------
Thanks anyways.
Mar 28 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Michael Hogan | last post by:
I want to pars a playlist file for three different varibles, so I can save them as mp3 files. I am using: strTEMPURL = GetUrlSource(Text1.Text) to put the entire .pls file into a strTEMPURL...
6
by: ritagoldman101 | last post by:
Pls help - how to find Domain owner For most people this may be an easy question...but not for me. How can I find out who the owner of a domain is so I can write to her / him and ask if she /...
0
by: RamaKrishna | last post by:
Hi All: When am trying to call a .NET webservice which was developed using .NET V 1.1 from VB6.0 using SOAP tool kit3.0......It can be any function/ method in the webservice..Bec'z lets say i...
8
by: Raghu Raman | last post by:
Hi , i want to compile my asp.net app from the commandline window.could you please tell me how. With thanks Drop in the ocean.
2
by: Raghu Raman | last post by:
Hi , am storing the session id in my database when the user signs in.The session_on start is firing nice & am doing my DB operations there & quite working good. But when the user closes the...
20
by: Dj_TRuST | last post by:
This is my homework and i couldn't do it,please help me. I wait your helpsss On the planet Zephod, which orbits the star Betelgeuse, the sharks increase at a rate of 5% of the guppy population...
3
by: bangaw | last post by:
i'm currently using c++ on windowsXP, unistd.h doesnt work for windows what other substitute for it could i use to replace it Pls. Help me Pls pls the code goes as follows #include <stdio.h>...
0
by: naheed javaid | last post by:
I m student and doing my final project. My project is related to screen capturing. my project captures screen and save the captured screen as bitmaps in a folder. while the screen recording audio...
1
by: vbsoft | last post by:
Hello My Name is Mike Am from Nigeria a student of computer Science, Pls i want your You to help in Using VISUAL BASIC 6.0 AND MS SQL SERVER AS DATABASE AS A CLIENT SERVER SIDE pLS: I...
0
by: sonuindia88 | last post by:
Some common confusions .I am reading Ritchie and Deitel and practising questions from Yashwant Kanetkar...Here are some of the confusions i am having..your help is required.... Q1) ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.