Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to debug procedure with parameters

710564Jul 8 2009 — edited Jul 10 2009
I have created following dummy procedure to reproduce my problem

create or replace
procedure dummy_proc (p_no number, p_name varchar2)
is
v_date date;
begin
select sysdate into v_date from dual;
end;

I am following these steps for debugging
1. Open procedure in edit mode
2. Compile it for debug with an icon “compile for debug”
3. Add breakpoint on select.
4. Click on lady bug icon to start debugging.
5. Parameter window pop-up with following pop-up error message i.e.

An error was encountered performing the requested operation:
Fail to convert to internal representation
Vendor code *17059*

What I understand about problem is:
It is related to data type conversion of parameters. When Oracle SQL Developer tries to create anonymous PL/SQL block for debugging any procedure with parameters it does not able to translate parameters data types properly. I have checked Tool--> Preferences -- > Debugger but did not find any help. Any one who could able to solve this issue?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on Jul 8 2009
12 comments
1,808 views