The "Make Perl code statement from SQL" uses Plus sign. It should use Period instead. (4302371)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The "Make Perl code statement from SQL" uses Plus sign. It should use Period instead.
Description

Select SQL code in the Editor and click on the button for "Make Perl code statement from SQL", the Perl code that it generates is incorrect. The code it generates uses the Plus sign between strings. It should use a Period instead. The strings should also be quoted with a single quote rather than double quotes. Otherwise certain symbols in the query can be erroneously interpreted by Perl as a variable.
Resolution

WORKAROUND:

As a workaround, you can edit/change how Toad does the conversion via View menu | Toad Options | Editor | Code Assist | “Make Code” section | highlight “Perl” | click on the “Edit” button.

STATUS:

Waiting for fix in a future release of Toad for Oracle.
Defect ID

CR114521

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title