using dbms_output.put_line in SQL Developer

[PAscal L]

Hi,
I just made a test using PostgreSQL (orafce 3.3, pg 9.5.1) with SQL developer (4.2), to see if dbms_output was working.

I seems that with SQL developer only one line is retrieved !?

My test case:

CREATE or replace FUNCTION exemple(integer,integer) RETURNS void AS '
begin
for c in $1..$2
loop
  perform dbms_output.put_line(to_char(c));
end loop;
end' LANGUAGE 'plpgsql';
/

select dbms_output.serveroutput(true) from dual;

select dbms_output.enable(1000) from dual;

do ' begin perform exemple(2,7);end; ';
/

output is:
2

[Pavel Stehule]

It doesn't looks like Orafce issue

When I run your example from psql, I get

postgres=# do ' begin perform exemple(2,7);end; ';
2
3
4
5
6
7
DO

Orafce uses following code for sending a message:

        pq_beginmessage(&msgbuf, 'N');

        /*
         * FrontendProtocol is not avalilable in MSVC because it is not
         * PGDLLEXPORT'ed. So, we assume always the protocol >= 3.
         */

#ifndef _MSC_VER

        if (PG_PROTOCOL_MAJOR(FrontendProtocol) >= 3)
        {

#endif

            pq_sendbyte(&msgbuf, PG_DIAG_MESSAGE_PRIMARY);
            pq_sendstring(&msgbuf, buffer);
            pq_sendbyte(&msgbuf, '\0');
   
#ifndef _MSC_VER

        }
        else
        {
            *cursor++ = '\n';
            *cursor = '\0';
            pq_sendstring(&msgbuf, buffer);
        }
       
#endif 

        pq_endmessage(&msgbuf);
        pq_flush();

Maybe SQL developer expecting some different protocol, maybe there is some bug in SQL developer.

What you see if you run:

do $$ begin for i in 1..10 loop raise notice '%', i; end loop; end $$;

?

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To post to this group, send email to orafce-general@googlegroups.com.
Visit this group at https://groups.google.com/group/orafce-general.

[PAscal L]

do $$ begin for i in 1..10 loop raise notice '%', i; end loop; end $$;

returns
1

[Pavel Stehule]

so it looks like SQL developer issue

Regards

Pavel

[PAscal L]

OK,
this comes from Oracle SQL developer ;o(