RE: Create form in webdb

From: Nguyen, Long <Long.Nguyen_at_its.csiro.au>
Date: Tue, 21 Nov 2000 11:34:26 +1100
Message-Id: <10686.122563@fatcity.com>

Thanks Brian for your input.

I have followed your advice and changed the procedure to have default value for the nullable parameter. Since webdb calls the procedure using the named notation method, this works.

Thanks
Long

-----Original Message-----
From: Anderson, Brian [mailto:andersob_at_mail.dartnet.peachnet.edu] Sent: Thursday, 16 November 2000 1:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Create form in webdb

I don't know much about webdb, but it sounds like you need to put a default value for the parameter in the procedure. Then hopefully webdb can just pass the 3 parameters and it should use the default value for the other.

-----Original Message-----
Sent: Tuesday, November 14, 2000 11:40 PM To: Multiple recipients of list ORACLE-L

I am new to webdb and using webdb to develop a simple application. I have gone through the tutorial. If you have used webdb pls see if you could help me out here. Much appreciated.

What I want to do is
Create a form based on a stored procedure,

    	and the procedure has 4 IN parameters
	and the form has 4 fields for the user to type in

The problem I have is that I want one of the input fields to be optional, and if the user does not put in any value, then the form would pass a NULL value for this parameter to the procedure behind the scence.

How can I do it?

(With my form so far if the user does not put in a value in the field the form does not pass any value to the procedure and so I got "Invalid cursor" error message when running the form).

Long
--

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Anderson, Brian
INET: andersob_at_mail.dartnet.peachnet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 20 2000 - 18:34:26 CST