Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer 17.2 doesn't show DBMS Output

andre_dJul 12 2017 — edited Jul 24 2017

Hi,

I am testing version 17.2 of SQL Developer and have stumbled across this problem:

SQL Developer does not display the DBMS server output, neither in the connected DBMS Output window nor in the Script Output window.

To test I used the following code in a regular worksheet:

set serveroutput on;

begin DBMS_OUTPUT.PUT_LINE('this is dbms_output speaking'); end;

The DBMS Output window shows nothing, the Script Output window just outputs that the script ran successfully.

On the previous version of SQL Developer ( Version 4.2.0.17.089, Build 17.089.1709) this works as excpeted, showing the text in both windows.

I am using:

- SQL Developer (Version 17.2.0.188, with JDK included)

- Windows 7 Enterprise with German region settings

- Oracle 10g database with german NLS

Is this a bug or am I missing some sort of configuration option?

Regards, André

This post has been answered by Gary Graham-Oracle on Jul 18 2017
Jump to Answer

Comments

Srinath Menon-Oracle

ImageMagic_Watermark

Should it not have been

ImageMagick_Watermark

1025059

Hi Shrinath,

Thanks for your response. I am using "ImageMagic_Watermark" as a variable only. My question is does other Image magic commands like composite/draw/font etc work when we use it in extraRendition_definitions.hda. because the normal conversion as mentioned below works when used in the extraRendition_definitions.hda

convert -resize 300x300> "<$inFile$>"  "<$outFile$>.jpg"

I have the freetype delegate installed on the box, Is the there any further configuration needed

Regards

I have never seen that kind of configuration being set in extra renditions file and used . I am testing it as well to see if it works, will keep you posted with details once tests are completed .

1025059

Changed the command as mentioned below in the extraRendition_definitions.hda and it worked

<$inFile$> -resize 500x334^>  -pointsize 24  -draw "gravity south fill grey text 0,12 'Copyright'" <$outFile$>.jpg

Thanks and Regards,

Basudev

Exactly , I was about to put the same details .

Answer

Infact , the way I have done this is :

ImageMagick=/usr/local/bin/convert

ImageMagic_Watermark=-resize 352x300 -pointsize 24 -draw "gravity south fill white text 0,0 'copyright'"

@ResultSet ImageLibrary

6

extRenditionName

extEngine

extType

extSourceFile

extParameters

extDescription

MediumWatermark

<$ImageMagick$>

Extra

<$InFilePath$>

<$ImageMagic_Watermark$> "<$inFile$>"  "<$outFile$>.jpg"

Medium rendition in 352x300 pixels with watermark

@end

Marked as Answer by 1025059 · Sep 27 2020
1025059

Thanks Shreenath for responding to the query.

Regards

Glad to know you got this working .

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2017
Added on Jul 12 2017
10 comments
15,849 views