Newbie Quest - passing selected form values to another procedure

Hi all,

I am using Sun hardware with Oracle v7.3.x, Oracle Web Server v3, Netscape browser
(pc client), PL/SQL packages, and I am trying to do the following:

I've created an html page allowing the user to select items from 2 different pull-down select lists;
User selections are to be sent to another procedure upon submission (via POST method)

I am having trouble getting the references set up correctly, and am getting the error message
Invalid reference to variable 'variable1' in Procedure A when compiling

the following snippet illustrates how I'm proceeding:

in Procedure A, the HTML page building for user selection from 2 lists includes the following....

    htp.formOpen('url of procedure to invoke upon submission','POST');
    htp.formHidden('variable1',variable1,NULL);
    htp.formHidden('variable2',variable2,NULL):

• further form population code snipped ====

in Procedure B, the entry point line is as follows:

PROCEDURE B

        (variable1 IN varchar2,
         variable2 IN varchar2) IS

I am assuming that, upon submission, variable1 and variable2 will be passed to Procedure B; where they will be used to access relevant info. from the database (variable1 is a table name, variable2 is an operation to be performed).

I hope I have provided enough information for someone to respond; if not, please let me know and I will post additional info.

Also, if anyone can point me to an example of this type of application, I would be most appreciative.

Thanks in advance for any responses.

Brian Richardson Received on Thu Sep 03 1998 - 12:24:46 CDT