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?

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.

Locked on Apr 10 2018

Added on Mar 12 2018

#apex-5-1, #apex-discussions, #help, #text

1 comment

85 views

APEX

Help text length

Comments

Post Details