Invalid SQL Statement what the!

[GDX]

Anyone know why im getting this error? I am trying to execute the SPROC im on an Oracle 8i Server:

Thanks....

Dim oConn As New ADODB.Connection
oConn.Open "Provider=OraOLEDB.Oracle;Data Source=xiacon.xiacon.com;User Id=intrak;Password=intrak;"
LineRun = "execute intrak.INVENTORY_POST('Xiacon','R','CTL006','003','02-715-250','RL-1283-1000','+','2500','EA','RENCO','','','','01092002','1','2500','BOX');"
oConn.Execute LineRun Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[raj28]

Hi GDX,
Just replace call in place of execute .
i.e
Dim oConn As New ADODB.Connection
oConn.Open "Provider=OraOLEDB.Oracle;Data Source=xiacon.xiacon.com;User Id=intrak;Password=intrak;"
LineRun = "call intrak.INVENTORY_POST('Xiacon','R','CTL006','003','02-715-250','RL-1283-1000','+','2500','EA','RENCO','','','','01092002','1','2500','BOX');"
oConn.Execute LineRun

Hope it solves ur problem -
Raj28