Hi, I have this stored proceure. I inserted data into the table. I want to get data back and this is the stored procedure. I tested using java. My method runs without errors but i dont get any data when I print out. I want to test this procedure in toad to see if it is getting data at all. userid=sdeep linesetid =1 fublineid is null for now
how do I test this procedure in toad and see if it is really getting data.
[ August 14, 2006: Message edited by: Lasse Koskela ]
I spent some time trying to define variable in Toad but without any success. Looks like Toad doesn't support SQL* Plus features like define/print/variable.
One way you can test the procedure is to execute the procedure in the anonymous block by defining local variables for the return values and using dbms_output.put_line. This is more work than using SQL* Plus. The other way is to debug (using break points) the procedure itself and just make a call to the procedure.