Re: Can I execute a PL/SQL Procedure from an ASP Page ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 15 Jun 2003 14:06:04 +0100
Message-ID: <3eec6f0c$0$960$cc9e4d1f@news.dial.pipex.com>

You will want to create an ADO command object and set the command text to the name of the procedure and add parameters if necessary.

something like (NB this is off the top of my head so won't work without reading up on ADO)

set cmd = Server.CreateObject("ADODB.Command")

with cmd

    .parameters.add "uname", advarchar
    .connection = myConn
    .commandtext= "myProc"

end with

cmd.parameters("uname").value = strUsername ' from form

cmd.executenonquery

set cmd= nothing

Searching google "execute stored procedure asp" also turns up some likely examples.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"B.Dimple" <bdimple_at_myway.com> wrote in message
news:eb271e19.0306140934.32c61d91_at_posting.google.com...


> I am sorry if this is question is too basic, or posted to the wrong

> Group.

>

> You can be sure I will appreciate any and all advice and suggestions.

>

> I have created an entry form in HTML for a new User to register and

> I'd like to store the new User details in a table in an Oracle 9i

> database using a PL/SQL Procedure.

>

> It sounds simple enough but I don't know how to execute a PL/SQL

> Procedure from the entry Form.

>

> Do I use the action of the Form ?

>

> Or what ?

>

> TIA

>

> B.Dimple

> Junior DBA

Received on Sun Jun 15 2003 - 08:06:04 CDT