Search results for query: *

Try without the ; at the end of the line.

Or try this link: http://www.databasejournal.com/features/oracle/article.php/2197201

trim(col) is only 8i and upwards of course

Solution is INSERT INTO x VALUES (x_type(y_type('Z'))

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 ??????

Or even use ltrim(rtrim(col)) !!

You will need to specify the full database name <name>.<domain> at the connect gui

Try Metalink articles 156477.1 or 175472.1 - they are for 8.1.7 but will give you the general idea.

Except.... You are TRUNCATING INTO the table twice !! [cry]

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