Skip to Main Content

APEX

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!

Help text length

JabbampMar 12 2018 — edited Mar 13 2018

Hi there,

I have been migrating an application from 4.2 to 5.1 and ran into a little issue. The hep text for a page in the original application is about 7702 characters long. But when I try and copy this to the new application in 5.1, it cuts the text off at about 3900 characters.

Can the length of the help text be increased? Why has this been limited anyway? The old app has quite a few help text that needs copying and I believe many will be larger than 4000 characters.

Is there some setting to change? How can I display all the help-text?

Comments

John Thorton

post COPY & PASTE proof that you can successfully run any "sample.sql"  script

post content of xplan.sql file

You can COPY directly from Windows CMD terminal.

Orcl Apex

I am not able to run even select * from dual script.

Paulzip

Probably should be moved to the SQLcl forums.

Gaz in Oz

sqlcl version?

BluShadow

*** Moderator Note: Question now moved to the SQLcl product space as this is more about the tool than the SQL or PL/SQL languages.

Gary Graham-Oracle
Answer

There is a bug in 17.3 with a workaround:  set encoding UTF8

For example...

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 17.3.0.256.1818

SQL> show encoding

Encoding:WE8MSWIN1252

SQL> @ test.sql 

Oct 19, 2017 11:18:56 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor <init>

SEVERE: Could not process url:file:/C:/Tools/sqlcl/r17_3/sqlcl/bin/test.sql

Oct 19, 2017 11:18:56 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

SEVERE: java.io.Reader.<init>(Unknown Source)

java.lang.NullPointerException

        at java.io.Reader.<init>(Unknown Source)

        at java.io.BufferedReader.<init>(Unknown Source)

        at java.io.BufferedReader.<init>(Unknown Source)

        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.scriptParserInit(ScriptParser.java:87)

        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.<init>(ScriptParser.java:83)

        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.<init>(ScriptParser.java:75)

        at oracle.dbtools.raptor.newscriptrunner.FallbackParserProvider.<init>(FallbackParserProvider.java:22)

        at oracle.dbtools.raptor.newscriptrunner.SqlParserProvider.getScriptParserIterator(SqlParserProvider.java:25)

        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:169)

        at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(SQLPLUS.java:3870)

        at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:210)

        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(ScriptRunner.java:406)

        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:243)

        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:337)

        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:225)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:390)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:401)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1225)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:477)

SQL> set encoding UTF8

SQL> @ test.sql

D

-

X

SQL>

where test.sql contains "select * from dual;"

Marked as Answer by Orcl Apex · Oct 19 2017
BG4GRAPH

Hi,
this bug seems to have been reintroduced in SqlCl 21.3.
Notice that the workaround is not acceptable if the script does not have UTF8 encoding.

Yours,
BG4GRAPH.

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

Post Details

Locked on Apr 10 2018
Added on Mar 12 2018
1 comment
85 views