Subject | Re: [IB-Java] Firebird jdbc: How to use stored procedure? |
---|---|
Author | Rolf C Stadheim |
Post date | 2001-12-31T02:08:43Z |
Select procedure named GET_CUSTOMER_PURCHASES with input integer (customer
id = 50):
select * from GET_CUSTOMER_PURCHASES(50) order by product
Non-select procedure named DELETE_CUSTOMER with input integer (customer id
= 50):
execute procedure GET_CUSTOMER(50)
RCS
At 21:43 30.12.2001 +0000, you wrote:
id = 50):
select * from GET_CUSTOMER_PURCHASES(50) order by product
Non-select procedure named DELETE_CUSTOMER with input integer (customer id
= 50):
execute procedure GET_CUSTOMER(50)
RCS
At 21:43 30.12.2001 +0000, you wrote:
>I have a few stored procedure in the database, which requires input
>parameters. How to use such stored procedures?
>
>Thanks
>
>jw