SQL Language (MOSC)

MOSC Banner

Problem Manipulating strings containing reserved characters in PL/SQL block

edited Mar 5, 2010 1:00AM in SQL Language (MOSC) 7 commentsAnswered
 I'm attempting to format a text file (32000 lines) so that no line is greater than 80 characters, and have written a pl/sql procedure to do this.

The procedure handles most of the data lines that need to be converted, but not lines like the following:

DELETE=so_chain_detail Upd so_module=D7PRST1_BAT06 so_task_name not_in ('D7PRST1_BAT0006A','D7PRST1_BAT0006B','D7PRST1_BAT0006C')

the pl/sql procedure loads each line of the text file into vc_fileline symbol using a cursor, and the problem seems to be that within pl/sql the following command:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center