Re: CLOB as param type in stored proc

Try creating a CLOB and then appending your text to it. Then pass it.

Have you looked at the DBMS_LOB package?

or this: http://technet.oracle.com/doc/server.815/a68004/toc.htm

Daniel Morgan

Steffen Ramlow wrote:

> i want to know how i can execute the proc with a simple string e.g. via sql
> plus
>
> when it is a string i can call:
>
> begin
> xyz ('blaaaaaaaaaaaaaaaaaa');
> end;
>
> what do i have to type when it is a CLOB?
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
> news:3C756A4A.472C9F82_at_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 - 18:34:19 CST