Hi David,
Please check the following 2 items to resolve the error you are getting calling your custom stored procedure on checkout:
1. Store Procedure Naming Convention - It is important that your stored procedure is named correctly as follows:
DatabaseOwner + ObjectQualifier + ModuleQualifier in front of your stored procedure.
-
DatabaseOwner is usually “dbo”
-
ObjectQualifier – Is assigned when you installed DNN. The objectqualifier in your database could be "dnn" or you may not be using one. If you are not sure you can check by logging into your database using SSMS.
-
ModuleQualifier is “Smith”
For example, a stored procedure titled “TransferOrder” should be named as follows if your objectqualifier is "dnn" :
“dbo.dnn_Smith_ TransferOrder”
2. Parameters Passed To Stored Procedure
The following two parameters are passed to your custom stored procedure on checkout complete:
OrderID (String) – SmithCart order id generated for the new order.
SCData (String) – Custom parameter that passes the value of a session variable (SCData) to your stored procedure when checkout is complete. The "SCData" parameter allows the cart to integrate with another Asp.Net application or other modules in your portal. Note: SmithCart does not populate the SCData session object, it is only populated by another application or module on your site. If you don’t have a requirement for passing additional data using SCData it will be passed as an empty string.
Please Note: It is required that the “OrderID” and “SCData” parameters are defined as varchar or nvarchar parameters at the top of your stored procedure.
Hope this helps!