Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> pl/sql: insert a type-object into a table

pl/sql: insert a type-object into a table

From: Pascal Ziegler <pascal.ziegler_at_bluewin.ch>
Date: Fri, 05 Sep 2003 18:15:11 +0200
Message-ID: <3f58b664$1@news.swissonline.ch>


hi,

i have e.g. the this type-object and the table to store it:

CREATE TYPE test_t AS OBJECT (a number, b number);

CREATE TABLE test_items OF test_t;

now i want to save an instance of the object test_t into this table. i tried it with the following pl/sql-code:

[...]

as

myObject test_t;

begin

[...]

myObject := new test_t('1','2');

[...]

INSERT INTO test_items VALUES (myObject); -- <== not working

[...]

end;

this was not working! :-( do you have any idea how I have to write my insert-statement?

thanks for helping!

Received on Fri Sep 05 2003 - 11:15:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US