OraFAQ Forum: Reports & Discoverer » REP-0738: only a function allowed here

Home » Developer & Programmer » Reports & Discoverer » REP-0738: only a function allowed here

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

REP-0738: only a function allowed here [message #456488]

Tue, 18 May 2010 02:59

mahajneh
Messages: 16
Registered: May 2010

Junior Member

hello evreybody

am trying to write a function at beforereport

function BeforePForm return boolean is
vc_parameter_form varchar2(4000);
vc_hidden_runtime_values varchar2(1000);
vc_report_name varchar2(100);
begin
If (:p_action='_action_') then
vc_hidden_runtime_values:='_hidden_';
else

swr.get_report_name=(vc_report_name);
vc_report_name:=substr(vc_report_name,1,instr (vc_report_name,' ')-1);
vc_hidden_runtime_values:='report='||vc_report_name||
'&destype='||:destype||'&desformat='||:desformat||'
&userid='||:p_user_connect||'&server='||:p_servername;
end if;
vc_parameter_form:='<html><body bgcolor="#ffffff"><form method=post
action="'||:P_ACTION||'"><input name="hidden_run_parameters" type=hidden
value="'||vc_hidden_runtime_values||'"><center><p><table border=0 cellspacing=0
cellpadding=0><tr><td><input type=submit></td><td> width=15><td><input
type=reset></td></tr></table><p><hr><p>';
srw.set_before_form_html (srw.text_escape, vc_parameter_form);

return(true);
end;

but when I compile this code I get the error
REP-0738: only a function allowed here

any help please
thanx in advance

Report message to a moderator