RE:Procedure

[Anhaus, Thomas]

>As I can execute a procedure within another one. 
>CREATE dbPROC SP_ACF_NUEVO_AUXILIAR 
>(in CODEMPRESA VARCHAR(4), 
>in DESLARGA VARCHAR(100)) 
>AS 
>var CODIGOAUXILIAR character(6) 
>Begin 
>EXEC SP_ACF_I_MAE_AUXILIAR CODEMPRESA, DESLARGA, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'S', NULL, 'N', NULL, NULL,
'EN', out CODIGOAUXILIAR 
>select CODIGOAUXILIAR 
>End; 
>It sends the following error to me: 
>Native error: -5016 
>text:[sapag][sqlod32dll][sapdb]General error-5016 POS(132) 
>Missing delimiter: ;. 
>Thanks. 
Within a db-procedure a db-procedure must be called as sql-statement, i.e.

CREATE DBPROC SP_ACF_NUEVO_AUXILIAR 
(in CODEMPRESA VARCHAR(4), 
in DESLARGA VARCHAR(100)) 
AS 
var CODIGOAUXILIAR character(6) 
Begin 
CALL SP_ACF_I_MAE_AUXILIAR (:CODEMPRESA, :DESLARGA, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'S', NULL, 'N', NULL, NULL,
'EN', :CODIGOAUXILIAR); 
End; 
Thomas
---
Thomas Anhaus
SAPDB, SAP Labs Berlin