Cursor on a popup window

From: Patrice Fiset <pfiset_at_capitale.qc.ca>
Date: 2000/06/08
Message-ID: <qaT%4.19866$NS6.265646@news.globetrotter.net>#1/1

I declare a cursor. then I have an image that when you click on this image it makes a popup window to open, on this window, I have a selectname and I make a loop that reads the informations on the database, so each options are a row. When I compile, I have no errors, but when I click on the image, the browser tell me that there's an error on the page. If I right click on the page to see the source, I actually see all the information I want but there's a error that just prevent the popup window to actually popup!

Here's the source:

create or replace package body TEST is

procedure prc_form_emplr
is

      CURSOR cr_select_resp IS
        select resp_refcontact, resp_lname, resp_fname
        from cocf_tbl_respn
        order by resp_refcontact;

begin

        htp.htmlopen;
        htp.headopen;
        htp.title('Employer Section');
        htp.p('

                   <Script Language="javascript">
                     function popUp()

                     myWin= open("", "displayWindow", "width=400,
height=450");


                     // open document for further output

                     myWin.document.open();


                     // create document

                     myWin.document.write("<html><head><title>Acronym");
                     myWin.document.write("</title></head><body>");
                     myWin.document.write("
                     <SELECTNAME="gr_contact" SIZE=3 MULTIPLE>');
                     for v_resp IN cr_select_resp loop
       htp.p('   <OPTION> '|| v_resp.resp_refcontact ||' - '||
v_resp.resp_lname
                     ||'&nbsp;' || v_resp.resp_fname);
                     end loop;
       htp.p('    </select>"); ');
       htp.p('    myWin.document.write("</body></html>");


                     // close the document - (not the window!)

                     myWin.document.close();
                                    }
                  </Script>
             ');

thx Received on Thu Jun 08 2000 - 00:00:00 CDT