October 22, 2015, 01:00 PM
Ricardo Augusto [SOLVED] Access an Oracle package/Stored Procedure
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>, November 02, 2015 02:21 PM October 22, 2015, 02:35 PM
Ricardo Augusto 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. October 23, 2015, 08:46 AM
Ricardo Augusto This stored procedure is current being used by Crystal Reports and we do need to migrate it to WebFOCUS.
October 23, 2015, 10:33 PM
Ricardo Augusto 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.