Skip to Main Content

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!

Error value larger than specified precision

suman amaraApr 11 2014 — edited Apr 11 2014

HI Team,

I am executing PACKAGE i am getting below error message

ORA-01438: value larger than specified precision allowed for this column tips


I see in my package same procedure have multiple time with parameter changes. Is it making any pro.

syntax using my package is

set serveroutput on

declare

   v_rq SERV_REQ_RESULT_LIST;

begin

       v_rq := sa_req.F_CREATE

( SERV_REQ_ATTR_LIST (

A ('REQUEST TYPE', 'REDPLP'),

A ('SUB ID', '1271344'),

A ('SUB ID TYPE' ,'Q'),

A ('USER SEQ' ,'22'),

A ('EXTERNAL REF', 'ABD323'),

A ('REASON', 'RED')

)

, NULL

, NULL

, NULL

);

end;

  /

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2014
Added on Apr 11 2014
2 comments
469 views