Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

ERROR on execute stored procedure


Pablo Rabago

Recommended Posts

Hi all.

when I try to run an SP (Stored procedure) through a SQL Statement based on data base from iProcess always get the same runtime error message:

 

SQL Statement:

GO

DECLARE @return_value int

EXEC @return_value = [swpro].[sw_jumpto_multi] @proc_name = N'PRC05G', @proc_maj_ver = -1, @proc_min_ver = -1, @withdraw_step = N'SBFASE01', @step_name = N'SETSUBF1', @case_num = 712, @reason = N'Salto', @user_id = N'swadmin'

SELECT 'Return Value' = @return_value

GO

 

Result:

 

Mens 229, Nivel 14, Estado 5, Procedimiento sp_OACreate, Lnea 1The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.Mens 50000, Nivel 16, Estado 1, Procedimiento sw_get_sequence_trans, Lnea 57(SWERROR) Unable to create DMO connection, check user is system administrator (ID:001001)

 

Any suggestion

 

Thanks in advance.

Link to comment
Share on other sites

  • 10 years later...

Hello,Please can yopu explain how di you resolved "The EXECUTE permission was denied on the object" error I trye to give permission like belowuse [master]

GO

GRANT EXECUTE ON [dbo].[XXXXX] TO [userYY] Bu nothing changed.Also try to resolve by create a new database role like it explained on this post but the same error.Thnx

Link to comment
Share on other sites

×
×
  • Create New...