Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CLOB as param type in stored proc

Re: CLOB as param type in stored proc

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 21:44:22 GMT
Message-ID: <3C756A4A.472C9F82@ci.seattle.wa.us>


You will have to explain better what you don't understand. All I'm saying is that you can not pass a string into something and decide it is a CLOB. It must be a CLOB to start with. If you want to know how to work with CLOBs look at the DBMS_LOB package.

Daniel Morgan

Steffen Ramlow wrote:

> hu? and how to?
> ist must be a plain sql stmt
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
> news:3C753D92.39344007_at_ci.seattle.wa.us...
> > You must pass it a CLOB ... not a string.
> >
> > Daniel Morgan
> >
> >
> >
> > Steffen Ramlow wrote:
> >
> > > how must i call a stored proc
> > >
> > > like:
> > >
> > > procedure xyz (p1 clob)
> > > as
> > > ...
> > >
> > > begin
> > > xyz ('blaaaaaaaaaaaaaaaaaa');
> > > end;
> > >
> > > does not work..
> >
Received on Thu Feb 21 2002 - 15:44:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US