I have a question relating Delphi and Oracle in the execution of procedure.
Next: I have a bank procedures that are currently called by another "master procedure" (let's call it).
However, I have to start all of Delphi, Application.
But the parameters that are passed, are types of the bank, and I do not know how to pass this parameter in Delphi.
Does anyone have an idea?
I will give an example:
Below are my types (somewhat summarized)
CREATE OR REPLACE
TYPE TCALCIPTU AS OBJECT
(
ID_IMOVEL NUMBER,
ID_LOTE NUMBER,
EXERCICIO NUMBER,
AREA_LOTE NUMBER,
FATOR_PROFUNDIDADE CHAR(1),
VALOR_FATOR_PROFUNDIDADE NUMBER,
FATOR_DEPRECIACAO CHAR(1),
AREA_TRIBUTAVEL_LOTE NUMBER,
VALOR_M2_TERRENO NUMBER,
ID_IMOVEL_UNIDADE NUMBER,
MEMBER PROCEDURE INICIAVALORES(PCALCIPTU IN OUT TCALCIPTU)
)
CREATE OR REPLACE
TYPE "TDADOSIMOVELUNIDADE" AS OBJECT
(
VALOR_VENAL_TERRENO NUMBER,
ANO_CADASTRO NUMBER,
ANO_CONSTRUCAO NUMBER,
AREA_TRIBUTAVEL NUMBER,
FRACAO_IDEAL NUMBER,
ID_IMOVEL_TIPOLOGIA NUMBER,
ID_IMOVEL_TIPO_USO NUMBER,
ID_IMOVEL_padrão_ACAB NUMBER,
VALOR_VENAL_UNIDADE NUMBER,
ALIQUOTA_UNIDADE NUMBER,
VALOR_M2_CONSTRUCAO_DESC NUMBER,
VALOR_M2_CONSTRUCAO NUMBER,
VALOR_FATOR_DEPRECIACAO NUMBER,
ID_IMOVEL_UNIDADE NUMBER,
ID_CARACT_IMOB_SUBITEM NUMBER
)
/
CREATE OR REPLACE
TYPE "TLISTAIMOVELUNIDADE"
AS TABLE OF TdadosimovelUnidade;
/
PROCEDURE Get_Valor_m2_Construcao (
PCalcIPTU IN TCalcIPTU
, PListaImovelUnidade IN OUT TListaImovelUnidade
, PIndexLista IN NUMBER
);
Thanks from now
Henrique Machado Muller