Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERRO ORACLE - DATA_PRECISION NULL

AfonsoRodriguesJun 24 2013 — edited Jun 24 2013

Good Morning,


I'm making some adjustments to a base when I came across the following situation:
DATA_PRECISION = NULL


I did a select on the table all_tab_columns with ordinary filters (table_name, owner, column_name). It was returned to the column I selected aviation, but with the field data_precision = null. The column is of type number.


Curious did a desc table.

And the number desc returned (38) to the column.


This is home base for a project of ODI and when I do reverse engineering, the field returns to size 0 -127 and accuracy.


This error is Oracle? Has some way to fix it?

select * from v$version;

BANNER                                                                        
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production    
PL/SQL Release 11.2.0.1.0 - Production                                          
CORE   11.2.0.1.0   Production                                                        
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production                         
NLSRTL Version 11.2.0.1.0 - Production                                          

Thank's
This post has been answered by Greg Spall on Jun 24 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2013
Added on Jun 24 2013
#11g, #database, #oracle
6 comments
1,609 views