function erroring and reporting wrong name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » function erroring and reporting wrong name

function erroring and reporting wrong name

Rate Topic

Display Mode

Topic Options

Author

Message

block 5753

Posted Wednesday, January 16, 2013 6:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:31 PM
Points: 4, Visits: 23

Hi All,

I have a weird one for you that I was hoping to get some help with.

I created and deleted a few functions.

Then I created a new one (Called RAT)

When I call it with SELECT dbo.rat(@param,@param) it comes back with a

"Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous."

Now, there used to be a function called RCHARINDEX, but its gone, and it doesnt come up in the list of functions.....

I deleted it because for some reason I couldnt call it, but another function in the list worked fine, so its possibly a compounded problem,

When I run

select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]')
select 1 from dbo.sysobjects where id = object_id('[dbo].[RCHARINDEX]')

I get a hit on the first one, but not on the second one.

I did drop the functions using the command:

Use Master
go
IF EXISTS (select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]') )
DROP FUNCTION [dbo].[RAT]

Any suggestions?

Regards

Post #1408115

block 5753

Posted Wednesday, January 16, 2013 7:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:31 PM
Points: 4, Visits: 23

As a bit of additional info, intellisense picks up the function correctly.

But still getting:

select dbo.RAT(' ',' hey there dudes',1)
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous.

Post #1408123

demonfox

Posted Wednesday, January 16, 2013 10:41 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

block 5753 (1/16/2013)

you are not calling function "dbo.RCHARINDEX" from the dbo.RAT function ??
can you post the text ?

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1408149

block 5753

Posted Sunday, January 20, 2013 2:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:31 PM
Points: 4, Visits: 23

Hi There,

Yes I am very stupid.

That's what you get for using someone else's libraries :)

The RAT function called the RCHARINDEX inside it, and I missed the call when I was looking through the source.

So, I decided to re-write the function, and as I was doing do, I found the reference, and before I could log on you asked the question!

Thanks for you response.

Sorry to waste your time.

Regards

Post #1409307

« Prev Topic | Next Topic »

Permissions