Unable to debug procedure with parameters
710564Jul 8 2009 — edited Jul 10 2009I 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?