Trace: • Object Injection • Functions and Procedures With IN and OUT Parameters • Global Metadata Caching
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
jvx:server:db:func_proc [2020/06/15 12:15] cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
jvx:server:db:func_proc [2020/06/29 13:06] (current) cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ~~Title: Functions and Procedures With IN and OUT Parameters~~ | ~~Title: Functions and Procedures With IN and OUT Parameters~~ | ||
| - | If you use database procedures and/or functions in your application, wouldn't it be great to call them with one simple call. Normally a function or procedure call is very complex because you have to define a CallableStatement, set the output parameters, execute the statement, and read the result. And don't forget that the parameter index starts with 1 instead of 0! | + | If you use database procedures and/or functions in your application, wouldn't it be great to call them with one simple call? Normally, a function or procedure call is very complex because you have to define a CallableStatement, set the output parameters, execute the statement, and read the result. And don't forget that the parameter index starts with 1 instead of 0! |
| - | Suppose we have a function (e.g. Oracle): | + | Suppose we have a function (e.g., Oracle): |
| <file plsql> | <file plsql> | ||