clob & object types
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: clob & object types

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    clob & object types

    Hi All

    I have a type as xml_payload . database is 817

    create type xml_payload(id number, data clob);

    create table test(col xml_payload);

    insert into test values(xml_payload(1,'buildingxmlapplications'));
    gives the following error :

    ERROR at line 1:
    ORA-00932: inconsistent datatypes

    How to overcome this .


    Regards
    Sushant

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width