OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Pack decimal

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pack decimal [message #341129]

Sat, 16 August 2008 21:19

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

Anybody has useful knowledge about the Pack decimal stuff. I have requirement to send data to mainframe from oracle. and all numeric values has to be pack decimal.
I have never done this stuffs before, i am also using google to search for some help. I appreciate if somebody can provide me any useful link or knowledge about this nightmare for me (Pack decimal).

Report message to a moderator

Re: Pack decimal [message #341130 is a reply to message #341129]

Sat, 16 August 2008 22:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Packed Decimal is a flash from my past.
I was doing Cobol programming (with packed decimal values) 30 years ago on an IBM mainframe.

http://en.wikipedia.org/wiki/Binary-coded_decimal

I suspect you could put Perl to good use to produce desired results.

Report message to a moderator

Re: Pack decimal [message #341135 is a reply to message #341130]

Sun, 17 August 2008 00:13

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

Oracle 9.2.0.2 and Windows Professional 2002

Can create a output file for the Mainframe using spool process of sqlplus.Some suggestion from your old memories would be appreciated..

Report message to a moderator

Re: Pack decimal [message #341136 is a reply to message #341129]

Sun, 17 August 2008 00:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can create a output file for the Mainframe using spool process of sqlplus
I suspect not; 'cuz AFAIK sqplus does not speak Packed Decimal.
Perhaps using UTL_FILE, but no promises.
Others are free to prove me wrong.

Report message to a moderator