Varchar2

[Former Member]

Hi All,

Does XI support varchar2 ,which oracle supports.

If I am passing parameters to stored procedure in Oracle where the data type defined is varchar2. Can I pass type values in stored procedure data type as varchar2 ?

Thanks

[justin_santhanam · Accepted solution]

Hi,

Refer the thread :

Best regards,

raj.

[Former Member · Accepted solution]

So basically VARCHAR is same as varchar2(10) in oracle?

Am I correct?

Thanks,

[justin_santhanam · Accepted solution]

Hi,

I never tried, but the discussion say's so, it has to be correct.

Best regards,

raj.

[Former Member · Accepted solution]

That is fine.

Awarding your points.

Thanks.

[Former Member · Accepted solution]

Hey

>>So basically VARCHAR is same as varchar2(10) in oracle?

In oracle,no its not,but in XI if you define the type as string,it will handle both VARCHAR and VARCHAR2.

Thanx

Aamir suhail

[Former Member · Accepted solution]

I will define as string in data type.

But when I map I will map it to a constant, where the constant would be VARCHAR.

Thanks

[Former Member · Accepted solution]

hey

>>But when I map I will map it to a constant, where the constant would be VARCHAR.

yes

Thanx

Aamir