How to store object in Database (Oracle 8.0.5)?

How to store object in Database (Oracle 8.0.5)?

Post by saksh.. » Sun, 31 Dec 1899 09:00:00



How to store object in Oracle 8.0.5?
example
-----------
         create type obj1 as object(
         num number,
         den  number,
         result number,
         member procedure plus);
         create type body obj1 as
         member procedure plus is
         begin
               result:=num+den;
         end plus;
          end;

        How to initialize instance of object type obj1 in Database
        and not store in table.( ex.  create table obj_instance  of obj1; ).

        Does anyone know the way to solve this problem?
        Thank you for an attention to this message.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

 
 
 

1. mmmyql driver doesn't store a vector object in mysql database (changes serialized object string)

hello,

i'd appreciate any help on the problem i keep having since i'm running
out ouf ideas.
i tried to store a vector object using the mmmysql driver 1.2 and 2.0pre
in a mysql database (win32 version 3.21).
as you can imagine, the serialized vector object contains a lot of
unusual ascii characters. when i write the object to a file and read it
in using "load infile .." mysql inserts it without any problems.
using the drivers setObject() or setBinaryStream() methods not a single
character of the object reaches the database, just two ascii signs (not
contained in the serialized object string) and a lot of spaces.
to make it even worse, a result query (ResultSet rs
= executeQuery("select * from tableX")) to select this row doesn't even
return!!

if anyone could help me, i'd be glad.

thanks in advance,

sebastian

PS: i tried the original "store objects in database for persistence"
example in http://www.codeguru.com with the same result

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Ingres FAQ (2 of 3)

3. Storing Objects in Oracle Database?

4. About FullText , search some word in a vocable not support ?

5. NC-Durham-267858--ORACLE-Relational Database-Database Applications-Object Orient

6. Cognos VB Script: problem to get all dimension & categories.

7. 24075-IN-Indianapolis-Business Objects-ORACLE-SQL-Business Objects, Oracle

8. VB4(16bit)-->ODBC-->SQL6.5 -- One update strangles the server

9. Storing objects in a database

10. how to script my database objects weekly with stored proc running in a job

11. Returning a database object in stored procedures

12. Storing of group permissions to database objects