Try
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
With resetsync
.Connection = sqlconn
.CommandText = "PKG_SYNCHRONIZATION.SP_RESTUSER"
.CommandType = CommandType.StoredProcedure
.Parameters.Add(userID)
End With
sqlconn.ConnectionString = connstr
sqlconn.Open()
resetsync.ExecuteNonQuery()
sqlconn.Close()
Catch ex As Exception
sqlconn.Close()
MsgBox(ex.ToString)
End Try
ORA-06550: line 1, column 27:
PLS-00302: component 'SP_RESTUSER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
/* 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 */
PROCEDURE SP_RESETUSER(
vELINK_USER_ID NUMBER,
vOBJECT_TYPE_ID NUMBER DEFAULT NULL)
AS
BEGIN
DELETE MOBILE_SYNC_LOG
WHERE ELINK_USER_ID = vELINK_USER_ID AND
(vOBJECT_TYPE_ID IS NULL OR SYNC_OBJECT_TYPE_ID =vOBJECT_TYPE_ID);
END SP_RESETUSER;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
.CommandText = "PKG_SYNCHRONIZATION.SP_RE
Cheers,
Hades666