Re: Calling stored procedures from Visual Basic for appl?

	It is possible to do the followinig using ODBC (from Access, Visual
	Basic, etc.)

	1) U can call a strored procedure on the Oracle DB, pass
	parameter and execute them on Oracle
	2) Right now there is no way to get the results from the
	stored procedure back to the client. Unless, U use a temporary
	table, put the result in that table, & later exectue a select
	on that. Caution - expecially in multiuser enviornment.

	3) To do this U have to create an anonymous block 
	eg: Begin procedure_name (Values1, values2,...) End
	4) The above can be created on the fly in ur Access/Visual
	basic procedures.

	Hope this helps.

	-anand

--
Anand. V. J				Internet:fbap3120_at_leonis.nus.sg