Toad World® Forums

PLS-00103: encountered the symbol


#1

BEGIN

FUNCTION coyname(sql_id IN planchangetbl.sql_id%TYPE)

RETURN VARCHAR2

IS

echange planchangetbl.sql_id%TYPE;

BEGIN

select distinct s.sql_id, s.plan_hash_value, b.begin_interval_time, b.end_interval_time,

s.min_snap_id, s.max_snap_id INTO echange from sys.hashchange s, sys.planchangetbl b

where s.sql_id = b.sql_id

and b.snap_id BETWEEN s.min_snap_id AND s.max_snap_id

RETURN echange;

EXCEPTION

WHEN NO_DATA_FOUND

THEN

RETURN NULL;

END;

END;


#2

Hi,

what is your question? Why do you select 6 values in one variable? That cannot work.

Best regards

Dennis


#3

Thank you Dennis,

All I want is to display the 6 items from the two tables using the block function

Regards

Ibkife