OraFAQ Forum: Forms » How to use associative array in procesure

Home » Developer & Programmer » Forms » How to use associative array in procesure (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use associative array in procesure [message #298554]

Wed, 06 February 2008 06:31

AnamikaChaudhary
Messages: 33
Registered: December 2007
Location: Mumbai

Member

Hi,

This is my table structure:

ID NUMBER(5)
CCOMMODITY_NAME VARCHAR2(40)
CPROHIBITED_PORT VARCHAR2(30)
CCOMMENT VARCHAR2(600)

This is the code :

DECLARE
record_found NUMBER(5);

BEGIN

select count(*)
into record_found
from prohibited_commodity
where CCOMMODITY_NAME = :blk2.commodity1
--and CPROHIBITED_PORT IN (select CPROHIBITED_PORT from prohibited_commodity);
and CPROHIBITED_PORT = :blk2.load_code;

if record_found > 0 then

message (' THIS COMMODITY is restricted to: '||:blk2.load_code||'');
raise form_trigger_failure;
else

NEXT_FIELD;
end if;
END ;

I have to use this code in procedure and the table is declared to be ASSOCIATIVE ARRAY. So that this code can be used in multiple forms ..

please help me
thanks

Report message to a moderator