Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-01460: unimplemented or unreasonable conversion requested
ORA-01460: unimplemented or unreasonable conversion requested [message #120140] Tue, 17 May 2005 22:23 Go to next message
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?
Re: ORA-01460: unimplemented or unreasonable conversion requested [message #120929 is a reply to message #120140] Tue, 24 May 2005 15:58 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Have you checked the O/S kernel parameters are not reaching the upper limit.
Previous Topic: OCIHandleAlloc fails
Next Topic: Pro*c exe creation
Goto Forum:
  


Current Time: Thu May 19 21:02:23 CDT 2022