home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!destroyer!sol.ctr.columbia.edu!The-Star.honeywell.com!umn.edu!noc.msc.net!uc.msc.edu!shamash!ems!ems.cdc.com!pveltkam
- From: pveltkam@ems.cdc.com (Paula Veltkamp)
- Newsgroups: comp.databases.oracle
- Subject: Re: Can Dynamic SQL handle NUMBER datatype without precision and scale.
- Message-ID: <21427@nntp_server.ems.cdc.com>
- Date: 27 Aug 92 18:26:11 GMT
- References: <1992Aug4.164432.12930@unixg.ubc.ca> <1992Aug13.030611.1@us.oracle.com>
- Sender: sys@ems.ems.cdc.com
- Reply-To: pveltkam@ems.cdc.com
- Organization: Empros Systems International, a division of CDC
- Lines: 16
- Nntp-Posting-Host: ajax.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
-