Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how to use l_instance in the host command||7||36|
|Populate textboxes based on selected 2nd combobox from selected 1st combobox Using VB.net and SQL Server table||8||46|
|Automate an Oracle update in Excel||7||70|
|RMAN-06100 when restoring backupset||4||10|
Join the community of 500,000 technology professionals and ask your questions.