Re: SQL (oracle) and ASP stored procedure question

U can very well do the operations for the ORacle backend.. About the statement (or maybe what u have read ..) i have no idea as i havent tried much interaction with oracle..in the matter of Stored procedures. But i have passed select queries to Oracle procedures.. and got the results..
BTW, I think that passing the parameters to an Oracle procedure has one imp thing.. the HTML element name should match the Oracle SP parameter name.

Max Coppin wrote:
>
> Thanks in advance to anyone that can help.
>
> I am a student trying to create an asp front end for an oracle database. My
> plan was to create a series of stored procedures to insert, delete and
> select data etc. I have hit a few problems though.
>
> Firstly i have read in some places that oracle will not allow a select
> statement as a stored procedure without any parameters or an into statement
> following it, is this true? if so is there any way around it without coding
> in asp.
>
> secondly i have not yet got a procedure to take parameters from my asp pages
> yet, can someone please help me
>
> thanks again
>
> Maxcoppin_at_btinternet.com

-- 
Peace and Love,
Anand Venkatraman
SJM - VV&T Analyst
ppG76, BT Meadowside, 
Brindley Way,
Hemel Hempstead, 
Hertfordshire, UK
HP3 9XJ

Office 		01442 43 6176 
Residence 	020 8537 1058 
Fax  		01442-43 6503
Mobile 		078 1044 6152

Email		anand.venkatraman_at_bt.com 
		anand.venkatraman_at_mahindrabt.com

Yahoo ID(s)	don_espero
		cool_ashan