Home » SQL & PL/SQL » SQL & PL/SQL » ORA-24334- no descriptor for this position (ORACLE 10g, Windows XP)
ORA-24334- no descriptor for this position [message #421372] Mon, 07 September 2009 23:19 Go to next message
baulraj
Messages: 48
Registered: January 2009
Member
Hi,

I am trying to insert a record into a table called 'A' then i am getting the above error ORA-24334 - no descriptor for this position.

Note the table 'A' has a LONG column 'descript'.

But the same query works fine with another table with same as table A with only one exception as 'descript' column is CLOB.

Kindly help me in this.

Thanks in advance.

Re: ORA-24334- no descriptor for this position [message #421374 is a reply to message #421372] Mon, 07 September 2009 23:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So use CLOB.
What do you expect us to tell more with what you posted?

Regards
Michel
Re: ORA-24334- no descriptor for this position [message #421375 is a reply to message #421374] Mon, 07 September 2009 23:38 Go to previous messageGo to next message
baulraj
Messages: 48
Registered: January 2009
Member
Hi Michel,

I need to give a common insert query to support both.

The same should work with table 'A' with LONG column in lower version of ORACLE i.e less than ORACLE 8.

Similary the table 'A' with CLOB column in higher versions of ORACLE. i.e ORACLE 8 or above.


Please clarify if i change a LONG column to CLOB then whether data will loss or not.


Thank you.
Re: ORA-24334- no descriptor for this position [message #421376 is a reply to message #421375] Mon, 07 September 2009 23:39 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Changing the datatype from LONG to CLOB leads to no data loss.

Regards
Michel
Previous Topic: Creating primary key for schema FOUT using sys
Next Topic: new line sign
Goto Forum:
  


Current Time: Tue Apr 23 07:15:55 CDT 2024