DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: datatype

  1. 02-25-2001, 02:16 AM #1
    fog2k
    fog2k is offline Junior Member
    Join Date
    Feb 2001
    Posts
    30

    Exclamation

    Hi all,

    I use 8i and developer/2000 2.1.
    I create my datatype on 8i and using for table attribute.
    I create form on d2k using data block wizard. I can connect 8i but I can't connect table that contain attribute of my data type. I can connect table that isn't contain data type only.

    error is 'ORA-01024 invalid datatype in OCI call'

    I think this d2k version accept datatype.

    How d2k regonize my data type on 8i to using on d2k?



    thanks
    fog2k
    Reply With Quote Reply With Quote
  2. 02-26-2001, 04:03 AM #2
    PSoni
    PSoni is offline Member
    Join Date
    Feb 2001
    Posts
    125
    If You are using From 5.0 or old version then it will
    not support Abstract data type.


    Pitamber Soni.
    Reply With Quote Reply With Quote
  3. 02-26-2001, 11:00 AM #3
    sln81
    sln81 is offline Member
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    D2K does not support user defined datatypes. But there is a work around. You can create a form based on procedure. You can create a package in the database in which have the procedures to add, modify, delete & retrieve records from the table with columns having user defined datatypes. Then create the form based on these procedures.
    Reply With Quote Reply With Quote
  4. 02-26-2001, 12:11 PM #4
    fog2k
    fog2k is offline Junior Member
    Join Date
    Feb 2001
    Posts
    30
    I think so. Still try.

    Thanks for your help -- PSoni & sln81

    fog2k
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width