I am currently facing a strange problem...

Check out this code...

	oConnection = CreateObject("adodb.connection")
	with oConnection
		.Provider = "MSDAORA"
		.ConnectionString = "Persist Security Info=False;Password=quest;User ID=quest;Data Source=TJM"
		.Open
	endwith
	
	oCommand = CreateObject("adodb.command")
	with oCommand
		.ActiveConnection =  oConnection
		.commandtext = "GetStatus"
		.CommandType = ADCMDSTOREDPROC
		.Parameters.append(.CreateParameter("RETURN_VALUE",3,4,0))
		.Parameters.append(.CreateParameter('p_mainkey',adVarchar,adParamInput,10,'0000000046'))
		.Parameters.append(.CreateParameter('p_module',adInteger,adParamInput,1,1))
		.Execute
	endwith
	
	?oCommand.Parameters(0).Value

The strange part is that as soon as I execute this code I get to the lines..
.CommandType = ADCMDSTOREDPROC

As soon as I do this the parameters are appended to the command automatically after a split second delay. So after the parameter appends I have 6 parameters...

This only happens on Oracle but not SQL Server. I don't mind it but I need
it to work in a consistant way if possible...

Anyone know how to disable this? I find it strange since the
parameters.refresh doesn't work?!?!


The other problem is oracle does not like the parameters with names like
@p_mainkey is there a different syntax I can use on SQL Server because it SUCKS
having to hardcode two methods for each server...