Toad World® Forums

No DBMS_OUTPUT in sqlnav 5 --> error


#1

When I use DBMS_OUTPUT.put_line then no output is shown.

I do get the following error message:

11:38:39 Task “SQL Editor Execution”: OCI-22057: bad integer length [8]
11:38:39 SQL Editor Execution terminated with errors

Does anybody have any idea what might be wrong. DBMS_OUTPUT used to work

Thanks in advance

KoenC


#2

Hi!
What version of Oracle client do U have, and which wersion of oracle are you connected to.
Do you have server output turned on?
Try following
Turn server output on than,

begin
dbms_output.put_line(‘Hello’);
end;

Turn server ouput off , than rerun this block.


#3

On the serverside: Oracle 9i Release 9.2.0.7.0

SQL*Plus release 10.1.0.4.2

When I use DBMS_OUTPUT in sql plus then it works
Not from within SQL Navigator. If I turn serveroutput off in SQL Navigator than (of course) I don’t get the error 22057 in my output window.

Kind regards,

KoenC


#4

Ok , let sqlnav team speak …


#5

Hi Koen,

Can you please submit a support case along with all the client,server details along with support bundle.So that they will try to help you.

regards
sekhar


#6

Hi,

Could you please send us the script that causes this error. So far I couldn’t reproduce and have never seen this error in 10 years, and have no idea what could be causing it.

Thanks,
Roman