Re: Passing a value to a PL/SQL cursor

I'm really not sure what you are trying to do.

What is your web server? Is it OAS or WebDB and are you using the pl/sql toolkit? If that's the case wouldn't this be inside of pl/sql stored program unit, like a package or a procedure?

I can send you example code of some pages I developed to do this. It didn't take a lot of time to get it working though. If you still need the pages, send an email.

<dennishancy_at_eaton.com> wrote in message news:8uukrf$j3o$1_at_nnrp1.deja.com...
> 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 22 2000 - 00:11:39 CET