I'm not positive, but it looks like you are trying to create a record set
from a procedure that does not return one. If you simply want to execute
the procedure, use a command object.
"Hon" <yicng_at_mediaone.net> wrote in message
news:ujbS7.16478$g96.238906_at_typhoon.mw.mediaone.net...
> Hi, I was trying to execute the Oracle store procudure from VB with the
> following code :
>
>
> Private Sub Command1_Click()
> Dim strSQL As String
>
> strSQL = "begin is421g1.st1();end;"
> 'strSQL = "select * from sbt;"
> Adodc1.RecordSource = strSQL
> Adodc1.Refresh
>
>
> And I had an error message when I click on the botton, it shows "
Operation
> is not allowed when the object is closed". I can't figure it out what it
> is, but when I check the result in the Oracle, it did run the prodecure.
> Can't figure what's wrong. The store procedure named: ST, and the UserName
> is IS421g1.
>
> If anyone know why or have any better way to call the proceudre, please
drop
> me a line.
>
> Thanks
>
> Hon
>
>
Received on Thu Dec 13 2001 - 19:44:42 CST
