Parameter having a spave - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Parameter having a spave

Author

Topic

siprem
Starting Member

6 Posts

Posted - 2008-12-16 : 01:19:15

Hi All,
I have a parameter which has a space . How can I call a procedure by passing the parameter.eg

declare @flag int
declare @Filename VARCHAR(2000)
Set @Filename='F:\Import\RawData\DataBase_Txt\Oracle_UAM_418 (3).txt'
exec [TUAM].[dbo].sp_ValidateFooterCount @Filename,@Flag=@flag OUT

error message:

Msg 4860, Level 16, State 1, Line 1
Cannot bulk load. The file "F:\Import\RawData\DataBase_Txt\Oracle_UAM_418 " does not exist.

The actual file name is
F:\Import\RawData\DataBase_Txt\Oracle_UAM_418 (3).txt
Which has a space in between. Ho can I pass this file name to he procedure?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-16 : 01:25:20

i think problem is in your procedure.there you've declared parameter to be of length 50 but passed value contain more than 50 characters

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=116325