Inserting constant value...

Anyone know if/how to get round this...

• Define a package spec. with constants in it...

CREATE OR REPLACE PACKAGE foo IS

   ...
   c_bar CONSTANT NUMBER := 1;
   ...
END;

• Then try to do an insert into a table...
• Using the constant as one of the values!
• This is attempted 'outside' the package body.

INSERT INTO icarenot (val) VALUES (foo.c_bar);

I know and have tried all the varients of 'EXPR' (short of creating access methods in the package to the constants).

Thanks in advance,

T.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 11:02:42 CST