SQLServerCallableStatement Class
Lets you specify the stored procedure name to call along with input and output parameters. This class also provides the ability to retrieve the return status value with the ? = call( ?, ..)
syntax.
Package: com.microsoft.sqlserver.jdbc
Implements: ISQLServerCallableStatement
Extends: SQLServerPreparedStatement
Syntax
public final class SQLServerCallableStatement
Remarks
SQLServerCallableStatement lets you specify the stored procedure name to call along with input and output parameters. SQLServerCallableStatement also provides the ability to retrieve the return status value with the ? = call( ?, ..)
syntax.
This class supports unwrapping to SQLServerCallableStatement class, ISQLServerCallableStatement interface, java.sql.CallableStatement interface, and the classes and interfaces supported by SQLServerPreparedStatement for unwrapping. For more information, see Wrappers and Interfaces.
When one of the SQLServerCallableStatement set methods is called for a type, if that type conflicts with the type specified with registerOutParameter, the type specified by the last SQLServerCallableStatement set method is used. However, this may cause incompatible data type conversion errors. If a SQLServerCallableStatement set method is not called, the type specified with the first registerOutParameter call is used.
The SQL Server JDBC Driver 3.0 is compliant with the JDBC 4.0 recommendation that a result set and update counts must be retrieved before retrieving OUT parameters. If OUT parameters are retrieved before the result set and update counts have been completely processed, any result sets and update counts that have not been processed are lost.
See Also
SQLServerCallableStatement Members
JDBC Driver API Reference
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za