Home » RDBMS Server » Server Administration » anchored definition in type declaration
anchored definition in type declaration [message #371615] Tue, 14 November 2000 22:59 Go to next message
Manju
Messages: 10
Registered: November 2000
Junior Member
hi,
i am creating an object based on a particular table,but instead of giving the data types explicitly like varchar2(100),number(10),date etc,i want to use an anchored definition like <base HREF="http://www.orafaq.com.way_back_stub/msgboard/sql/messages/2717.htm"tablename>.<columnname>%type
so that any changes in the base table can be automatically reflected in the object
is this possible?
i am getting an error on using such a declaration
any help in this regard will be appreciated
Manju

Report message to a moderator

Re: anchored definition in type declaration [message #371619 is a reply to message #371615] Wed, 15 November 2000 03:34 Go to previous messageGo to next message
John R
Messages: 156
Registered: March 2000
Senior Member
And the error is......?

Report message to a moderator

Re: anchored definition in type declaration [message #371628 is a reply to message #371619] Wed, 15 November 2000 22:47 Go to previous messageGo to next message
Manju
Messages: 10
Registered: November 2000
Junior Member
hi ,
the error that i am getting is:
PLS-00201:identifier
must be declared
M

Report message to a moderator

Re: anchored definition in type declaration [message #371643 is a reply to message #371628] Mon, 20 November 2000 06:07 Go to previous message
John R
Messages: 156
Registered: March 2000
Senior Member
They syntax you should be using is:

l_variable table_name.column_name%TYPE;

Does this help?

Report message to a moderator

Previous Topic: appending 2 digits from year to sequence number.....
Next Topic: dbwr-slaves with assynchronous I/O
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 21:52:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.