Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trouble: Insufficient Privileges executing stored procedure in a package

752032Feb 8 2010 — edited Feb 10 2010
I'm using Visual Studio 2008 Team Suite, ODT with ODAC 111.07.20 and I'm trying to execute a stored procedure inside a package, it shows the following error message:

Oracle.DataAccess.Client.OracleException: ORA-01031: insufficient privileges
ORA-06512: at "KIKO.PACK_SP", line 205
ORA-06512: at line 1
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at SqlOracleWebService.OracleReplicationTool.GetData(String strNameServer, String strNameDatabase, String strNameTable, String strNameStoreProcedure, String strUserId, String strPassword, Int64 intSince, Int64 intUntil, Int32 intPort, String strID) in C:\Documents and Settings\kiko\Desktop\kiko\SQL-ORACLE\SqlOracleWebService\SqlOracleWebService\Oracle\OracleReplicationTool.vb:line 1171
at SqlOracleWebService.OracleReplicationTool.SmallDataInit(String strNameServerSource, String strNameDatabaseSource, String strNameServerDestiny, String strNameDatabaseDestiny, String strNameTable, String strUserIdSource, String strPasswordSource, String strUserIdDestiny, String strPasswordDestiny, Int32 intPortSource, Int32 intPortDestiny) in C:\Documents and Settings\kiko\Desktop\kiko\SQL-ORACLE\SqlOracleWebService\SqlOracleWebService\Oracle\OracleReplicationTool.vb:line 614
at SqlOracleWebService.OracleReplicationTool.ReplicationDataInit(Boolean boolBothDirections, String strNameServerSource, String strNameDatabaseSource, String strNameServerDestiny, String strNameDatabaseDestiny, String strNameTable, String strUserIdSource, String strPasswordSource, String strUserIdDestiny, String strPasswordDestiny, Int32 intPortSource, Int32 intPortDestiny) in C:\Documents and Settings\kiko\Desktop\kiko\SQL-ORACLE\SqlOracleWebService\SqlOracleWebService\Oracle\OracleReplicationTool.vb:line 28
at SqlOracleWebService.Service1.Oracle_ReplicationDataInit(Boolean boolBothDirections, String strNameServerSource, String strNameDatabaseSource, String strNameServerDestiny, String strNameDatabaseDestiny, String strNameTable, String strUserIdSource, String strPasswordSource, String strUserIdDestiny, String strPasswordDestiny, Int32 intPortSource, Int32 intPortDestiny) in C:\Documents and Settings\kiko\Desktop\kiko\SQL-ORACLE\SqlOracleWebService\SqlOracleWebService\Service1.asmx.vb:line 20

I've change the execute privileges and granted to user KIKO the execute to the package PACK_SP, but it doesn't work. Could you help me?

Thanx in advance.

Edited by: user9112176 on Feb 8, 2010 10:27 AM
This post has been answered by gdarling - oracle on Feb 10 2010
Jump to Answer

Comments

Mehmet Sevinc
Can you check if the metadata is updated?
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2010
Added on Feb 8 2010
1 comment
2,765 views