Passing a value to a PL/SQL cursor

From: <dennishancy_at_eaton.com>
Date: Wed, 15 Nov 2000 18:32:15 GMT
Message-ID: <8uukrf$j3o$1_at_nnrp1.deja.com>


[Quoted] In a PL/SQL package, I have a cursor with one argument being passed to it. In typical Oracle fashion, I have the following lines set up.

open TheCursor(value);
fetch TheCursor into TheVariable;
close TheCursor;

I want "value" to be whatever the user types into a text box on an HTML form.

Assuming the form name is called TheForm, and the field name is called TheField, can someone tell me what the syntax is for this?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 19:32:15 CET

Original text of this message