i am evaluating myeclipse as a toad replacement and am having problems compiling packages/procedures in hibernate. My issues is hibernate does not tell me where the error is or what it is
Thanks for your help
The following code is an example where the error does not show correctly
CREATE OR REPLACE procedure ONYX.TEST_PROC(
p_ship_to IN varchar2
) as
v_filter VARCHAR2(1000);
BEGIN
IF p_ship_to IS NOT NULL THEN
v_filter := v_filter || upper_string(p_ship_to);
END IF;
end;
the issue is with the upper_string function has not been declared – but why does hibernate not give this as an error? all i get is ORA-24344: success with compilation error ORA-06512: at line 1