Congrats. I knew I forgot the @ sign.

See PM, BTW.

>Hi Sergey, Naomi,
>
>Got it to work, I think you need the following
>
>1) Initialize the variable like you mentionned earlier
>2) Variable need to be PRIVATE
>3) Parameter need to be sent by reference with @
>
>
>

>PRIVATE P1,P2,P3,P4,P5,P6,P7,P8,P9,P0 AS Number
>STORE 0 TO P1,P2,P3,P4,P5,P6,P7,P8,P9,P0
>STORE NULL TO P1,P2,P3,P4,P5,P6,P7,P8,P9,P0
>
>
>TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 15
>{CALL ESC60.MOVE_PATIENTS_MAINT ('MTL',									'<<THISFORM.PNO>>',
>	'QC',
>	'9000',
>	'<<C_Import.PATNO>>',
>	'<<THISFORM.PNO>>',
>	'QC', 
>	'<<C_Import.CNO>>', 
>	'<<C_Import.PATNO>>',
>	?@P1, ?@P2, ?@P3, ?@P4, ?@P5, ?@P6, ?@P7, ?@P8, ?@P9, ?@P0 ) }
>ENDTEXT
>		
>lnResult = SQLEXEC(THISFORM.oESC.DataObj.ConnectHandle,lcSQL)
>

>
>
>Re: CALLING ORACLE SP WITH PARMS Thread #1389524 Message #1389631