facebook

compiling procedure error

  1. MyEclipse IDE
  2.  > 
  3. Off Topic
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #269516 Reply

    fletchdcuk
    Member

    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

    #269543 Reply

    Riyad Kalla
    Member

    fletch,
    I’m not sure I follow… are you defining an Oracle stored procedure in the DB? If so, how is that related to Hibernate?

    #269579 Reply

    fletchdcuk
    Member

    Hi
    I am editing a stored procedure in oracle 10g. I’ve added the previous create or replace statement (as an example) as when i run this in Hibernate i dont get any relevant oracle error returned. The Function upper_string has not be define. sqlplus returns a descriptive error as does toad and sql developer telling me that the function has not been defined. Hibernate just gives me an generic error that the error exists on line 1 which is not Helpful and incorrect

    Thanks

    #269589 Reply

    Riyad Kalla
    Member

    Moving to OT > Soft Dev

    This sounds like a hibernate-specific issue, I’m not sure how to help with this unfortunately.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: compiling procedure error

You must be logged in to post in the forum log in