Help! Passing numbers from cobol to Oracle Pkgs

From: <applogic_at_xnet.com>
Date: 1995/09/02
Message-ID: <42a5at$9vi_at_flood.xnet.com>#1/1

Help!

I'm convertting an application from Sybase to Oracle, and need to pass data from a cobol (yuk) app to IN/OUT variables in our packages. Char and Varchar work fine, but I've been stuck on the conversion of comp-3/Cobol numbers to NUMBER/PL-SQL. The numbers always get butchered. Have tried display, comp-6, and comp-3 to NUMBER. (Comp-3 is packed decimal, Comp-6 is a binary floating point representation.

The cobol app is on a Stratus mini/communications server, and the actual database is on a Pyramid platform, SQL*Net providing the link.

I must be doing something dumb, it can't be this hard. Is there any good place to get examples? Anybody else had this problem?

Eternal gratitude in advance.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


% Greg Gasser               % # include <disclaimer.h>         %

% applogic_at_xnet.com         % All opinions expressed were      %

% Applied Logic, Inc.       % processed on a Pentium.So even I %

% Client Server Solutions % have reason to doubt they add up.%

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Received on Sat Sep 02 1995 - 00:00:00 CEST