How to Access an Oracle stored procedure with in asp

[kirankumar]

Hi<br>I want to accesss an oracle stored procedure from an asp page.I am trying to pass employee number and get the information about that number from emp table to display in my asp page.I am not familier with writing oracle stored procedures. So i need the code for the stored procedure and also how to pass the in and out parameters.<br>Thanks in advance for your help.<br>

 

[NickBulka]

As long as you're asking us to do all the work for you, are you going to share your paycheck with us?&nbsp;&nbsp;;-)<br><br>Seriously,&nbsp;&nbsp;this is not the place to get help on writing Oracle stored procedures.&nbsp;&nbsp;Try the Oracle or PLSQL forums.&nbsp;&nbsp;To get info on accessing the stored procedure from ASP, goto <A HREF="

http://www.actionjackson.com,&nbsp"

TARGET="_new">

http://www.actionjackson.com,&nbsp</A>;&nbsp;and

search on Oracle<br> <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[kirankumar]

Hi Nick,<br>I did not ask you to write the full code for the stored procedure. I just want to know how to declare the parameters&nbsp;&nbsp;and use them in asp.<br>Anyway i got it. <br>Thanks.<br>Kiran

 

[hmcheung]

Hi kirankumar,
I have to access an Oracle stored procedure using ASP, too. It'd be very kind of you if you can show me the code. Thanks! Please visit my WebCam!!

http://i.am/andycheung

 

[hblackorby]

To run any procedure in ASP, you are just passing a SQL string to your database to call that procedure. It is the same with any other database with a stored procedure.

For instance:

SQLstring = &quot;LOOKUP&quot;
ConnectionObject.Execute SQLstring

or

set recordsetobject = ConnectionObject.Execute SQLstring

if you are returning a recordset.

How you word your SQL string with optional paramaters is something you need to learn from an Oracle help area, not here. But it is just an SQL string as far as ASP is concerned. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO