Re: ?? Help needed calling stored procedure

Tomm Carr wrote:
>
> Nick Ivanov wrote:
> >
> > I have a store procedure "sp" in a package "p". I can invoke it
> > successfully in SQL Plus 3.3 using
> >
> > When I tried to use the TStoredProc component the name of the stored
> > procedure did not come up in the StoredProcName attribute popup menu.
> >
>
> Use TStoredProc. The only drawback is that, as you observed, the
> procedures within packages will not show up in the drop-down list.
> However, you can enter the name manually and it will work.

Another solution is to write a normal stored procedure that calls your packaged procedure :

create procedure p_sp(x in number) as
begin
  p.sp(x);
end;

if the overhead doesn't matter to you.

Marc Billiet Received on Fri Jul 18 1997 - 00:00:00 CDT