Setting the Callable (Stored Procedure) dialog box options The purpose of this dialog box is to insert a stored procedure into your JSP page.
Procedure
Enter a name for the stored procedure.
In the Connections pop-up menu, choose a connection to the database containing
the stored procedure.
In the Database Items text box, expand the Stored Procedures branch, select
the stored procedure from the list, and click the Procedure button.
automatically fills in the Callable Text and Variables boxes.
Select the Returns Recordset Named checkbox, then enter a name for the recordset,
if the stored procedure returns a recordset, and then click the Test button
to see the recordset that the stored procedure returns.
runs the stored procedure and displays the recordset, if any.
Note: If the stored procedure returns a recordset and takes parameters, you must enter a value in the Default Value column in the Variables box to test the stored procedure.
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.
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 422