Forum Stats

  • 3,816,037 Users
  • 2,259,133 Discussions
  • 7,893,366 Comments

Discussions

Trouble: Insufficient Privileges executing stored procedure in a package

752032
752032 Member Posts: 26
edited Feb 10, 2010 11:50AM in ODP.NET
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
Tagged:

Best Answer

  • gdarling - oracle
    gdarling - oracle Member Posts: 2,034
    This behavior is likely unrelated to ODP and will happen when you execute the same procedure as the same user from SQLPlus directly for example, so the PLSQL forum is probably a more appropriate place for assistance.

    What is "KIKO.PACK_SP", line 205? Roles are disabled inside stored procedures so you need to have permissions granted directly.

    Hope it helps,
    Greg

Answers

  • gdarling - oracle
    gdarling - oracle Member Posts: 2,034
    This behavior is likely unrelated to ODP and will happen when you execute the same procedure as the same user from SQLPlus directly for example, so the PLSQL forum is probably a more appropriate place for assistance.

    What is "KIKO.PACK_SP", line 205? Roles are disabled inside stored procedures so you need to have permissions granted directly.

    Hope it helps,
    Greg
This discussion has been closed.