Re: ?? Help needed calling stored procedure

From: Marc Scheuner <marc.scheuner_at_NO.SPAM.PLEASE.ch>
Date: 1997/07/21
Message-ID: <33d305f2.3474586@news.bernoise.ch>#1/1

Marc Billiet <Marc.Billiet_at_alcatel.be> wrote:
>> 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 :

Or you can set up a public synonym in Oracle for the procedure in the package and reference it that way:

create public synonym p_sp for p.sp

HTH
Marc

---

[ Marc Scheuner, marc.scheuner_at_berner.ch CH-3001 BERNE, Switzerland ]

---

Received on Mon Jul 21 1997 - 00:00:00 CDT