Using 8.1.7 and need to insert into the following schema (example)
CREATE TYPE y_type AS OBJECT
(
z VARCHAR2(1)
);
/
CREATE TYPE x_type AS OBJECT
(
y y_type
);
/
CREATE TABLE x
(
x x_type
);
/
Need to insert a value into z !
Any ideas ??????
Further:
When you create a package, you should test the procedures on a stand-alone basis and then drop them before you make them part of a package.
What ThomVF says is valid.
Hi D,
Welcome to the world of ANSI standards (not)
As no-one has answered yet, the way it is done in Oracle is:
CREATE TABLE @myTable
(
f1 NUMBER, --NUMBER covers a multitude of types
f2 VARCHAR2(256),
f3 NUMBER
)
/ --execute statement!!
INSERT INTO @myTable
VALUES
(
..
);
/...
Also (a bit nit-picky) but why is degrees in the FROM statement for merit_cursor - it isn't selected from or used in any WHERE statement ?
Code a bit hard to read aswell, try using table aliases !!
Otherwise, as pointed out before, your column name probably doesn't exist in the table therefore...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.