created stored procedure cannot be found

[jamert]

Hi I created a simple Proc called "feedback"

i cannot find the procedure? I've looked in the master as well teh db that i created it in. I have refreshed the db to no avail, plus when i try to create a new one with the same name i'm informed that one already exists. I feel dumb, any suggestions

 

[gmmastros]

Run this and post the results back here.

Select name, xtype From sysobjects Where Name = 'feedback'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[jamert]

no results to post when i ran it, is feedback a reserved procedure? could i have overwritten something by creating it?

 

[jamert]

ok i rebooted the server, and rand the procedure again. i got a reult this time 9i'll need to look into the server log for issues...) this is the result i recieved:


thanks George, what is type U ?

feedback
U

 

[jamert]

OK, i have a bigger issues with the server, thanks for you help.

 

[gmmastros]

U = User Table

Complete list here:

http://www.devx.com/tips/Tip/14107

You apparently have a table named Feedback. As such, you cannot have a stored procedure named feedback.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ESquared]

If you couldn't query it, that probably means you had a schema lock on the table and couldn't get information about it out of the system tables due to blocking. Stopping and restarting the server probably fixed it because that would close any open connections and queries, and also roll back any outstanding transactions, releasing all locks.

You may not have a server problem after all.