Hi,

I am getting an error trying to create a synonym to an oracle 11g Stored Procedure.

PROCEDURE pHLMain( cMain IN OUT HLMain_type,
pDia IN VARCHAR,
pMes IN VARCHAR,
pAno IN VARCHAR,
pDiasUteisMTD IN NUMBER,
pDiasUteis IN NUMBER,
pRegional IN VARCHAR := '00');



Return:

type recHLMain is record
(
"MODEL" varchar2(200)
,"SEGMENT" varchar2(200)
,ORDEM number(10)
,FSSMesAntFM number(10)
,FSSObj number(10)
,FSSMesAtu number(10)
,FSSvsOBJ number(10)
,TISMesAntFM number(10)
,TISObj number(10)
,TISMesAtu number(10)
,TISvsOBJ number(10)
,FISMesAntFM number(10)
,FISObj number(10)
,FISMesAtu number(10)
,FISvsOBJ number(10)
,VESeg number(10)
,VEPerform number(10)
,VOLMesAntFM number(10)
,VOLMesAtu number(10)
,VOLvsOBJ number(10)
,OBJFord number(10)
,OBJInd number(10)
,ObjIndSegTOT NUMBER(10)
,OBJTOTALIND number(10)
,VOLTOTALINDFM number(10)
,VOLTOTALINDMTD number(10)
,VOLSEGINDMESANT number(10)
,VOLSEGIndMTD number(10)
,numProgProd varchar2(10)
);



Can anyone help me?

This message has been edited. Last edited by: <Kathryn Henning>,

SET SQLENGINE = SQLORA

SQL SET SERVER bzmkttst

SQL SQLORA
ex svstst.svs6200k.pHLMain(cMain,’01’,’03’,’2015’,10,21,’00’);

TABLE FILE SQLOUT
PRINT *
IF READLIMIT EQ 10
END


This is other procedure and the error:
(FOC1400) SQLCODE IS 6550 (HEX: 00001996)
: ORA-06550: line 1, column 37:
: PLS-00103: Encountered the symbol "¿" when expecting one of the
: following:
: ( - + case mod new not null
:
: continue avg count current exists max min prior sql stddev
: sum variance execute forall merge time timestamp interval
: date
: pipe
: L (FOC1405) SQL PREPARE ERROR.

WebFOCUS 8.1.05 / APP Studio

This stored procedure is current being used by Crystal Reports and we do need to migrate it to WebFOCUS.

SET SQLENGINE = SQLORA

SQL SET SERVER bzmkttst

SQL SQLORA

ex svstst.svs6200k 'var1', 'var2', 'var3', var4, var5;

TABLE FILE SQLOUT
PRINT *
END


I will develop some reports now but I will need those masters files later.