Re: ERROR MESSAGES FROM THE BROWSER

From: Fred Hirschfeld <johndoe_at_microsoft.com>
Date: 1997/10/17
Message-ID: <6291a2$eo4$1@news.bc>#1/1

> 1.- How to use forms in PL/SQL to pass info between web pages?
Simple:

  htp.formOpen('package.function');
  htp.formHidden('name', value);  -- any hidden variables
  htp.formText(cname=>'name', cvalue=>'value');  -- any text fields

  ...
  htp.formClose;

Then the package.function must have all of the form element names as IN parameters to receive the value.

> 2.- Why does this cursor break my web page?
The cursor does not have to be opened, simply use the for loop. It will automatically be opened.

> 3.- Is there any way to see an error message in the browser
> that explain what really happens?
Use exceptions:
  BEGIN
    ...
  EXCEPTION
    ...
    WHEN OTHERS THEN
      htp.p(sqlerrm);
  END;

--
    Cheers Fred
----------------------------------------------------------------------------
-----------------
Fred Hirschfeld                                      Sierra Systems
Consultants Inc
fhirsch_at_rogers.wave.ca                          Vancouver, BC (604)688-1371

http://www.sierrasys.com/

Received on Fri Oct 17 1997 - 00:00:00 CDT