SQL & PL/SQL

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.

Getting this error "result of string concatenation is too long"

Kannan SekarFeb 11 2021

I need to do concatenate a name column based on id column. The concatenate string contains more than 4000 characters, so i'm getting this error "result of string concatenation is too long".. Please help me how to avoid this error..
CREATE TABLE T1 (ID NUMBER, NAME VARCHAR2(250));
INSERT INTO T1 (ID, NAME) VALUES (100, 'ASDFG');
INSERT INTO T1 (ID, NAME) VALUES (100, 'ASDFGHJHFRRD');
INSERT INTO T1 (ID, NAME) VALUES (100, 'QWERTYUIKJHGFDSAFGHYT');
output like:
--------------
id name
100 ASDFG, ASDFGHJHFRRD, QWERTYUIKJHGFDSAFGHYT.............................

User_64CKJ

The matter of the driver being on the run-time class-path of the applet, and its ability to connect to 'home' or remote servers is quite different.

The driver will need to be on the class-path for either. To achieve that, add the mssqlserver.jar to the archive attribute of the applet element.

To connect to a DB on a remote server, the applet would also need to be digitally signed (by you) and accepted (by the end user).

1 person found this helpful

835813

Thanks for you reply,
can you please tell me how to digitally sign the applet

835174

Hope this help:

<object
classid = "clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
width = 1 height = 1
name = "Application Web Client"
codebase = "http://java.sun.com/j2se/1.4.1/download.html">

<param name = CODEBASE VALUE = "." >
<param name = ARCHIVE VALUE = "myjar1.jar,
sqljdbc4.jar"
<param name = CODE VALUE = "applet.myapplet.class" >
<param name = NAME VALUE = "Application Web Client" >
<param name = "type" VALUE = "application/x-java-applet;version=1.1" >
<param name = CLIENT_INI VALUE = "client.ini">
</object>

Kayaman

832171 wrote:
Hope this help:
codebase = "http://java.sun.com/j2se/1.4.1/download.html">

Nicely done!

If they gave prizes for worthless advice here, you'd definitely get one.

User_64CKJ

..can you please tell me how to digitally sign the applet

See the Generating and Verifying Signatures lesson (http://download.oracle.com/javase/tutorial/security/apisign/index.html) of the Java Tutorial.

User_64CKJ

See also http://stackoverflow.com/questions/4897758/connecting-to-remote-databasemssqlserver-using-applet

803795

I suggest you have your applet talk to a servlet. The servlet actually talks to the database (and holds the userID/password). This way, you aren't embedding the userID/password to the database in the applet where someone might get it and have direct access ot your database (a security concern).

I also suggest you review your design to see if separation of concerns might be a better choice (model view controller (MVC) design).

1 - 7

Added on Feb 11 2021

#plsql, #sql

5 comments

951 views

SQL & PL/SQL

Getting this error "result of string concatenation is too long"

Comments

Post Details