PHP code vs Stored Procedures

[joseomar]

Hi,

I have a couple of questions related to the use of oracle stored procedures from PHP.

First. Is it simple to call Oracle stored procedures from PHP. What is the best way of doing it? How are results passed back to PHP? Any examples out there?

Second. Are there any performance issues when calling stored procedures from PHP? or am I better off doing all the inserts/deletes/updates straight from PHP?

Your help is much appreciated.

Jose

 

[AnakinPt]

well, i use oracle but i don't use much procedures.

What i can tell you by my experience with other databases, you should use SP's when you need to do several operations in a row. This way, you only send one command to the Oracle and you only get one Result. This way is faster. But, as i told you before, i don't use much SP's in oracle, only in SQL Server. Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

 

[BB101]

To run a stored procedure you just use the query command but use "exec stored_procedure @param = 'parameters'"

Be sure to make sure text is converted to safe SQL text (' and " are annoying).

Stored procedures are faster than PHP because they work closer the data and within the SQL interpreter.

PHP has to make many calls to do simple data manipulation, SQL SPs are fast! --BB