I am trying to run a stored proc on Oracle using VB4.
I can connect to the database using
set db = opendatabase ("", false, false, connnect$)
But when I try:
PROC_NAME AS STRING, NAME AS STRING, CATID AS INTEGER
PROC_NAME = "BEGIN ADDCUSTOMERINFO ('" & NAME & "'," & CATID & "); END;"
Noofrows = db.ExecuteSQL (PROC_NAME)
I get an error saying "Function marked as restricted or ..uses OLE type not supported by VB"
The oracle stored procedure does nothing apart from inserting a record in a table. it works properly from SQL Plus. Also it DID WORK with VB4 and then all of a sudden it started giving this error.
I can't even execute an action query using db.Execute ..the error is "Invalid Action"!!!!
The tables, database belong to me and I have all rights and priviledges. I have checked the syntax of my code umpteen times (its correct!!).