How do you call an Oracle stored procedure that returns parameters?

[mbasimon]

I'm using VBScript. I need to call an Oracle stored procedure which accepts parameters and also returns parameters. I can't find anything useful when I search on the web, just wondering if anyone here knows how to do that and if they can give me a sample snippet that would be fantastic.

For the life of me I can't find any useful information on this !!

Thanks !!

 

[PHV]

I'd use an ADODB.Command object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mbasimon]

I've been trying ADODB but I can't get it to work. Do you have a working sample/snippet that you could paste? Thanks.

 

[wvdba]

here's a stored procedue that i use in oracle 10g

objConn.Open strConnection
	objCmd.ActiveConnection = objConn
	objCmd.CommandType = adCmdStoredProc

	objCmd.Properties("PLSQLRSet") = TRUE

	objCmd.CommandText = "pk_students.getstudents"

	objCmd.Parameters.Append objCmd.CreateParameter("param1", adVarChar, adParamInput, 10, v_studentid)
	Set objSearch = objCmd.Execute

cheers.

 

[mbasimon]

Thanks !!