| View previous topic :: View next topic |
| Author |
Message |
newcobol
Beginner
Joined: 20 Apr 2006
Posts: 88
Topics: 22
|
 Posted: Fri Aug 26, 2011 1:22 pm Post subject: -1455 ORACLE ERROR IN EMBEDDED SQL IN COBOL PROGRAM |
 |
|
ERROR RUNNING THIS PARA:
**AcuBench Column Block**
| Code: |
SELECT RRI_ID
INTO :RSS-FK-RRI-ID
FROM REA_ROOM_INFO_RRI
WHERE RRI_CASE_MANAGER = :RST-CASE-MANAGER
AND RRI_ROOM_AVAILABLE_DT <= COD(:WSH-DATE-OF-THE-DAY)
AND RRI_ACTIVE_IND = :WSV-YES
AND RRI_REA_TYPE_CD = :WSV-RRI-ONE-ONE
|
THE INTO VARIABLE IS INITIALIZED TO 0
RST-CASE-MANAGER IS VARCHAR 30. TWO DOTS THEN ST. AUBIN, ALLISON
DATE OF THE DAY IS 01/23/2012
WSV-YES IS 'Y'
TYPE CD IS 3141
THE PROGRAM HAS GONE THRU THIS PARA MANY TIMES AND BLOWS UP ON THIS PERSON.
ANY IDEAS? |
|
| Back to top |
|
 |
newcobol
Beginner
Joined: 20 Apr 2006
Posts: 88
Topics: 22
|
| Posted: Fri Aug 26, 2011 1:29 pm Post subject: |
|
|
| I should mention that this program runs in toad when i copy and paste it there and replace the variables with the values |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Fri Aug 26, 2011 1:38 pm Post subject: |
|
|
In Oracle, what is a -1455?
_________________
All the best,
di |
|
| Back to top |
|
|
newcobol
Beginner
Joined: 20 Apr 2006
Posts: 88
Topics: 22
|
| Posted: Fri Aug 26, 2011 1:46 pm Post subject: |
|
|
ORA-01455: converting column overflows integer datatype
Cause: The converted form of the specified expression was too large for the specified datatype.
Action: Define a larger datatype or correct the data.
when checking fields, all variables i listed above appear to fit fine. as i said, the program has gone thru this paragraph many times already. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Fri Aug 26, 2011 2:34 pm Post subject: |
|
|
well, let's start from scratch.
what is the datatype of column RRI_ID
what is the cobol datatype definition of RSS-FK-RRI-ID
rather, what does the ddl state for RRI_ID
What is the line of cobol look like where you define RSS-FK-RRI-ID?
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
