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.

Type conversion error in "Execute PL/SQL" wizard

sblandin1973Sep 11 2017 — edited Sep 12 2017

Hello,

I often use the Execute PL/SQL wizard provided by SQL Developer to rapidly invoke certain stored procedures.

The wizard usually does a great job converting the expression to the proper data type when assigning value to input parameters.

Today however I've noticed an improper conversion. When I write the vale 2.5 for a varchar2 input parameter, in the PL/SQL block it does not get enclosed in single quotes.

You can see the described bahaviour in the following screenshot

Can I safely assume that the numeric value 2.5 for PSTEP_CODE will be converted to the string '2.5'?

This post has been answered by Gary Graham-Oracle on Sep 11 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2017

Added on Sep 11 2017

#sql-developer

6 comments

323 views