Results 1 to 1 of 1
Thread: Execute PL/SQL at VB (VB 6)
2001-10-22, 01:41 #1
- Join Date
- Jul 2001
- Thanked 0 Times in 0 Posts
Execute PL/SQL at VB (VB 6)
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?
Dim lrs As ADODB.Recordset
Dim lsql As String
lsql = "update_transactionsummary('01-jan-2001','31-dec-2001','01-jan-2001','31-dec-2001')"