This section describes general issues and constraints that apply to SQLJ functions and stored procedures.
Only public static (class) methods can be referenced in a SQLJ function or stored procedure.
Datatype mapping is checked when the SQLJ routine is created. During the execution of a SQLJ routine, data is passed from SQL to Java and back to SQL. Any data conversions required during execution must follow the rules for datatype mapping outlined in the JDBC standard.
Refer to “Mapping Java and SQL datatypes” for a discussion of datatype mapping and conversions for SQLJ routines.
If a method referenced by a SQLJ function or stored procedure invokes SQL, returns parameters from the SQL system to the calling environment, or returns result sets from SQL to the calling environment, you must use an Adaptive Server JDBC interface, such as Sybase jConnect or the internal Adaptive Server JDBC driver, that enables object-oriented access to the relational database.
