I am trying to call a package within an oracle database from vb.net
The code I am using is
Dim userID As New OracleParameter("vELINK_USER_ID", OracleType.Number)
userID.Value = "20092"
Dim objectID As New OracleParameter("vOBJECT_TYPE_ID", OracleType.Number)
Dim resetsync As New OracleCommand
.Connection = sqlconn
.CommandText = "PKG_SYNCHRONIZATION.SP_RESTUSER"
.CommandType = CommandType.StoredProcedure
sqlconn.ConnectionString = connstr
Catch ex As Exception
However I get the following error
ORA-06550: line 1, column 27:
PLS-00302: component 'SP_RESTUSER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
The package within Oracle is as follows
/* Removes users sync log records to allow reset and re-sync of all records,
if passed an object type then only that type gets reset */
vOBJECT_TYPE_ID NUMBER DEFAULT NULL)
WHERE ELINK_USER_ID = vELINK_USER_ID AND
(vOBJECT_TYPE_ID IS NULL OR SYNC_OBJECT_TYPE_ID =vOBJECT_TYPE_ID);
the user does have permission to execute commands so do not believe this to be the issue and would be grateful for any help that could get me around this issue.