| ORA-01460: unimplemented or unreasonable conversion requested [message #120140] |
Tue, 17 May 2005 22:23  |
raghavan479
Messages: 1
Registered: May 2005
|
Junior Member |
|
|
My table has a CLOB field and we use pro*C for accessing the Oracle tables.
We recently migrated from Oracle 8i to Oracle 9i.
The following piece of code is throwing a runtime error under the new Oracle9i environment when I have the MAX_FILE_SIZE set to 100000.
"ORA-01460: unimplemented or unreasonable conversion requested"
I reduced the MAX_FILE_SIZE to 30001 and the code executed fine.
---------------------------------------------------
#define MAX_FILE_SIZE 30001
typedef char clob[MAX_FILE_SIZE];
EXEC SQL TYPE clob IS LONG (MAX_FILE_SIZE);
DECLARE
file_loc CLOB;
amt INTEGER;
offset INTEGER;
BEGIN
DBMS_LOB.READ(file_loc, amt, offset, :data_file);
END;
END-EXEC;
---------------------------------------------------
The same piece of code runs fine under Oracle 8i with the MAX_FILE_SIZE even set to 100000
My old environment
------------------
OS: HP-UX 10.20
Oracle version: 8i
Compiler: HP-UX ANSI C compiler
My new environment
------------------
OS: HP-UX 11.0
Oracle version: 9i
Compiler: HP-UX ANSI C compiler
Are there any changes that has been done with the datatypes under pro*C under Oracle 9i?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
