OLE DB
CLOSE
If a database stored procedure returns a result set, you must close
the stored procedure when processing is complete. The procedure remains
open until you close it, execute a COMMIT or ROLLBACK, or end the database
connection.
Do you have to retrieve all the rows?
You do not have to retrieve all rows in a result set to close a
request or procedure.
Example
Closing a procedure looks the same as closing a cursor:
|
1 |
CLOSE emp_proc; |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest