Oracle Database Express Edition (XE)

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!

Pl/sql Procedure is Not Creating With the CLOB data Type

SHAN2009Nov 4 2009 — edited Nov 6 2009

Hi,

I am Using Oracle 10g Express Edition Release2.... My Doubt is While creating a table With CLOB Data Type the table is created successfully,but while Creating a Procedure With the CLOB Data type i am getting an Error Message

2667/5 PL/SQL: Statement ignored
2667/24 PLS-00382: expression is of wrong type

then i tried With the Varchar2(30000) the Procedure is Created Successfully note i have not changed any thing in my code except the data type.

I am Just Confused ......Why the Procedure is not Created with CLOB Data type?

Please advice ...

Thank U

SHAN

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2009

Added on Nov 4 2009

7 comments

2,129 views