Hi,

At November 21, 2003, 14:47, cbrachomi wrote:

> SET TERM # ;
> CREATE PROCEDURE CREATE_USER(USR_NAME VARCHAR(15), NOMB VARCHAR(25),
> APELL VARCHAR(25), PWD VARCHAR(15))
> AS
> BEGIN
> SHELL 'gsec -user sysdba -password xxxxx -add cbrachom -pw
> cbrachom -fname Carlos -lname Bracho';
> END #
> SET TERM ; #

> And this is the error message:

> Statement failed, SQLCODE = -104

> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 4, char 10
> -'gsec -user sysdba -password xxxxx -add cbrachom -pw cbrachom -fname
> Carlos -lname Bracho'

> Same problem, how can I fix it?

Are you using Firebird or Interbase, and which version? SHELL has
never been a command in Firebird(I don't know about IB 7+ since I
don't use it). Why don't you create a UDF that would call GSEC with
the parameters that you want. And, have a SP call that UDF.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)