invalid sql statement

S

scott

Hi,

I have an VB application talking to oracle. I am trying to use
disconnected recordsets. Oracle procedures are in place. When i use the
statement:
Set rsData = cn.Execute(strSQL, , ExecDirect)

Where rsdata is an adodb recordset and
strsql= EXEC HSP_FEED_LOOKUPSCOMPTYPVAL ('Prospect', '1-SS0', NULL,
NULL, '1-1DQ-3746')

HSP_FEED_LOOKUPSCOMPTYPVAL is the procedure name that has the above
parameter values.

The same sql statement runs merrily in oracle but i cannot execute it
from vb.

Please help.

Thanks
 
Top