Re: Can Dynamic SQL handle NUMBER datatype without precision and scale.
From: Paula Veltkamp <pveltkam_at_ems.cdc.com>
Date: 27 Aug 92 18:26:11 GMT
Message-ID: <21427_at_nntp_server.ems.cdc.com>
Date: 27 Aug 92 18:26:11 GMT
Message-ID: <21427_at_nntp_server.ems.cdc.com>
Hi,
I've written a PRO*C program which uses dynamic sql. The purpose of the program is to export data out of the database using selects created from existing .ctl files. I'm using ORACLE version 6.0.31. and PRO*C version 1.3.
Apparently, dynamic sql can't handle NUMBER datatypes without a precision and scale defined. The datatype value (sdp->T[i]) comes back as a CHAR value and the Length (sdp->L[i]) is set to 0. I've gotten around the problem of having the program crash when it tries to allocate memory for the sdp->V[i] value by setting the sdp->L[i] value to the character byte size. However, I get no data back.
Anybody know I can retrieve the data?
Paula Received on Thu Aug 27 1992 - 20:26:11 CEST