Newbie - PL SQL Declarations (%type,%rowtype)

I am having problem with the following declarations in a package.

The portion of the code the error message is pointing to, I get a mes

npanxx          npanxx%rowtype;
loc             npanxx.exch%type := NULL;
npachk          npa%rowtype;
npa             npachk.npa%type;

I get the following errors (similar for each of the lines of code above.)

42/10 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

42/10 PL/SQL: Declaration ignored

I have other declarations similar to this with other tables, and it doesn't complain there, but it complains here. It is not consistent.

Any suggestions would be great help

TIA Anil

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 08 1998 - 00:00:00 CDT