Re: help: pass the parameter to the pl/sql

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Sun, 20 Jan 2002 08:05:30 +0200
Message-ID: <3C4A5E2A.A6F6EDEC@intersystemsww.com>

Sybrand Bakker wrote:

> On Tue, 15 Jan 2002 20:10:04 GMT,
> u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote:
>
> >we need to pass our parameter into our pl/sql
>

[SNIP]
> >but oracle does not allow us to do so, could somebody help me out?
> >
> >Thanks
> >
>
> No version, as usual
> In 8i and above, you need to use Native Dynamic SQL
> (Open <refcursor var> for :sqlstatement)
> In 8.0 and before you need to use dbms_sql.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

But Sybrand,
There's _only_ one version of Oracle -- the one we're using ;-) (Isn't it obvious?)

HTH,
Avi. Received on Sun Jan 20 2002 - 00:05:30 CST