Re: Using ADO, Call a Stored Procedure with Variables

Hi,

I would double check with the DBA what order the paramaters need to be
passed to the DB.

It sounds to me as if you are passing it a string when it is expecting
an integer.

So double check this out first then we will progress further.

Regards,
Pace


eric.vogelpohl@xxxxxxxxxxxx wrote:
I wrote a WMI script to populate some server info into a DB. Our DBA
wrote the SP.

So now i want to run the exact same SP update from within my WMI script

- this is failing - what am i doing wrong?


I know i'm connecting to Oracle just fine - i can run a adodb.recordset

and parse thru entries - no prob.


i get an error from the Ora provider telling me that "non-numeric value

where numeric was expected..."


This SP provides not returned data - it just takes inputs.
_________________
strConnection = "Provider=OraOLEDB.Oracle;Data Source=CSDD;User
Id=myuserid;Password=mypassword"
Set conn = CreateObject("ADODB.Connection")
conn.Open strConnection


Set Comm = CreateObject("ADODB.Command")


Comm.ActiveConnection = conn
Comm.CommandText = "BEGIN CSD.UPDATE_WINDOWS_SERVER('EMTTULDMZWEB01',
254, 3, 'PowerEdge 2450', 200, 1024, 2, 993, '6/1/2001', 'DMZ',
54508896256, 5858009088);END;"
Comm.Execute


conn.Close
Set conn = Nothing
Set Comm = Nothing
_____________________________


This command below runs perfectly well from the SQLPlus > prompt - so i

think the stored proc is working on the Oracle side:
____________
SQL Plus userid/password@DB


EXEC CSD.UPDATE_WINDOWS_SERVER('EMTTULDMZWEB01', 254, 3, 'PowerEdge 2450', 200, 1024, 2, 993, '6/1/2001', 'DMZ', 54508896256, 5858009088)


____________

.

Relevant Pages

  • Calling an Oracle Stored Procedure in VB Script
    ... I wrote a WMI script to populate some server info into a DB. ... I know i'm connecting to Oracle just fine - i can run a adodb.recordset ... Set conn = CreateObject ... Set Comm = CreateObject ...
    (microsoft.public.scripting.vbscript)
  • Using ADO, Call a Stored Procedure with Variables
    ... I wrote a WMI script to populate some server info into a DB. ... I know i'm connecting to Oracle just fine - i can run a adodb.recordset ... Set conn = CreateObject ... Set Comm = CreateObject ...
    (microsoft.public.data.ado)
  • Cant connect to oracle
    ... I am trying to connect to Oracle 9i release 2 from my IIS ... on win 2000 pro development machine. ... I have oracle 8.1.7 client which has the OO4O installed. ... Set Conn = Nothing ...
    (microsoft.public.inetserver.asp.db)
  • get data from Sybase database by code not pass-through query
    ... I am trying to set up a conection to a Sybase database through an ODBC ... connection. ... For Oracle I would use the following: ... Set conn = New ADODB.Connection ...
    (microsoft.public.access.modulesdaovba)
  • Convert select statement to a stored procedure
    ... convert to a stored procedure on an Oracle 9i schema: ... Set conn = Server.CreateObject ... My Oracle procedure is: ... CREATE OR REPLACE PROCEDURE TestGetData (i_FIRSTNAME IN NVARCHAR2) AS ...
    (comp.databases.oracle.misc)