Re: CLOB as param type in stored proc

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Fri, 22 Feb 2002 00:57:22 +0100
Message-ID: <a541ie$4ijht$1@ID-54600.news.dfncis.de>

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 - 17:57:22 CST