I HAVE A PROBLEM REGARDING DECLARATION/ INITIALISATION OF VARIABLES IN POSTGRESQL FUNCTIONS AND PROCEDURES. MY CODE PRESENTLY LOOKS LIKE
[CODE=sql]
CREATE FUNCTION ins_into_std_va lues() RETURNS void AS
$BODY$
myflag CHAR(1) :='y';
dbms_output.put _line('enter the values sequentially');
loop
if myflag='n' then
exit;
end if;
insert into std_values
values('&tree_s pecies_name','& location',&p,&c 1,&c2,&q,&c3,&a ,&b,&sp_gravity ,&exp_factor) ;...