Re: Trick to 'SELECT'ing Packages and procedures? (SQL*Plus)

You can't run procedures this way, you only can run *functions*, as procedures don't return anything.
When you run a procedure as a function, you'll get the invalid column name error.

So obviously your anchor procedure is a procedure, and it won't work in a select from dual; You'll need the plain old begin <procedure name>; end; syntax instead.

Regards,

Sybrand Bakker, Oracle DBA

"Kelly" <kgrigg_at_diamonddata.com> wrote in message news:8kkuik$o4k$1_at_nnrp1.deja.com...
> Hi all,
> I've been playing around with trying to create and use my own
> packages/procedure in WebDB. I have a question about using a procedure
> or function in a SELECT statement....is there a special permission or
> trick to this?
>
> I can create a procedure...say kelly.return_url
>
> and if I do SELECT kelly.return_url from dual; It works just fine.
> Well, now, I'm trying to use the oas_public.htp.anchor procedure....when
> I do
> SELECT oas_public.htp.anchor ('me.jpg','Click Here') from dual; I get a
> invalid column name error..pointing to anchor as the problem.
>
> This is all being run from SQL*Plus for right now....why is the
> htp.anchor procedure not being recognized as a procedure?
>
> TIA!!
>
> Kelly
> kgrigg_at_diamonddata.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 13 2000 - 00:00:00 CEST