i appreciate if someone could guide me how to execute my pl/sql from vb. i try to use this command
below, it can run but in a half way of executing it have error -- invalid sql statement. When i run manually at
sqlplus, there is no any problem. Attached is my store block for reference. i'm really not sure whats have goes wrong. izit vb return timeout or there is some other efficient approach in calling store block from vb?

thanks alots

Dim lrs As ADODB.Recordset
Dim lsql As String

lsql = "update_transactionsummary('01-jan-2001','31-dec-2001','01-jan-2001','31-dec-2001')"
Cn.Execute lsql