Location: Database

Discussion: errors while migrating from Oracle 9i to Oracle 10gReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 4 posts

knvrsatyaveer
errors while migrating from Oracle 9i to Oracle 10g
Feb 18 2009, 6:11 AM EST | Post edited: Feb 18 2009, 6:11 AM EST
hi . i am getting some data type mismatch error when i am running my application after migrating teh data base from 9i to Oracle 10G .. Any one has a solution for this .
i am getting the following exception >> java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got -
ORA-06512: at "NBUAT_4.ROLLBACK_DOCUMENT", line 116
ORA-06512: at line 1


The code is perfectly working with my previous version . Please suggest me if you have any solution for this . 1  out of 1 found this valuable. Do you?    
Keyword tags: None
linlasj
linlasj
1. RE: errors while migrating from Oracle 9i to Oracle 10g
Mar 3 2009, 5:36 AM EST | Post edited: Mar 3 2009, 5:37 AM EST
What is the datatype in Oracle 9i for the column ROLLBACK_DOCUMENT?

And, what are you trying to do when the error above occurs?


Br,
Lars Do you find this valuable?    

knvrsatyaveer
2. RE: errors while migrating from Oracle 9i to Oracle 10g
Mar 4 2009, 11:18 PM EST | Post edited: Mar 4 2009, 11:18 PM EST
Thanks linlasj .

CREATE OR REPLACE FUNCTION NB621DEV.rollback_document(p_internal_doc_refno VARCHAR2)
RETURN NUMBER IS
outresult NUMBER;
RESULT BOOLEAN;
status BOOLEAN;
con_status BOOLEAN; ....... this is the sample snippet of the function.. Please suggest if the return type of the function has to changed to CLOB . Do you find this valuable?    
linlasj
linlasj
3. RE: errors while migrating from Oracle 9i to Oracle 10g
Mar 9 2009, 6:29 AM EDT | Post edited: Mar 9 2009, 6:29 AM EDT
OK. So that is a function in some way. How do you use that function? What do you do with that function? Do you find this valuable?