Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invalid SQL Statement??!?!?

Status
Not open for further replies.

GDX

Programmer
Jun 4, 2000
186
US
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
 
Gordon,

Looks like you are posting in the wrong forum. This is Microsoft SQL Server NOT Oracle. Try Oracle: Oracle release 8 & 81 forum. (Do a Keyword search on Oracle and select 'Find a Forum')

-Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top