• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

debugging a proc

hi guys
I have a store proc which is inserting rows in TABLE ' person_table '

PROCEDURE insert_person
    ( input_insert             person_type   --person_type is a  TYPE
    , po_success     OUT NOCOPY CHAR
    )
IS

c_program_name CONSTANT VARCHAR2(64) := c_package_nm||'.insert_person';

bulk_errors EXCEPTION;
PRAGMA EXCEPTION_INIT (bulk_errors, -24381);

BEGIN

    po_success := 'Y';  -- i put a break point here
    FORALL i IN input_insert.FIRST..input_insert.LAST   -- i put a break point here
    SAVE EXCEPTIONS
        INSERT INTO person_table  -- i put a break point here  
            ( id
            , name            
            , lst_updt_timestamp            
            )
        VALUES
            ( person_map.NEXTVAL                    
            , input_insert(i).person_name
            , SYSTIMESTAMP
           
            );


EXCEPTION
  WHEN bulk_errors THEN
    FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT
    LOOP
        person_exception_error_log
            ( pi_error_type     => 'FATAL'
            , pi_program_name   => c_program_name
            , pi_program_type   => c_program_type
            , pi_error_code     => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX
            , pi_error_msg      => SQL%BULK_EXCEPTIONS(i).ERROR_CODE
            );
    END LOOP;

    po_success := 'N';

  WHEN OTHERS THEN
    person_exception_error_log  
        ( pi_error_type     => 'FATAL'
        , pi_program_name   => c_program_name
        , pi_program_type   => c_program_type
        , pi_error_code     => SQLCODE
        , pi_error_msg      => SQLERRM
        );

    po_success := 'N';
   
END insert_person;      


I put couple of break points but when my java program calls this store proc it doesnt stop at the break points.
In sql developer , From top menu I clicked on 'Debug' -->Debug Person_Operations Body.

any idea what i am doing wrong?

thanks
0
royjayd
Asked:
royjayd
2 Solutions
 
slightwv (䄆 Netminder) Commented:
I believe SQL Developer will only debug in the current session.  I don't think you can use debug when calling from an external program.
0
 
DavidSenior Oracle Database AdministratorCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now