Hello: You should use char type to save space>>>> but you can do : sqlplus>select A || ' ' || B from table: Result: --> A B Good luck .NET PROGRAMMER ASP.NET +

Hi there! When I insert a blank space (' ') into a varchar2 field via an OracleCommand, the result saved is an empty string. And, of course I really need this

Could you describe the errors, maybe I can help you. Regards. Ulises ... From: AspNetOracle@yahoogroups.com [mailto:AspNetOracle@yahoogroups.com] On Behalf Of

Thansk, I will test your code, The package I wrote is not working and gave me some errors: CREATE OR REPLACE PACKAGE Tc_Package AS TYPE T_CURSOR IS REF CURSOR;