Having a strange problem, when calling an Oracle

Procedure with Output Parameters.  The output paramter

if CHARACTER returns ????????????????.



Initially, the right values were being returned.  Then

recently we changed the IIS Server to a new machine. 

I am not sure if the problem is related to the server

change.  But it might be an environment setup problem.



Below is an example of my code,



Procedure Name:

my_prc(p_num out number, p_msg out varchar2);

I executed the Procedure in SQL Plus and it returns

correct values.



ASP:

Set comm = Server.CreateObject("ADODB.Command")

Set comm.ActiveConnection = objConn

comm.commandtype = 4   

comm.commandtext = "my_prc"

set param = comm.Parameters

param.append comm.createparameter("retnum",3,2)

param.append comm.createparameter("retmsg",8,2)	

comm.execute

Response.Write comm("retnum")

Respnose.Write comm("retmsg")



comm("retnum") will display the correct value which

will be a number,

But comm("retmsg") will display ???????????????



Regards,



Khaled Ghoneim



__________________________________________________

Do You Yahoo!?

Get email at your own domain with Yahoo! Mail. 

http://personal.mail.yahoo.com/

I'll bet your problem is with out-of-date drivers.

Check MS and Oracle for the correct DLLs.



----- Original Message -----

From: "Khaled Ghoneim" <kghoneim@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, January 18, 2001 7:10 PM

Subject: [asp_databases] OUTPUT Parameter returns ?????????????





>

> Having a strange problem, when calling an Oracle

> Procedure with Output Parameters.  The output paramter

> if CHARACTER returns ????????????????.

>

> Initially, the right values were being returned.  Then

> recently we changed the IIS Server to a new machine.

> I am not sure if the problem is related to the server

> change.  But it might be an environment setup problem.

>

> Below is an example of my code,

>

> Procedure Name:

> my_prc(p_num out number, p_msg out varchar2);

> I executed the Procedure in SQL Plus and it returns

> correct values.

>

> ASP:

> Set comm = Server.CreateObject("ADODB.Command")

> Set comm.ActiveConnection = objConn

> comm.commandtype = 4

> comm.commandtext = "my_prc"

> set param = comm.Parameters

> param.append comm.createparameter("retnum",3,2)

> param.append comm.createparameter("retmsg",8,2)

> comm.execute

> Response.Write comm("retnum")

> Respnose.Write comm("retmsg")

>

> comm("retnum") will display the correct value which

> will be a number,

> But comm("retmsg") will display ???????????????

>

> Regards,

>

> Khaled Ghoneim