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

Thread: datatype

  1. #1
    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

  2. #2
    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.

  3. #3
    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.

  4. #4
    Join Date
    Feb 2001
    Posts
    30
    I think so. Still try.

    Thanks for your help -- PSoni & sln81

    fog2k

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