I am trying to get a procedure to work when executed from a form. When I execute it, it just hangs there. I would greatly appreciate it if someone would look at this code and figure out why it does not want to run. The syntax compiles with no errors and is as follows:
(
drgval IN VARCHAR2)
as
BEGIN
DECLARE
DRGTemp charity.drg%type;
FyearTemp charity.fyear%type;
CURSOR drglookup IS SELECT * FROM mattw.charity where drg = drgval;
BEGIN
htp.print('<HTML>');
htp.print('<HEAD>');
htp.print('<TITLE> DRG Lookup</TITLE>');
OPEN drglookup;
Loop
htp.print(drgtemp);
htp.print(fyeartemp);
END LOOP;
htp.print('</BODY>');
htp.print('</HTML>');
END;
END
(
drgval IN VARCHAR2)
as
BEGIN
DECLARE
DRGTemp charity.drg%type;
FyearTemp charity.fyear%type;
CURSOR drglookup IS SELECT * FROM mattw.charity where drg = drgval;
BEGIN
htp.print('<HTML>');
htp.print('<HEAD>');
htp.print('<TITLE> DRG Lookup</TITLE>');
OPEN drglookup;
Loop
htp.print(drgtemp);
htp.print(fyeartemp);
END LOOP;
htp.print('</BODY>');
htp.print('</HTML>');
END;
END