Home » SQL & PL/SQL » SQL & PL/SQL » Impact of changing Varchar to Varchar2
Impact of changing Varchar to Varchar2 [message #219310] Tue, 13 February 2007 23:31 Go to next message
siva_k
Messages: 4
Registered: January 2007
Junior Member
Hi,

I have read for SQL Reference Guide for 10g that the Varchar has been deprecated.

Is this deprecation valid for PL/SQL and PRO*C Datatypes also..?
If so then what would be the impact if the VArchar datatypes are changed to varchar2.


Thanks in advance.

regards,
Siva.
Re: Impact of changing Varchar to Varchar2 [message #219333 is a reply to message #219310] Wed, 14 February 2007 01:03 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
It only means as a datatype in a table - no impact on Pro*C. You can continue to fetch VARCHAR2 table columns into VARCHAR Structs in Pro*C.

Ross Leishman
Previous Topic: problem with cursor
Next Topic: FORALL and Bulk collect
Goto Forum:
  


Current Time: Sun Dec 04 06:29:48 CST 2016

Total time taken to generate the page: 0.12189 seconds