Skip to Content
0
Former Member
Feb 09, 2011 at 06:22 PM

Calling a MaxDB procedure from another application

104 Views

Hi Experts,

Does anyone know how to call a MaxDB stored procedure from outside of MaxDB, using the sapdbc.jar jdbc driver? I can call one successfully from Database Studio like this:

call DBADMIN.order_tot_amt (1, :o_id) (This simple stored procedure only returns a single value)

For example, this works with MSSQL:

DECLARE @Description Varchar(60)

Execute usp_getCatDesc 'Produce', @Description = @Description OUTPUT

Select @Description

Is there something similar for MaxDB? I have been unable to find any information after much searching.

Thanks,

Diana Hoppe