Skip to Main Content

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!

Pass CLOB from Perl to PL/SQL function

2810868Feb 2 2020 — edited Feb 4 2020

Hi gurus.

Kindly ask you advice on the following problem.

I'm developing function that processes input string. Client that calls function -- Perl client. Client sends a string up to 2 MB in size. Because of this CLOB is used for input variable in PL/SQL function:

create function aaa (Str in clob) return ...

The issue we faced is that nothing is actually passed from Perl to Oracle. Tracing of the data exchange shown that empty parameter is transferred to function.

On the same time we are able to insert that CLOB value from Perl into the table without any problems.

We investigated this but unfortunately found nothing relevant on this.

I will greatly appreciate help or advice on this issue.

Thank you in advance.

Comments

Post Details

Added on Feb 2 2020
11 comments
1,006 views