dotted string in sp calls

Hi there!
why do I get an error when I call a sp wich contains a dotted argument
?
ex:
exec netreport.ps_load_data 'arg1','arg2.arg2'
Error ---^
I got this error :
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.
I get the same error with '\' char..
any idea?
++
VinceHi
Can you post the DDL?
John
"Vince .>" <vincent@.<remove> wrote in message
news:omm2515nqvr132fi8o3ai8im3bv01pl3td@.
4ax.com...
> Hi there!
>
> why do I get an error when I call a sp wich contains a dotted argument
> ?
> ex:
> exec netreport.ps_load_data 'arg1','arg2.arg2'
> Error ---^
> I got this error :
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> I get the same error with '' char..
> any idea?
> ++
> Vince
>|||On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:

>Hi
>Can you post the DDL?
>
hum..sorry...i'm new to SQLServer, so what is a DDL? :)
Vince|||Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
AMB
"Vince .>" wrote:

> On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
>
> hum..sorry...i'm new to SQLServer, so what is a DDL? :)
> Vince
>|||DDL = Data Definition Language..
The error may not be in calling the procedure, but instead
in the procedure being called.. Create a dummy procedure
that does nothing and see if you have a problem calling it
with a value that contains a period.
"Vince .>" wrote:

> On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
>
> hum..sorry...i'm new to SQLServer, so what is a DDL? :)
> Vince
>