Methods inherited from interface java.sql.Sets the designated parameter to the given object. Since: 8.1.7 See Also: Connection.prepareCall Your invocation call in your JDBC program should look like:ĬallableStatement cs = conn.prepareCall ("begin ? := foo(?) end ") The PL/SQL function gets a character sequence and concatenates a suffix to it:Ĭreate or replace function foo (val1 char) ( "begin ? := func(?,?) end " ) // stored funcĪs an example of using Oracle syntax, here is a PL/SQL code snippet that creates a stored function. ( "begin proc (?,?) end " ) // stored proc The following PL/SQL calls would work with any Oracle JDBC driver: They support both SQL92 escape syntax and Oracle PL/SQL block syntax. Oracle JDBC drivers support execution of PL/SQL stored procedures and anonymous blocks. It is used to execute SQL stored procedure. This interface extends the OraclePreparedStatement (which extends the OracleStatement interface) and incorporates standard JDBC callable statement functionality.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |