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
Messages: 4
Registered: January 2007
Junior Member

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.

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
Messages: 3727
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: Update statement
Next Topic: problem with cursor
Goto Forum:

Current Time: Wed Aug 23 10:52:45 CDT 2017

Total time taken to generate the page: 0.04586 seconds