Hi, i wan to test the integration server
all ready copy the JDBC ojdbc5.jar to Visual Dial Plan and Integration Server
in the integration Server i start database server
but i get error on ORACLE
note this Query WOrk Fine on PLQ/SQL and Toa
on SQL Builder
i have the next
Query
DECLARE NACCOUNT number(10);
BEGIN
Select T_UTILITIS.TCAP_MOUNT(Vis_Numcue,Vis_CURRENCY, To_Date(‘2013/07/28′,’yyyy/mm/dd’)) MOUNT
From TCap_Vista Where Vis_Numcue = :NACCOUNT And Vis_Status Not In (‘0′,’1′,’6′,’9’);
END;
/
Errors:
Executing query 1 of 3:
DECLARE NACCOUNT number(10);
An error occurred:
Failed to execute query: ORA-06550: line 1, column 27:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
:= ; not null default character
Executing query 2 of 3:
BEGIN Select T_UTILITIS.TCAP_MOUNT(Vis_Numcue,Vis_CURRENCY, To_Date(‘2013/07/28′,’yyyy/mm/dd’)) MOUNT From TCap_Vista Where Vis_Numcue = :NACCOUNT And Vis_Status Not In (‘0′,’1′,’6′,’9’);
An error occurred:
Failed to execute query: ORA-06550: line 1, column 186:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
;
Executing query 3 of 3:
END;
An error occurred:
Failed to execute query: ORA-00900: invalid SQL statement
