Ask the Expert

PL/SQL functions returning a string longer than 32767

I have a situation using PL/SQL functions where sometimes they return a string of length greater than 32767. Do you have a workaround for this?

    Requires Free Membership to View

In PL/SQL you can use the VARCHAR2 datatype to handle up to 32K. If you're finding that you have larger values than that, you'll need to look into a large object type i.e. CLOB. You could also use a LONG datatype but since Oracle has deprecated the LONG datatype, CLOB would be a better choice. With a CLOB you can actually handle up to 4GB!

For More Information

This was first published in November 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: