Calling an Oracle Stored Proc from MicroFocus Cobol

From: Christina Candlena <candlena_at_acsu.buffalo.edu>
Date: Wed, 11 Aug 1999 09:19:24 -0400
Message-ID: <7ort04$618$1@prometheus.acsu.buffalo.edu>

I'm in the process of converting our cobol programs using a Sybase Database to use and Oracle database. I am receiving an Ora-00900 error when returning from the stored procedure. This stored procedure is being called through a Powerbuilder application which is working

Cobol program code

exec sql

exec apb_addrupd

:variabe1,
:variable2,
:list of variables required for the stored procedure,
end-exec.

If sqlcode < 0 - This is where I am getting the error.

Thanks in advance for the help. Received on Wed Aug 11 1999 - 08:19:24 CDT