oracle stored procedures 1

[Ravala]

We are using VB as Front-end and Oracle DB as back-end.
I know there is a suggestion to use the oracle procedures for modifying data. But it's so simple to use ADO and work with data thru VB objects.
What is the best way and why?

thanks.

 

[fredericofonseca]

Using stored procedures with ANY database can be much faster and is can give more security.

Besides there are things that you can do in one SP, but you would need a few pages of VB with ADO to do.

There's not a best way. It will depend on what you are doing with each bit of SQL.
Just to select a name from a table plain SQL is fine.
If you are building a recordset from several tables, and issuing case statements to convert/cast fields depending on the value of some of the fields of the tables being retrieve on the SP, then a SP IS the way to do it.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com