3

Friends,

This question is related to this one.

Steven Feuerstein writes in his book, PL/SQL Programming, that he doesn't recommend using BINARY_INTEGER for new work unless it is going to be run on releases of Oracle prior to 7.3. (source 5th Edition page 238-239)

Given that PLS_INTEGER and BINARY_INTEGER are, from 10g R1, identical, why shouldn't it be used?

Community
  • 1
  • 1
Ian Carpenter
  • 8,346
  • 6
  • 50
  • 82
  • 1
    Because PLS_INTEGER is more future-proof than BINARY_INTEGER (i.e. any future development e.g. in performance might be done only to PLS_INTEGER) ? This, of course, is a highly speculative guess, but as I have learned recently many Oracle quirks are there because _historical reasons_. – user272735 Sep 15 '11 at 04:13

1 Answers1

2

No, The 11g language reference suggest both are equally valid.

see: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/datatypes.htm#i10726

Kevin Burton
  • 11,676
  • 2
  • 24
  • 37