This error occurs when you try to Select Into a variable, but your select returns more than one row.
This error occurs when you try to Select Into a variable, but your select returns more than one row. Check these lines in your script: 165 and 260 (as displayed in the stacktrace of the error). To output your parameters dbms_output should work.
Test the following script: Set Serveroutput On Begin dbms_output. Put_line('Test'); End.
As I said, I have an idea about the error, but I need to see the parameters of a function. – CC. Apr 27 '10 at 14:04 I tryied with dbms_output.
Put_line but it does not display anything. At the beginning I have set serveroutput ON; – CC. Apr 27 '10 at 14:08 That suggests you're not reaching the point you've put your debug, so you could put put_line calls before the call and at earlier points.
Also when running from SQL*Plus, the line numbers reported in the error are within the PL/SQL code, not line numbers of the SQL file itself, so you need to be looking at 165 and 260 lines after your declare. – Alex Poole Apr 27 '10 at 14:26 Ok, I got it, using dbms_output. Put_line, I can see the output.
Thanks everybody. – CC. Apr 27 '10 at 14:28 You're welcome.
I just edited my question to explain dbms_output when you posted your comment :) – Peter Lang Apr 27 '10 at 14:30.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.