Also, what does the first few lines of your SP code look like? Are defining the IN parameter as a CHAR or VARCHAR2 with sufficient length to accept the incoming parameter?
>We are getting the following error on from our stored procedure. Here is the actual Visual FoxPro command and error we get back:
>
>VFP Command:
>lnRetVal = SQLEXEC(1, [{call GetNextVoterId("{516F893C-ADA0-40D9-98C6-912799670921}", ?@lcretval)}])
>
>Error returned
>Connectivity error: [Oracle][ODBC][Ora]ORA-06550: line 1, column 22:
>PLS-00114: identifier '{516F893C-ADA0-40D9-98C6-91279' too long
>
>
>Our first paramter will always be 38 characters.
>
>
>Any help would be greatly appreciated.
>
>TIA
>Mark
Mark McCasland
Midlothian, TX USA