Running the stored procedure in JSP With JSP pages in , you must add a Callable server behavior to a page to run a stored procedure.
To add a stored procedure to a JSP page:
In , open the page that will run the stored procedure.
In the Bindings panel, click the plus (+) button, and choose Callable (Stored
Procedure).
The Callable (Stored Procedure) dialog box appears
Complete the dialog box.
For instructions, see Setting the Callable (Stored Procedure) dialog box options.
Click OK.
After you close the Callable (Stored Procedure) dialog box, inserts
JSP code in your page that, when run on the server, calls a stored procedure
in the database. The stored procedure in turn performs a database operation,
such as inserting a record.
If the stored procedure takes parameters, you can create a page that gathers the parameter values and submits them to the page with the stored procedure. For example, you may create a page that uses URL parameters or an HTML form to gather parameter values from users.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101