![]() ![]() When calling an Oracle stored procedure, all input and output data is passed as arguments to the procedure. This HowTo provides examples of common operations with stored procedures. The PHP OCI8 extension provides support for calling stored procedures, allowing you to bind parameters to a procedure statement in the same way as you would to a normal SQL statement, as well as access to result cursors and Oracle collections. ![]() By encapsulating that process in a single stored procedure, traffic between the client and database is reduced while an operation that would normally require multiple steps in the client code is reduced to a single database call. If you consider the code normally required to manage a many-to-many relationship between tables, performing an update to existing data can often involve three separate queries. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |