Friday, February 10, 2012

Calling user defined function from stored procedure

When i call user defined function from stored procedure, i am getting an error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.MyFunction'.

why this error is happening?.

i am calling this way... dbo.MyFunction(param1,param2)

Can you give the full statement? This still does not look like enough information.

|||My first guess would be that your funciton is not residing in the same database as the stored procedure.

No comments:

Post a Comment